XF 1.1 URGENT problem: Mysqli prepare error:

=MGN=RedEagle

Well-known member
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
 

Brogan

XenForo moderator
Staff member
Truncate the search table and rebuild the search index or repair the table.
 

Brogan

XenForo moderator
Staff member
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.
 
Top