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

XF 1.3 help - search_index' is marked as crashed

Discussion in 'Troubleshooting and Problems' started by topcat, Apr 23, 2014.

  1. topcat

    topcat Well-Known Member

    Im getting the follow error whenever anyone tried to post a perform any action on the forum other than browsing. I disabled plugins via config file and its still same

    Mysqli prepare error: Table './XXXXXX/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 759
    10. XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 738
    11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 584
    12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1409
    13. XenForo_DataWriter->save() in XenForo/ControllerPublic/Thread.php at line 549
    14. XenForo_ControllerPublic_Thread->actionAddReply() in XenForo/FrontController.php at line 347
    15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    16. XenForo_FrontController->run() in /home/xxxxxx/public_html/index.php at line 13
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Either repair the table or truncate (empty) it and rebuild the search index.
  3. topcat

    topcat Well-Known Member

    Thankyou, Done

Share This Page