No announcement yet.

Database error in vBulletin Control Panel 2.2.6:

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in vBulletin Control Panel 2.2.6:


    Have recently been having problem while updating 'Update Thread Info - update thread post counts, original posters, last post date, attachment totals' The error is as below

    Database error in vBulletin Control Panel 2.2.6:
    Invalid SQL: UPDATE thread SET lastpost=1078818423,replycount=0,postusername='administrator', postuserid='1', lastposter='administrator',attach= WHERE threadid=797
    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=797' at line 1

    Why is this happening...Also i have recently been having numerous problems with the SQL database... What is the best version to be on ...

    I am currently running on vBulletin Version 2.2.6

    Please advice..



  • #2
    This is because of MySQL 4.0.13 - Ask your host to upgrade or do this, or upgrade your vBulletin:

    To fix, open up admin/misc.php and find:
    PHP Code:
    and replace with
    PHP Code:
    attach=" . intval($attachsum) . " 


    • #3
      You really should upgrade to 2.3.4 as well. Your version has a number of bugs and security holes.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography

      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.