Announcement

Collapse
No announcement yet.

Update Counters error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    This is a problem with MySQL 4.0.13. The fix is here:

    http://www.vbulletin.com/forum/showt...546#post463546

    Leave a comment:


  • candyman
    started a topic Update Counters error

    Update Counters error

    When I run the "Update Thread Info" under "Update Counters" in the admin section I get the following error:

    Database error in vBulletin Control Panel 2.3.0:

    Invalid SQL: UPDATE thread SET lastpost=1057338950,replycount=0,postusername='guest', postuserid='2', lastposter='guest',attach= WHERE threadid=16
    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=16' at line 1

    mysql error number: 1064

    Date: Friday 04th of July 2003 12:01:30 PM
    Script: http://myserver.com/forums
    Referer: http://myserver.com/forums/admin/misc.php

    Any idea why?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X