Announcement

Collapse
No announcement yet.

MySQL Error Number: 126, Incorrect key file for table '.phrase.MYI';

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

  • MySQL Error Number: 126, Incorrect key file for table '.phrase.MYI';

    Please advise. I get this error when I try to edit the Email Body for Notify.

    Database error in vBulletin 3.6.4:


    Invalid SQL:

    DELETE FROM phrase
    WHERE varname = 'notify' AND
    fieldname = 'emailbody'

    AND languageid <> -1;


    MySQL Error : Incorrect key file for table '.phrase.MYI'; try to repair it
    Error Number : 126






    .

  • #2
    Try running a repair:

    Admin CP -> Maintenance -> Repair / Optimize Tables

    Run it twice to make sure it comes back clean the second time.

    Comment


    • #3
      To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

      Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

      If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.
      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


      • #4
        I try repairing the database and I get this message.

        phrase Check Error: Table './_vbulletin/phrase' is marked as crashed and should be repaired
        .

        Comment


        • #5
          Yes, because it's crashed. What did you do exactly?
          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


          • #6
            I just try to edit the Email Body for Notify in the admincp and I get that database error message.

            What should I do now?
            .

            Comment


            • #7
              If the repair feature in the Admin CP doesn't work then you can also try repairing it 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 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


              • #8
                You need to repair the database a per posts #2 and #3.
                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


                • #9
                  When I repair in SSH I get this.

                  mysql> REPAIR TABLE phrase;
                  +---------------+--------+----------+-----------------------------+
                  | Table | Op | Msg_type | Msg_text |
                  +---------------+--------+----------+-----------------------------+
                  | _vb.phrase | repair | status | Table is already up to date |
                  +---------------+--------+----------+-----------------------------+
                  1 row in set, 2 warnings (0.01 sec)

                  Then I tried the repair in admincp again, but I still get this error.

                  phrase Check Error: Table './_vb/phrase' is marked as crashed and should be repaired
                  .

                  Comment


                  • #10
                    Please see these instructions for the available methods to repair a database:

                    http://dev.mysql.com/doc/refman/5.0/en/repair.html
                    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


                    • #11
                      How to run myisamchk?

                      Is that what I should do?
                      .

                      Comment


                      • #12
                        I think the repair command is the same as myisamchk. The repair command you ran reported that everything was fine.

                        Comment

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