1064

[cirisme]

Originally Posted by mariannet

Hi there

I know there is a lot of treads about 1064, but I try here anyway ;0)

I get this when trying to "Update Thread Info":
************************
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1056897578,replycount=13,postusername='Fr eja', postuserid='8', lastposter='Freja',attach= WHERE threadid=1996
mysql error: 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 'WHERE threadid=1996' at line 1

mysql error number: 1064
************************

Are you using MySQL 4?

I ran into the same problem... it's because MySQL will return NULL when count(_) contains nothing, not 0, so you need to find this line and intval() it