• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 URGENT problem: Mysqli prepare error:

=MGN=RedEagle

Well-known member
#1
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
#4
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.