mysql error number: 1016

[simple_john]

hi ive been getting the following error message emailed to me the past few days:

Database error in vBulletin 3.0.7:
Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid
mysql error: Can't open file: 'attachmentviews.MYI'. (errno: 145)
mysql error number: 1016
Date: Thursday 27th of July 2006 08:10:16 AM
Script: http://www.mytractorforum.com/cron.php?&rand=821699
Referer: http://www.mytractorforum.com/search...7&pp=25&page=2
Username: War Eagle
IP Address: **.***.1**.61

any idea what caused this and how i can resolve it?


thanks

[Steve Machol]

MySQL error: 145 = Table was marked as crashed and should be repaired

This error means that table has 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

If you cannot open your Admin CP then you can repair tables with phpMyAdmin.