Error updating threads

[DigiCrime]

Hi

Looking to get my board pruned posts and usernames so I can update my software to version 3

I get this error when trying to run this

Thread ids:

Processing thread 1999
P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}

There seems to have been a slight problem with the Kansas F-Body Association database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin Control Panel 2.3.0:
Invalid SQL: UPDATE thread SET lastpost=1044641993,replycount=0,postusername='KsKid', postuserid='303', lastposter='KsKid',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: Friday 06th of August 2004 08:29:26 AM
Script: http://www.ksfba.org/forums/forums/admin/misc.php
Referer: http://www.ksfba.org/forums/admin/misc.php?


Is this something updating to the newest version will fix ?

[Floris]

Try uploading the original 2.3.0 admin/misc.php file in ascii transfer mode again.

Do you have any hacks installed that made changes to the thread table?

[DigiCrime]

Nope, not really only changes made to the board is the skin/template and I remove user post counts, except to be viewd only in their profile. Not sure if I had the old Vb laying around anymore

[DigiCrime]

Just reminded me of something to

Invalid SQL: UPDATE thread SET lastpost=1044641993,replycount=0,postusername='KsK id', postuserid='303', lastposter='KsKid',attach= WHERE threadid=1999

If that user doesnt exist, it would error out I guess ? I deleted about 300 users on the board

[Freddie Bingham]

Its a mysql bug that you can fix by upgrading to v2.3.5