1. 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:

Discussion in 'Troubleshooting and Problems' started by =MGN=RedEagle, Feb 7, 2014.

  1. =MGN=RedEagle

    =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
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Truncate the search table and rebuild the search index or repair the table.
     
  3. =MGN=RedEagle

    =MGN=RedEagle Well-Known Member

    Is this something I do in XF or in MYSQL?
     
  4. Brogan

    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.
     
  5. Mike

    Mike XenForo Developer Staff Member

    If you choose to empty the index in the control panel, that actually runs the truncate for you.
     
    Divvens, Liam W, Veer and 1 other person like this.
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Oops yes, I forgot about that checkbox.

    upload_2014-2-7_17-47-1.png
     

Share This Page