Can't open file: 'thread.MYI'

[mcyates]

I keep on getting this error.
===================================
Database error in vBulletin 2.3.0:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread

WHERE thread.visible=1 AND 1=1 AND NOT (thread.forumid='88') AND thread.lastpost>=1050684545 AND thread.open<>10
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016
===================================

I fix it with the repair.php but it keeps coming back? Anyone know why? The only mods i have are:

vbhome (lite)
Quick Reply

[mcyates]

its ok the problems i found a possible sollution on here:
http://www.vbulletin.com/forum/showt...threadid=69803

[filburt1]

You can try my hack, too. This happens a lot with MySQL 4, apparently.

[mcyates]

Well my host has optimised my database and everything seems ok, its been ok for well over 24hrs now. Dunnot what they have done to the database like!!