i'm having this database error

[msimplay]

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1055889283,replycount=4,postusername='Tan ny', postuserid='85', lastposter='KALKI',attach= WHERE threadid=1163
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=1163' at line 1

mysql error number: 1064

Date: Wednesday 18th of June 2003 03:18:37 AM
Script: http://www.wambam.net/Vbulletin/Vbulletin/admin/misc.php
Referer:


it happens when i try to Update Thread Info from admin cp
please help

[Erwin]

Mmm... an attachment is missing? Something is wrong in that thread...

Go here:

http://www.wambam.net/Vbulletin/showthread.php?threadid=1163

And delete the attachment, or delete the whole thread if you don't need, and try again...

[msimplay]

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1055887296,replycount=39,postusername='wA mbAm', postuserid='1', lastposter='Ree',attach= WHERE threadid=1162
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=1162' at line 1

mysql error number: 1064

Date: Wednesday 18th of June 2003 03:41:11 AM
Script: http://www.wambam.net/Vbulletin/Vbulletin/admin/misc.php
Referer:


now i get this :(
p.s theres are no attachments in that thread :s

[Erwin]

Did you hack your misc.php? Try uploading an unhacked one.

The query you are trying to run:


UPDATE thread SET lastpost=1055887296,replycount=39,postusername='wA mbAm', postuserid='1', lastposter='Ree',attach= WHERE threadid=1162


will not work since there is nothing in "attach=" - see where it runs into trouble? The issue is finding out why.

[msimplay]

yeh tried that
i was thinkin they might ave changed the mysql on server and its causing errors now

is this possible

[msimplay]

now its just moved on again
after deleting that thread

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1055886725,replycount=11,postusername='Th ugangel', postuserid='19', lastposter='Tanny',attach= WHERE threadid=1160
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=1160' at line 1

mysql error number: 1064

Date: Wednesday 18th of June 2003 04:18:02 AM
Script: http://www.wambam.net/Vbulletin/Vbulletin/admin/misc.php
Referer:

[msimplay]

It seems to be a problem when there is no attachment in the post

[msimplay]

i dont understand it the Misc.php is default

[msimplay]

erm is it serios if i can't update the threads ?