Fwd: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Re: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an applica

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an applica

Fwd: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Fwd: Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I found a syntax error which caused the 1602 error and corrected it. I am now back to struggling with the '1064 - You have...' error. Unfortunately, I have been unable to find any reference to this particular error. --- Begin Message --- I streamlined the application so as to target the offending

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I found the following by performing a google search: 1602 Btree unpacked page size (from header) does not match size loaded from disk Not sure what this means, but still looking for a better error reference. The link found in the google search was: http://www.clarionmag.com/cmag/v1/v1n1tpserro

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. >>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/

Re: MySQL error code 1064

2003-07-25 Thread David Precious
On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. > The message text in my

MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statemen