vBulletin Database Error

[bryanh23]

I recently was moved from Photon to Phoenix. My site was working wonderfully for a few hours, then yesterday for some reason I was moved to Copper. Now all I get is this database error when I go to my forums. Does anyone have an idea how to fix this?

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

[Coyote]

Its a CPanel issue.

CPanel is causing corruption each night.

Drop into Shell and type

mysqlcheck -A --auto-repair

It will autorepair all your DB's

[Coyote]

Sorry

mysqlcheck -A -uUSERNAME -p --auto-repair

It will ask for your SSH password - type it in and away it goes

[bryanh23]

Thanks for the quick response, Coyote. I might end up having to do this if the problem persists. I ended up doing a search on vbulletin.com and they have a repair.php file that will correct this for vbulletin users. It might be helpful so here's the link:

[How-To]Fixing thread.MYI Errors

[Coyote]

Thanks, I dont have VB, but its interesting to know.

The shell command is quick and safe too

[Julian Muñoz]

There is also a hack on vb.org that will attempt to fix the database when the problem arise... It's in the beta forum.

[Blackhat]

I've had this problem twice today and I'm using InvisionBoard forums. Someone at IBforums support said that they need to rebuild Apache, from CPanel's "EasyApache to prevent this from happening in the future..

[Coyote]

go into CPanel and find out what version of MySQL you have. It maybe that they havent downgraded you from mysql 4 yet

ALthough the problem isnt directly with mysql, its a combination of cpanel and mysql. CPanel is forcing php to php libraries for controlling mysql and not letting php using the libraries provided by mysql.

Hope that makes sense.

If your downgraded and the problems still there, run the repair command above and see if it comes back.