Quote:
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