Urgent: Thread UpDate Counter Error??

[David Copeland]

We have version 2.2.6

When updating the counters for the THREAD INFO, we are geting the following error:

Database error in vBulletin Control Panel 2.2.6:
Invalid SQL: UPDATE thread SET lastpost=1011294707,replycount=6,postusername='Bill Swartz', postuserid='1314', lastposter='David Copeland',attach= WHERE threadid=1994
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=1994' at line 1
mysql error number: 1064
Date: Monday 16th of February 2004 01:34:38 PM
Script: http://www.ipiu.org/forums//forums/admin/misc.php
Referer:

[David Copeland]

Is there a patch that came out for this???

All the other update counters are okay.

[Freddie Bingham]

Yes, there is a bug in mysql that causes this. The latest version of vB 2.3.4 has this fixed.

[David Copeland]

Can we do a straight upgrade from 2.2.6 to 2.3.4?

[Steve Machol]

Yes:

http://www.vbulletin.com/members/upgrade.html