XF 1.4 Error after import from vbulletin during search index rebuild

[Mr Lucky]

I am currently importing a forum from vbulletin. All went well until I rebuilt the search index and got this errR. can anyone please help?

An exception occurred: mysqli::prepare(): MySQL server has gone away in /home/logicusers/public_html/xforums/library/Zend/Db/Statement/Mysqli.php on line 70

XenForo_Application::handlePhpError()
mysqli->prepare() in Zend/Db/Statement/Mysqli.php at line 70
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 Zend/Db/Adapter/Abstract.php at line 808
Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Phrase.php at line 332
XenForo_Phrase::loadPhrases() in XenForo/Phrase.php at line 303
XenForo_Phrase::_loadPhrase() in XenForo/Phrase.php at line 203
XenForo_Phrase->render() in XenForo/Phrase.php at line 283
XenForo_Phrase->__toString() in XenForo/Deferred/SearchIndex.php at line 103
XenForo_Deferred_SearchIndex->execute() in XenForo/Model/Deferred.php at line 294
XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 428
XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 373
XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 159
XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/logicusers/public_html/xforums/admin.php at line 13
An exception occurred: Mysqli prepare error: MySQL server has gone away in /home/logicusers/public_html/xforums/library/Zend/Db/Statement/Mysqli.php on line 77

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/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/AdminNavigation.php at line 31
XenForo_Model_AdminNavigation->getAdminNavigationEntries() in XenForo/Model/AdminNavigation.php at line 405
XenForo_Model_AdminNavigation->getAdminNavigationForDisplay() in XenForo/Dependencies/Admin.php at line 224
XenForo_Dependencies_Admin->_getNavigationContainerParams() in XenForo/Dependencies/Admin.php at line 202
XenForo_Dependencies_Admin->getEffectiveContainerParams() in XenForo/FrontController.php at line 616
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home/logicusers/public_html/xforums/admin.php at line 13

 

[Chris D]

I think that usually relates to MySQL server configuration and these two values being exceeded:

wait_timeout
max_allowed_packet

You would likely need to increase the values of these settings and try again.

 

[Mr Lucky]

Think it was a host problem, OK now thanks.