Got error 130 from storage engine Issue

[TE Data]

Getting the following SQL error when I try visiting my site


Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO taggregate_temp_1258138560
SELECT threadid, COUNT(*) AS views
FROM threadviews
GROUP BY threadid;

MySQL Error : Got error 130 from storage engine
Error Number : 1030
Request Date : Friday, November 13th 2009 @ 12:56:07 PM
Error Date : Friday, November 13th 2009 @ 12:56:15 PM
Script : http://forums.mixolgy.net/cron.php?rand=1258138565
Referrer : http://forums.mixolgy.net/index.php
IP Address : 41.233.38.227
Username : m7mod
Classname : vb_database
MySQL Version :

and create this table automatic taggregate_temp_xxxxx
and can't repair this table find attach

and wondering if anyone can assist in the resolution:

[Lynne]

What did you do right before this happened?

MySQL error code 130: Incorrect file format

[TE Data]

This is after upgrading to vBulletin 3.8.4 Patch Level 1

[Steve Machol]

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:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

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

[TE Data]

What did you do right before this happened?

MySQL error code 130: Incorrect file format

yes this message come when i repair the table now
how can i solve it.

[Steve Machol]

Then you need to ask your host to try and repair this for you.