SQL error: vb3_phrase is marked as crashed and should be repaired

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Julieh
    Member
    • Mar 2005
    • 51
    • 4.0.x

    SQL error: vb3_phrase is marked as crashed and should be repaired

    Hi!

    I've been having issues with the _phrase table, and getting this error:

    Error: Table './warunee_vbulletin/vb3_phrase' is marked as crashed and should be repaired

    Whole error:

    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT text, languageid, special
    FROM vb3_phrase AS phrase
    LEFT JOIN vb3_phrasetype USING (fieldname)
    WHERE phrase.fieldname = 'frontredirect'
    AND varname = 'login' AND languageid IN (-1, 0, 1);

    MySQL Error : Table './warunee_vbulletin/vb3_phrase' is marked as crashed and should be repaired
    Error Number : 145
    Date : Tuesday, January 8th 2008 @ 06:05:53 PM
    Script : http://forums.***.net/login.php?do=login
    Referrer : http://forums.***.net
    IP Address : ***
    Username : Julie
    Classname : vB_Database


    I've tried running repairs in both AdminCP and PHPMyAdmin a couple of times now, but it doesn't work. In AdminCP the error looks like the one in italics above, whilst in PHPMyAdmin it looks like this:

    Table Op Msg_type Msg_text warunee_vbulletin.vb3_phrase repair status Table is already up to date
    What can I do to fix this? :S

    I've already turned the board off using the SQL code found in this post.

    Thanks in advance,
    Julie
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    If the Admin CP repair isn't correcting the problem then you can try running a repair in the shell. If you have shell access to the server then try logging into the mysql prompt with this command:

    Code:
    mysql -u[color=red]username[/color] -p[color=red]password[/color] [color=red]databasename[/color]
    Then run this command at the mysql prompt:

    Code:
    REPAIR TABLE vb3_phrase;
    If the repair fails then often the mysql prompt will give additional error messages / error codes that can indicate what is wrong. For example, maybe your mysql partition is full or there is a problem with the file permissions. The error codes will usually indicate stuff like that.

    Comment

    • Julieh
      Member
      • Mar 2005
      • 51
      • 4.0.x

      #3
      Hm, ok. I'll ask my host to try that out and see what happens. I'm also talking to a Wayne Luke about this, and I've done what he suggested, but that didn't work :/

      Edit:

      He got this:

      | Table | Op | Msg_type | Msg_text |
      +------------------------------+--------+----------+-----------------------------+
      | warunee_vbulletin.vb3_phrase | repair | status | Table is already up to date |

      Comment

      • Jake Bunce
        Senior Member
        • Dec 2000
        • 46598
        • 3.6.x

        #4
        The repair appears to have worked. Are you still getting the error?

        Comment

        • Julieh
          Member
          • Mar 2005
          • 51
          • 4.0.x

          #5
          Originally posted by Jake Bunce
          The repair appears to have worked. Are you still getting the error?
          Yes I am

          Comment

          • Jake Bunce
            Senior Member
            • Dec 2000
            • 46598
            • 3.6.x

            #6
            If it still doesn't work then we will need to take a look. Please submit a trouble ticket with your forum and server info:

            Comment

            • Julieh
              Member
              • Mar 2005
              • 51
              • 4.0.x

              #7
              Originally posted by Jake Bunce
              If it still doesn't work then we will need to take a look. Please submit a trouble ticket with your forum and server info:

              http://members.vbulletin.com/members...ontactform.php
              I have already opened a ticket (Ticketid: 757205), so perhaps we could continue in that one? I THINK I added the forum/server info when I first opened the ticket, but I can't see it. If you can't either, let me know and I'll do it again

              Comment

              • Jake Bunce
                Senior Member
                • Dec 2000
                • 46598
                • 3.6.x

                #8
                Wayne is handling your ticket. He can help you if you update that ticket.

                Comment

                • Julieh
                  Member
                  • Mar 2005
                  • 51
                  • 4.0.x

                  #9
                  Originally posted by Jake Bunce
                  Wayne is handling your ticket. He can help you if you update that ticket.
                  I have updated the ticket, but he hasn't said anything after that. Perhaps he's just having a hard time figuring it out :P

                  Comment

                  • westpointer
                    Member
                    • Mar 2004
                    • 61

                    #10
                    I've seen this problem in the past month on two sites that I admin. I both cases, I could not repair the phrases table. I had to drop the table, then load a version from another vb install I have.

                    Weird coincidence or something odd in the code. I don't know.

                    Comment

                    • Endurer
                      New Member
                      • Aug 2006
                      • 24
                      • 3.6.x

                      #11
                      I am having this problem right now. Seems like i'll have to drop the table all together like westpointer.
                      Desi Friends | Desi Forums
                      Bollywood Ringtones | Desi Recipes

                      Comment

                      • twitch
                        Member
                        • Apr 2005
                        • 97
                        • 4.2.x

                        #12
                        how do you drop the table? does it get added back after upgrade?

                        Comment

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