Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rdrunnr
    New Member
    • May 2006
    • 18
    • 3.5.x

    Database Error

    My site has crashed and I am getting the following database error. Can someone please suggest a quick, easy way to fix this? I am not sure hwo to repair this. Thanks!

    Database error in vBulletin 3.7.0:
    Invalid SQL:
    SELECT varname, text
    FROM phrase
    WHERE fieldname = 'vbsettings' AND
    languageid IN(-1, 0, 1)
    ORDER BY languageid ASC;
    MySQL Error : Table './clickc3_vbforums/phrase' is marked as crashed and should be repaired
    Error Number : 145
  • Paul M
    Former Lead Developer
    vB.Com & vB.Org
    • Sep 2004
    • 9886

    #2
    Use the repair option in the maintenance section of the ACP.
    Baby, I was born this way

    Comment

    • rdrunnr
      New Member
      • May 2006
      • 18
      • 3.5.x

      #3
      I just tried that and for results I still get:

      phraseCheckError: Table './clickc3_vbforums/phrase' is marked as crashed and should be repairedphrase


      When I hit repeat process, I keep getting the same result.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        You will have to keep running this until you no longer that that error.
        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

        • rdrunnr
          New Member
          • May 2006
          • 18
          • 3.5.x

          #5
          I must have hit the repeat process button 200 times already. Do I just keep hitting it until the message goes away?

          Comment

          • Paul M
            Former Lead Developer
            vB.Com & vB.Org
            • Sep 2004
            • 9886

            #6
            Nope, if it doesnt repair in about 3 attempts then its never going to, last time I had this I had to drop the table and restore it from my backups.
            Baby, I was born this way

            Comment

            Related Topics

            Collapse

            Working...