XF 1.2 Mysql error after upgrade

[AlexGP]

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

 

[Paul B]

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

Did you do anything other than a standard upgrade?

 

[AlexGP]

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;