• 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

#1
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
 

Brogan

XenForo moderator
Staff member
#2
The error indicates the search index table is missing from the database.

Did you do anything other than a standard upgrade?
 
#3
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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;