mysql error #:1016

[jmg85]

Hey Im having a problem with my VBulletin. It seems that the host upgraded the PhP to the new version. Any help would be appreciated!

EDIT: Also I run the repair.php and it repairs it fine, just like an hour later I get the same error again, and need to go back to the repair.


Here is the error I recieve

Database error in vBulletin 3.0.9:
Invalid SQL: SELECT COUNT(*) AS count FROM post WHERE dateline >= '1138488233'
mysql error: Can't open file: 'post.MYI' (errno: 144)
mysql error number: 1016
Date: Saturday 28th of January 2006 05:31:37 PM
Script: http://www.absolute-guild.com/

[Floris]

Hi there,

Can't open file: '<table>.MYI'. (errno: 144)

Error 144 = Table is crashed and last repair failed

You should run optimize & repair on your database tables. You can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If this repair fails you have to ask your hosting provider to take a look.