No announcement yet.

Help! Database Crashed

  • Filter
  • Time
  • Show
Clear All
new posts

  • Help! Database Crashed

    using VB 2.30 and Mysql 4.014:

    Forums are down. I tried to do database mainetenace and got the error shown below. I ran repair.php and the problem is still there.

    Database error in vBulletin Control Panel 2.3.0:
    Invalid SQL: UPDATE thread SET lastpost=1062630465,replycount=2,postusername='amandalou', postuserid='327', lastposter='amandalou',attach= WHERE threadid=1667
    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=1667' at line 1

    mysql error number: 1064

    Date: Friday 05th of September 2003 04:22:44 PM

  • #2
    Have you edited any files?


    • #3
      Originally posted by tubedogg
      Have you edited any files?
      No. This happened last night sometime for no apparent reason.


      • #4
        This is a problem with MySQL 4.0.13 but not 4.0.14 as far as I know. The fix is here:

        Or you can upgrade to 2.3.2 which already contains this fix.
        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.