help! database error!

[Keyser520]

I'm not sure what happened, but my vbulletin just killed itself. I havne't made any changes recently, it just stopped working about 5 min ago.

Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT title, template
FROM template
WHERE templateid IN
(771,763,772,773,774,764,706,707,709,716,715,989,818,805,806,808,807,0,813,815,817,618,620 ,622,624,933,1094,1071,932,790,988,757,1088,930,939,776,777,778,779,891,944,943,945,948,67 4,660,657,673,658,659,661,662,663,664,618,620,622,624,769,765,767,768,819,820,770,766,928) ;
MySQL Error : Got error 127 from table handler
Error Number : 1030
Date : Monday, October 2nd 2006 @ 09:49:06 AM
Script : http://www.gargleblasterblues.com/fo...=postreply&t=5
Referrer : http://www.gargleblasterblues.com/fo...hp?t=5&page=11
IP Address : 71.33.220.99
Username : Promise
Classname : vb_database

[Keyser520]

I'm getting a barage of error messages.. here's another

Database error in vBulletin :
mysql_connect(): Can't connect to MySQL server on 'mysql41.secureserver.net' (111)
/home/content/s/w/i/swinger/html/forums/includes/class_core.php on line 271
MySQL Error :
Error Number :
Date : Monday, October 2nd 2006 @ 09:49:12 AM
Script : http://www.gargleblasterblues.com/forums/vbshout.php
Referrer :
IP Address : 24.72.154.102
Username :
Classname : vb_database

[Keyser520]

I keep getting that last error message over and over again. Up to 50 of them sent to my email now.

They all seem to have started when the new user registered, which is the first message posted above.

[Steve Machol]

1. MySQL Error : Got error 127 from table handler

This error means:

MySQL error: 127 = Record-file is crashed

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 -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

2. mysql_connect(): Can't connect to MySQL server on 'mysql41.secureserver.net' (111)

Please see this page for the causes of this error:

http://www.vbulletin.com/docs/html/cantconnect

[Keyser520]

ok, but I can't get to my admin cp... The db is still crashed...help?

[Steve Machol]

You can repair tables in phpMyAdmin. Use this query:

REPAIR TABLE thread;

[Keyser520]

it's not letting me log in to myphp admin

[Keyser520]

it's just hanging out doing nothing

[Steve Machol]

Then this is a server problem. You need to contact your host about this.

[Keyser520]

ok, what do i tell them about running the query to fix the stuff?

[Steve Machol]

This is not a query problem. The MySQL server is down. Please see point #2 in my previous post.

[Keyser520]

When I said query, I was referring to this:

You can repair tables in phpMyAdmin. Use this query:

REPAIR TABLE thread;

They finally got the db back up. Do I need to run anything queries (like the one shown above) or anything to check and make sure the db is working fine? Posting seems to be ok.

[Steve Machol]

It wouldn't hurt to run repair/optimize on the database.