XF 1.2 Follow error .. wtf ?

[Domicuc]

The following error occurred:
Mysqli prepare error: Table './gamlerum_cz/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 110
5. XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 82
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 61
8. XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 238
9. XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/DataWriter/DiscussionMessage.php at line 757
10. XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.phpat line 736
11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 582
12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1397
13. XenForo_DataWriter->save() in Dark/TaigaChat/DataWriter/DiscussionMessage/Post.php at line 7
14. Dark_TaigaChat_DataWriter_DiscussionMessage_Post->save() in sonnb/LiveThread/ControllerPublic/Thread.php at line373
15. sonnb_LiveThread_ControllerPublic_Thread->actionAddReplyLive() in XenForo/FrontController.php at line 337
16. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
17. XenForo_FrontController->run() in /var/www/gamlerum_cz/index.php at line 13

 

[duderuud]

The error says it all, the search index table is crashed.

When it is not too big you can try to repair it with phpmyadmin, otherwise use the mysql shell (something like REPAIR TABLE xf_search_index)

 

[Paul B]

I would probably just truncate the table and rebuild the search index.