Update Thread Info Error

[DannyBoy8406]

ok, whenever i try to update my thread info I get an SQL error...it reads as follows

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE thread SET lastpost=1059575913,replycount=13,postusername='Al essandra', postuserid='3', lastposter='Kimmy',attach= WHERE threadid=24
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=24' at line 1

mysql error number: 1064

Date: Thursday 21st of August 2003 05:35:45 PM
Script: http://www.wb-devotions.com/admin/misc.php
Referer: http://www.wb-devotions.com/admin/misc.php?action=chooser&


According to what i have backed up the Query in misc.php is what its supposed to be like.....can anyone tell me whats going on?

[assassingod]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=54118" target="_blank">https://vborg.vbsupport.ru/showt...threadid=54118</a>

[DannyBoy8406]

ok...tells me what it means, but doesn't really explain how to fix it...

[assassingod]

It's probably caused by the last hack you installed. Try contacting the author for further help.

[lifesourcerec]

I'm in the same situation. I've installed a number of hacks and never ran update thread info. I'm thinking it has to do with the multiple attachment hack, but not positive.

[Steve Machol]

This is a problem with MySQL 4.0.13. The fix is here:

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

[lifesourcerec]

Did that Steve, and that worked also :) Hopefully that's the last time I have to mess with misc.php for a while :)