XF 1.5 Cant delete threads in my forum

[sami simo]

I cant delete threads with too many posts in my forum ( hundreds of posts). every time I try, I get this error:

Server Error

Mysqli statement execute error : Incorrect key file for table './........../xf_search_index.MYI'; try to repair it

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
Zend_Db_Adapter_Abstract->delete() in XenForo/Search/SourceHandler/MySqlFt.php at line 170
XenForo_Search_SourceHandler_MySqlFt->deleteFromIndex() in XenForo/Search/Indexer.php at line 105
XenForo_Search_Indexer->deleteFromIndex() in XenForo/Search/DataHandler/Post.php at line 99
XenForo_Search_DataHandler_Post->_deleteFromIndex() in XenForo/Search/DataHandler/Abstract.php at line 315
XenForo_Search_DataHandler_Abstract->deleteFromIndex() in XenForo/DataWriter/Discussion.php at line 731
XenForo_DataWriter_Discussion->_deleteFromSearchIndex() in XenForo/DataWriter/Discussion.php at line 640
XenForo_DataWriter_Discussion->_indexForSearch() in XenForo/DataWriter/Discussion.php at line 464
XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in XenForo/Model/InlineMod/Thread.php at line 230
XenForo_Model_InlineMod_Thread->deleteThreads() in XenForo/ControllerPublic/InlineMod/Thread.php at line 46
XenForo_ControllerPublic_InlineMod_Thread->actionDelete() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/............/public_html/index.php at line 13

How can I fix this?

 

[Paul B]

The error suggests there may be some database corruption.

However, you can try repairing or truncating the xf_search_index table and then rebuilding the search index in the ACP.

 

[MattW]

I'm rebuilding your search index now. I'll let you know when it's done, and then can you try again?

 

[MattW]

Try now?

 

[sami simo]

Thanks to @Brogan and @MattW .
This issue is fixed.