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

[Byron]

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

[Jake Bunce]

Try running a repair:

Admin CP -> Maintenance -> Repair / Optimize Tables

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

[Steve Machol]

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.

[Byron]

I try repairing the database and I get this message.

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

[Steve Machol]

Yes, because it's crashed. What did you do exactly?

[Byron]

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?

[Jake Bunce]

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:

mysql -u[color=red]username[/color] -p[color=red]password[/color] [color=red]databasename[/color]

Then run this command at the mysql prompt:

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.

[Steve Machol]

You need to repair the database a per posts #2 and #3.

[Byron]

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

[Steve Machol]

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

http://dev.mysql.com/doc/refman/5.0/en/repair.html

[Byron]

How to run myisamchk?

Is that what I should do?

[Jake Bunce]

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