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

XF 1.4 Error after import from vbulletin during search index rebuild

Mr Lucky

Well-known member
#1
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?

Code:
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

XenForo developer
Staff member
#2
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.