PDA

View Full Version : MySQL error number : 1064


tariqalali
Sat 1st Nov '03, 1:19pm
Greetings

I purged all threads over 1 year old then went to update the threads. When i tried to update the threads info i get the followings:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE thread SET lastpost=991424400,replycount=0,postusername='aziz ', postuserid='0', lastposter='aziz',attach= WHERE threadid=1999 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=1999' at line 1

mysql error number: 1064


THanking you in advance.

Regards

Tariq AlAli

Steve Machol
Sat 1st Nov '03, 1:20pm
This is a problem with MySQL 4.0.x. The fix is here:

http://www.vbulletin.com/forum/showthread.php?postid=463546#post463546