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

Not a Bug Mysqli prepare error: DELAYED option not supported for table 'xf_search_index'

Discussion in 'Resolved Bug Reports' started by BeerBlackBook, Oct 27, 2015.

Thread Status:
Not open for further replies.
  1. BeerBlackBook

    BeerBlackBook New Member


    New user/purchaser of xenforo. I received the following error when attempting to make my first post:

    Mysqli prepare error: DELAYED option not supported for table 'xf_search_index'
    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 129
    5. XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 101
    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 73
    8. XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 275
    9. XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/DataWriter/DiscussionMessage.php at line 760
    10. XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 739
    11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 585
    12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1409
    13. XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 491
    14. XenForo_DataWriter_Discussion->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 435
    15. XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1409
    16. XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 828
    17. XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 351
    18. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    19. XenForo_FrontController->run() in /data/23/4/4/136/4330136/user/4982298/htdocs/forums/index.php at line 13
    Any ideas?
  2. BeerBlackBook

    BeerBlackBook New Member

  3. Jeremy

    Jeremy XenForo Moderator Staff Member

    If you would like support with your installation, you need to associate your username with your license.
    Amaury likes this.
Thread Status:
Not open for further replies.

Share This Page