Database crashed, need help

[kartik786]

I'm getting the following error when posting any thread.

The homepage does not open,

Internal pages open fine, But when I open new thread, it gives a database error.

Database error in vBulletin 3.8.3:

Invalid SQL:

			SELECT thread.threadid, MATCH(thread.title) AGAINST ('testing') AS score
			FROM thread AS thread
			
			WHERE MATCH(thread.title) AGAINST ('testing')
				AND thread.open <> 10
				
				
			LIMIT 5;

MySQL Error   : Incorrect key file for table './database_name/thread.MYI'; try to repair it
Error Number  : 126
Request Date  : Saturday, July 30th 2011 @ 01:32:52 PM
Error Date    : Saturday, July 30th 2011 @ 01:32:54 PM
Script        : http://www.website.comforums/newthread.php?do=postthread&f=12
Referrer      : http://www.website.com/forums/newthread.php?do=newthread&f=12
IP Address    : 116.73.21.8
Username      : admin
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.92-community-log

I repaired the database but this problem still remains the same.

[BirdOPrey5]

Did you run repair on the thread table? Sometimes more than once. Do you have the ability to restart mysql on the server? Couldn't hurt if you can.

Make sure your disk space isn't close to full.

[kartik786]

thanks birdoprey5

My hosting guys somehow managed to optimize it but the server mysql is getting thrashed with load and they suggest we seperate mysql and apache to 2 servers.

They dont know how to connect the database string. Any clue on that?

[BirdOPrey5]

I don't know what the database "string" is but if you do move the database to another server I know you will have to make changes in your config.php file to tell it the details of the database server.

[kartik786]

Thanks Birdoprey

For everyone landing here through google search, here's the solution

If this keeps happening over and over again after reparing the tables, then this is a server issue. You need to contact your host.

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.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

https://www.vbulletin.com/forum/show...threadid=44909

You may have to ask your host to try and repair this for you.