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
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
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
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
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
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
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/
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
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