[Forum] No New Posts inserted into search / Database error

[lardude]

My host recently upgraded the mySQL version based on recommendations of a server optimization request.

I just noticed that no new posts/threads are included in search results. Old posts are. I then did a search in my email for errors and found TONS of vBulletin Database Error! emails in my spam folder.
Here is an example:

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO searchcore_text (searchcoreid, keywordtext)
                       VALUES ( 1116690, ' Message content censored' )
                       ON DUPLICATE KEY UPDATE  searchcoreid = VALUES(searchcoreid), keywordtext = VALUES(keywordtext);

MySQL Error   : Incorrect key file for table './table_name/searchcore_text.MYI'; try to repair it
Error Number  : 126
Request Date  : Thursday, October 6th 2011 @ 10:40:07 AM
Error Date    : Thursday, October 6th 2011 @ 10:40:08 AM
Script        : http://www.domain.com/cron.php?rand=1317915606
Referrer      : http://www.domain.com/search.php?searchid=96738&pp=&page=2
IP Address    : XXXXX
Username      : Unregistered
Classname     : vB_Database
MySQL Version

Please help! What are your suggestions?

I thought that the forum was running ok since the upgrade but apparently something did not work right.
Since this is an urgent issue (My members cannot search anything new) and the success of the forum is very important this week/month, does anybody have a good idea on how to resolve? Should I just quickly open a ticket and hope that the good vbulletin support staff could fix?

Thanks in advance for your help.

[lardude]

I opened a trouble ticket. Hopefully this can easily be resolved Thanks.

[creative-friends]

Did you get any solution

because i have got the same problem...

[lardude]

Yes. I did. Support did a repair on my tables and it fixed the problem