XF 1.1 URGENT problem: Mysqli prepare error:

[=MGN=RedEagle]

Hi guys, I get this error each time I try and post or do anything:

Mysqli prepare error: Table './myforum_myforum/xf_search_index' is marked as crashed and should be repaired

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in XenForo/Search/SourceHandler/MySqlFt.php at line 103
5. XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 75
6. XenForo_Search_SourceHandler_MySqlFt->insertIntoIndex() in XenForo/Search/Indexer.php at line 44
7. XenForo_Search_Indexer->insertIntoIndex() in XenForo/Search/DataHandler/Post.php at line 51
8. XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 227
9. XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/DataWriter/DiscussionMessage.php at line 688
10. XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line667
11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 523
12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1385
13. XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 415
14. XenForo_DataWriter_Discussion->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 363
15. XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1385
16. XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 490
17. XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 310
18. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
19. XenForo_FrontController->run() in /home/myforum/public_html/forum/index.php at line 13

 

[Paul B]

Truncate the search table and rebuild the search index or repair the table.

 

[=MGN=RedEagle]

Is this something I do in XF or in MYSQL?

 

[Paul B]

PhpMyAdmin to truncate the table, then the ACP to rebuild the search index.

Otherwise if you just want to repair, the SQL module of cPanel.

 

[Mike]

If you choose to empty the index in the control panel, that actually runs the truncate for you.

 

[Paul B]

Oops yes, I forgot about that checkbox.