PDA

View Full Version : Getting Mysql Error No. 1064


MikeJeffs
Thu 3rd Jul '03, 11:37pm
I've been getting some database problems over the last 24 hours. I've been running repair.php which has cleared them up each time. I've since done some maintinance on the forum and in control panel the "Update Thread Info" is giving me the following problem.

Any ideas how to fix it?
thanks

Database error in vBulletin Control Panel 2.2.6:
Invalid SQL: UPDATE thread SET lastpost=1008294000,replycount=31,postusername='HI JINX', postuserid='288', lastposter='Munu\'ver',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
Date: Thursday 03rd of July 2003 07:25:06 PM
Script: http://www.ukbboy.info/forum/forum/admin/misc.php
Referer: http://www.ukbboy.info/forum/admin/misc.php?action=chooser&s=

Steve Machol
Thu 3rd Jul '03, 11:49pm
http://www.vbulletin.com/forum/showthread.php?postid=463546#post463546

Since you are trunning an older version of vB, the fix may be on a different line that the one in this thread.

MikeJeffs
Fri 4th Jul '03, 12:10am
Thanks, problem solved :)