MySQL Errors when Updating Counters [Archive]

View Full Version : MySQL Errors when Updating Counters

macrumors

Fri 31st Oct '03, 12:06am

MySQL 4.0.15-standard
vBulletin 2.3.0

When I run Update Counters: Update Thread Info - update thread post counts, original posters, last post date, attachment totals

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1013200126,replycount=3,postusername='bri tboy', postuserid='2669', lastposter='britboy',attach= WHERE threadid=1997
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=1997' at line 1

mysql error number: 1064

Date: Thursday 30th of October 2003 11:05:19 PM
Script: http://forums.macrumors.com/admin/misc.php
Referer: http://forums.macrumors.com/admin/misc.php?action=chooser&

Thread 1998, 1999 had the same problems... which I deleted, and the problem still pops up.

I ran repair database, no luck.

arn

Steve Machol

Fri 31st Oct '03, 1:15am

macrumors

Fri 31st Oct '03, 1:23am

This sounds just like the problem with MySQL 4.0.13. I haven't heard of this problem with MySQL 4.0.15 but you can try the fix here:

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

Thanks, that seems to have done the trick.

Yeah... I had seen the issues with 4.0.13, but had hoped the 15 fix had resolved them.

arn

cybermomcafe

Tue 16th Dec '03, 3:21pm

I'm having this problem now... and the server is running 4.0.15

any ideas...

Thanks, that seems to have done the trick.

Yeah... I had seen the issues with 4.0.13, but had hoped the 15 fix had resolved them.

arn

Steve Machol

Tue 16th Dec '03, 3:51pm

You still need to either apply the fix in the link I posted, or upgrade to 2.3.3.

cybermomcafe

Tue 16th Dec '03, 4:33pm

:) Yeah, for some reason I missed the fix for admin/misc.php (wasn't paying attention I guess LOL) that took care of it!