Announcement

Collapse
No announcement yet.

Help! Database Crashed

Collapse
X
 
  • 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
    Script: http://www.aquariumpros.com/forums/f...admin/misc.php
    Referer: http://www.aquariumpros.com/forums/admin/misc.php

  • #2
    Have you edited any files?

    Comment


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

      Comment


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

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

        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.


        Comment

        Loading...
        Working...
        X