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

XF 1.2 Mysql error after upgrade

Discussion in 'Troubleshooting and Problems' started by AlexGP, Sep 10, 2013.

  1. AlexGP

    AlexGP Member

    Hello i upgrade my forum to version 1.2. All the upgrade was great, no errors, no problens in the way, but when i try to post anything:

    Mysqli prepare error: Table 'jandrogp_mmoforum.xf_search_index' doesn't exist
    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 757
    10. XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.phpat line 736
    11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 582
    12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1397
    13. XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 477
    14. XenForo_DataWriter_Discussion->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 426
    15. XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1397
    16. XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 678
    17. XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 337
    18. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    19. XenForo_FrontController->run() in /home/jandrogp/public_html/mmorpgs.com.br/comunidade/index.php at line 13
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The error indicates the search index table is missing from the database.

    Did you do anything other than a standard upgrade?
  3. AlexGP

    AlexGP Member

    No, i dont know what happened but i create the table again using this script php and it works perfect:

    CREATE TABLE IF NOT EXISTS `xf_search_index` (
    `content_type` varchar(25) NOT NULL,
    `content_id` int(10) unsigned NOT NULL,
    `title` varchar(250) NOT NULL DEFAULT '',
    `message` mediumtext NOT NULL,
    `metadata` mediumtext NOT NULL,
    `user_id` int(10) unsigned NOT NULL DEFAULT '0',
    `item_date` int(10) unsigned NOT NULL,
    `discussion_id` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`content_type`,`content_id`),
    KEY `user_id_item_date` (`user_id`,`item_date`),
    FULLTEXT KEY `title_message_metadata` (`title`,`message`,`metadata`),
    FULLTEXT KEY `title_metadata` (`title`,`metadata`)

Share This Page