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

XF 1.1 error during vb3.8.4 import

Spawne32

Active member
#1
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
 

Spawne32

Active member
#3
It was a brand new install that no one had access to, the only user that was on there was the one created during the installation of the forum.
 

Jake Bunce

XenForo moderator
Staff member
#4
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.