Incorrect key file for table "searchcore_text.MYI

[Bluemax712]

I have a 'renamed' thread causing "searchcore_text" table errors when trying to delete it:

MySQL Error: Incorrect key file for table "searchcore_text.MYI" ; try to repair it
Error Number :126

I can repair and optimize the "searchcore_text" table and it returns Status OK
But then as soon as try deleting a post in the thread same errors return

Also tried the following
-repairing it through the shell using mysql
-tried "myismchk" on searchcore_text.MYI
-there is plenty of disk space left

Google is out of ideas for me to try :(

Any other ideas to try?

[kh99]

You could try using Maintenance > General Update Tools > Rebuild Search Index, there's a link to "empty the search index", and then you can rebuild it. However, if you have a large site with many posts, this could take a long time.

[Bluemax712]

Wow! that worked - thanks Kevin
Didn't even notice that was an option - I would have thought emptying it is the first thing that is done anytime it is rebuilt

You're right it took about 40 minutes to get through 160k posts.