MySQL error

[Rich Z]

INSERT INTO class_comments (id,username,userid,date,comment,product,cat,approved,ipaddress) values(NULL,'zztrent',5185,1116531888,'all gone',522,,'0','24.209.81.204')

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''0','24.209.81.204')' at line 1

Sorry, but since I need to manually update my system, I guess I'm going to need the specific patches as I run into the errors.

[Chuck S]

Rich

Look at your comments.php and tell me what you see based on what I post here. I see no issue that I can find on this.

Lines 60-62 of comments.php are this which grabs the cat variable which your query is missing

Content visible to verified customers only.

Then at around line 166 we insert the comment into the database

Content visible to verified customers only.

Let me know if your code varies from this as all I can do is look at the code we have now. I do not have earlier versions to look at.

[Rich Z]

Here's the lines 60-63:

Content visible to verified customers only.

Then line #166 is

Content visible to verified customers only.

Hmm, they look the same to me, but obviously I am getting a MySQL error.

[Frost]

Looks like the query doesn't return anything so $thiscat is empty.

[Rich Z]

Well, I get SOME error about once a day, it seems.

Just got this one a few minutes ago:

An error was encountered during execution of the query:

INSERT INTO class_products (id,user,userid,cat,date,title,description,keywords,bigimage,bigimage2,bigimage3,approved,watermarked,ipaddress)
values(NULL,'themselves', 17876, , 1116774887, '2 Adult Female Southern Flying Squirrels', '', '', '', '', '',
1, '', '24.158.212.63')

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1116774887, '2 Adult Female Southern Flying Squirrels', '', ''