Got error 127 from storage engine

[B-pLeAsE]

I got about 400 emails from letting me know of the following.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid, visible, userid
FROM post AS post

WHERE threadid = 233005
AND visible IN (1
,2

)

ORDER BY dateline;

MySQL Error : Got error 127 from storage engine Error Number : 1030
Date : Monday, April 9th 2007 @ 12:51:16 PM
Script : http://www.siccness.net/vb/showthread.php?t=233005
Referrer : http://www.siccness.net/vb/forumdisplay.php?f=59
IP Address : xx.xxx.xxx.xx
Username : xxxxx
Classname : vb_database

[Floris]

Error code 127: Unknown error 127

127 = Record-file is crashed
Can be fixed by running optimize and repair on the table.




Admin Control Panel

It is possible to repair selected tables within the admin control panel, this assumes that none of the tables affected prevent the admin panel from being accessed.
The Repair Tables option is under the Maintenance group, only those that need repaired should be ticked as this is a very intensive operation and results in table locking while the repair is run.
[edit]
phpMyAdmin / MySQL Command Line

A repair query can be run directly against the database using the following syntax.
Code:
REPAIR TABLE x