XF 1.1 error during vb3.8.4 import


Active member
Server Error

Mysqli statement execute error : Duplicate entry '5467290' for key 'PRIMARY'
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
  7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 580
  8. XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 1556
  9. XenForo_Model_Import->importPost() in XenForo/Importer/vBulletin.php at line 2381
  10. XenForo_Importer_vBulletin->stepThreads() in XenForo/Importer/Abstract.php at line 77
  11. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
  12. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 132
  13. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 310
  14. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  15. XenForo_FrontController->run() in /home/nonewbs/public_html/xfmigration/admin.php at line 13
fully dedicated server running
MYSQL version 5.5.30-cll
PHP version 5.3.23
Apache version2.2.24
Perl version5.10.1
That's a post_id collision.

If you enabled the option to preserve the source ids then make sure it's a new and empty XF installation. And check the source database to make sure there is only one postid 5467290. Or delete that post record from your XF database and refresh the import page. Or re-run the import on a new installation and do not enable the option to preserve the source ids.
Top Bottom