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

XF 1.4 vb4 Database import - help

#1
so i've setup my new forum, ran through the import process and started importing, its failing at the Import Users stage (so not got that far really) - any ideas?

Server Error
Mysqli statement execute error : Duplicate entry '2' 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 1624
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
  7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 804
  8. XenForo_Model_Import->importUser() in XenForo/Importer/vBulletin.php at line 1326
  9. XenForo_Importer_vBulletin->_importUser() in XenForo/Importer/vBulletin.php at line 1101
  10. XenForo_Importer_vBulletin->_importOrMergeUser() in XenForo/Importer/vBulletin.php at line 810
  11. XenForo_Importer_vBulletin->stepUsers() in XenForo/Importer/Abstract.php at line 97
  12. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
  13. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
  14. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
  15. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
  16. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  17. XenForo_FrontController->run() in /var/www/html/forums/admin.php at line 13
thanks :)
 

Mike

XenForo developer
Staff member
#4
If you are selecting the maintain IDs option when starting the import, you can't have created any additional content. You'll either need to remove it or (preferably, to ensure that it's not there) re-install before attempting an import with that option enabled.