Membership questions? Log in issues? Email info@brewersassociation.org

Author Topic: NHC Second Round Recipe Entry  (Read 8228 times)

Offline kcschmitt

  • 1st Kit
  • *
  • Posts: 9
NHC Second Round Recipe Entry
« on: April 27, 2014, 11:16:14 pm »
Is anybody else receiving this error when they click "edit" on their entries to input recipe information?

Array (
  • => Array (
  • => 42000 [SQLSTATE] => 42000 [1] => 209
    Code: [Select]
    => 209 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'id'. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'id'. ) )
Beer is my obsession

Offline udubdawg

  • Senior Brewmaster
  • ******
  • Posts: 1081
Re: NHC Second Round Recipe Entry
« Reply #1 on: April 28, 2014, 07:00:32 am »
work in progress; Friday there wasn't an Edit button.   8)

I'm sure it will work soon.

Offline bengelbrau

  • Assistant Brewer
  • ***
  • Posts: 146
Re: NHC Second Round Recipe Entry
« Reply #2 on: April 28, 2014, 09:16:45 am »
Is anybody else receiving this error when they click "edit" on their entries to input recipe information?

Array (
  • => Array (
  • => 42000 [SQLSTATE] => 42000 [1] => 209
    Code: [Select]
    => 209 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'id'. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name 'id'. ) )
Yup

Offline okbecker

  • 1st Kit
  • *
  • Posts: 3
Re: NHC Second Round Recipe Entry
« Reply #3 on: April 28, 2014, 12:28:05 pm »
Yes, I emailed Janis and got an auto reply that states they are working on it.

Offline braufessor

  • Brewer
  • ****
  • Posts: 354
Re: NHC Second Round Recipe Entry
« Reply #4 on: April 28, 2014, 12:36:20 pm »
Are there any deadlines/time-frames with second round entries at this point?  Anything that needs to be done in the near/immediate future?

Thanks

Offline dkfick

  • Senior Brewmaster
  • ******
  • Posts: 1054
Re: NHC Second Round Recipe Entry
« Reply #5 on: April 28, 2014, 12:41:26 pm »
Are there any deadlines/time-frames with second round entries at this point?  Anything that needs to be done in the near/immediate future?

Thanks
You should have your entries to Perrin Brewing Company between May 19th and June 2nd.
BJCP A0936 National Beer Judge and Mead Judge
Cicerone Certified Beer Server
AHA Member
CRAFT Homebrew Club
Sons of Liberty Homebrew Club
HBT "mors"

Offline mcdform

  • 1st Kit
  • *
  • Posts: 23
Re: NHC Second Round Recipe Entry
« Reply #6 on: April 29, 2014, 01:33:48 am »
The recipe sheet was sort of working today.  It let me input my recipe but wouldn't allow me to submit it.  It kept stating that I needed to select a style from a drop down menu but the drop down menu didn't exist and the style was already listed automatically.

All the submission entry for me was for NHC 2013 (which I didn't enter) so the drop off dates and location are both wrong.  The original letter I downloaded had all of the correct info but the letter attached to the "finals" site didn't have any info.  I'm sure they will work all this out before time to ship.
Experimental 1 Gallon Batches Weekly - http://brew52.blogspot.com

Offline bengelbrau

  • Assistant Brewer
  • ***
  • Posts: 146
Re: NHC Second Round Recipe Entry
« Reply #7 on: April 29, 2014, 07:03:18 pm »
Kyle, I tried the recipe sheet a few minutes ago, and it worked.

Offline bengelbrau

  • Assistant Brewer
  • ***
  • Posts: 146
Re: NHC Second Round Recipe Entry
« Reply #8 on: April 29, 2014, 07:20:58 pm »
I could enter the recipe, but can't seem to print or edit. Will try again tomorrow.

Offline ranchovillabrew

  • Brewer
  • ****
  • Posts: 321
Re: NHC Second Round Recipe Entry
« Reply #9 on: April 29, 2014, 07:26:52 pm »
I could get it to work in mozilla but not in chrome

Sent from my SCH-I545 using Tapatalk

- Charles

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7781
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #10 on: May 19, 2014, 09:45:52 pm »
I still can't get it to work in Chrome.

this is what I get.


SQLSTATE: 42000
code: 102
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '2'.
SQLSTATE: 42000
code: 105
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Unclosed quotation mark after the character string ' '.
SQLSTATE: 01000
code: 16954
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce

Offline ranchovillabrew

  • Brewer
  • ****
  • Posts: 321
Re: NHC Second Round Recipe Entry
« Reply #11 on: May 19, 2014, 09:52:28 pm »
I had to use mozilla

Sent from my SCH-I545 using Tapatalk

- Charles

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7781
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #12 on: May 20, 2014, 12:02:31 am »
It's wierd. I got one entered but the other one still throws this error. I used IE 348.9 (or whatever) to get the one in but when I tried to enter the second one it fails.
"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce

Offline dkfick

  • Senior Brewmaster
  • ******
  • Posts: 1054
Re: NHC Second Round Recipe Entry
« Reply #13 on: May 20, 2014, 06:06:52 am »
I still can't get it to work in Chrome.

this is what I get.


SQLSTATE: 42000
code: 102
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '2'.
SQLSTATE: 42000
code: 105
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Unclosed quotation mark after the character string ' '.
SQLSTATE: 01000
code: 16954
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
Are you using an apostrophe in any of your fields?  Sounds like they are not cleaning the fields before throwing them into SQL...
BJCP A0936 National Beer Judge and Mead Judge
Cicerone Certified Beer Server
AHA Member
CRAFT Homebrew Club
Sons of Liberty Homebrew Club
HBT "mors"

Offline udubdawg

  • Senior Brewmaster
  • ******
  • Posts: 1081
Re: NHC Second Round Recipe Entry
« Reply #14 on: May 20, 2014, 06:17:18 am »
beer recipe went smoothly but for cider had a lot of errors before I figured out what characters it didn't like in certain spots.