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

XF 1.4 Server error - Unable to post

Discussion in 'Troubleshooting and Problems' started by ineedhelp, Jan 3, 2015.

  1. ineedhelp

    ineedhelp Well-Known Member

    Hi

    I need an urgent fix for the code below.

    Thanks in advance.

    Code:
    
    Mysqli prepare error: Table './ubar_625866_0001/xf_search_index' is marked as crashed and should be repaired
    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in XenForo/Search/SourceHandler/MySqlFt.php at line 110
    XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 82
    XenForo_Search_SourceHandler_MySqlFt->insertIntoIndex() in XenForo/Search/Indexer.php at line 44
    XenForo_Search_Indexer->insertIntoIndex() in XenForo/Search/DataHandler/Post.php at line 61
    XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 275
    XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/DataWriter/DiscussionMessage.php at line 760
    XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 739
    XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 585
    XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 477
    XenForo_DataWriter_Discussion->_saveFirstMessageDw() in *******/Credits/DataWriter/Discussion/Thread.php at line 90
    *******_Credits_DataWriter_Discussion_Thread->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 426
    XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 730
    XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /var/www/blahblah/blahblah/httpdocs/index.php at line 13
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Rebuild the search index via the ACP.
     
  3. ineedhelp

    ineedhelp Well-Known Member

    This didn't work, still gives error.

    The repair needs to be done in the database I think.

    Can you tell me what I should do.
     
  4. The Forum Heroes

    The Forum Heroes Well-Known Member


    Try selecting all tables in phpMyAdmin and then use repair in the pull-down options menu.
     
  5. Mike

    Mike XenForo Developer Staff Member

    You need to choose the option to the delete the index as well.
     
    ineedhelp likes this.
  6. Alan Hollis

    Alan Hollis New Member

    Do guys have any idea what causes this? I run into this on our staging environment quite a bit, and it always worries me. Touch wood as yet it's not happened on live, but I'm struggling to do anything which can constantly reproduce the table crashing. I'll keep searching :)
     
  7. Mike

    Mike XenForo Developer Staff Member

    It is caused by MySQL not being shutdown properly or a hardware issue (causing writes to not happen correctly).
     

Share This Page