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

XF 1.4 Error on import.

#1
I got this on the import of threads and posts on a vb3.8 import. What should I do? Can I resume the import or what?

Server Error
Mysqli prepare error: MySQL server has gone away

  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 Zend/Db/Adapter/Abstract.php at line 734
  5. Zend_Db_Adapter_Abstract->fetchAll() in XenForo/Importer/vBulletin.php at line 2522
  6. XenForo_Importer_vBulletin->stepThreads() in XenForo/Importer/Abstract.php at line 97
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 135
  9. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 347
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  11. XenForo_FrontController->run() in /home/challeng/public_html/admin.php at line 13
 

Jake Bunce

XenForo moderator
Staff member
#2
MySQL server has gone away
That error is caused by one of these MySQL settings being exceeded:

wait_timeout
max_allowed_packet

Your host or server person needs to increase these settings in MySQL. There is more info here:

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

Once this is fixed then it would be ideal for you to start over with the import. But refreshing the current import should pick up where it left off.