Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #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 -uusername -ppassword databasename
    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


    • #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


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

        Comment


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

          Comment


          • #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:

            http://members.vbulletin.com/members...ontactform.php

            Comment


            • #7
              Originally posted by Jake Bunce View Post
              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


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

                Comment


                • #9
                  Originally posted by Jake Bunce View Post
                  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


                  • #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


                    • #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


                      • #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...
                        X