Not a bug XF to XF Duplicate Entry


Well-known member
Got this when importing usergroups when I tried starting all over again even tho I archived the import log. I think I'll delete the test database and try again.
Server Error
Mysqli statement execute error : Duplicate entry '6' 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 1612
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
  7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
  8. XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 637
  9. XenForo_Model_Import->importUserGroup() in XenForo/Importer/XenForo.php at line 226
  10. XenForo_Importer_XenForo->stepUserGroups() 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 232
  13. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
  14. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
  15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  16. XenForo_FrontController->run() in /home/me/public_html/test/admin.php at line 13


XenForo developer
Staff member
If you already started an import, you can't do another import and choose to maintain IDs. You can only maintain IDs on a pristine install.

Also, note that the XF importer is currently in beta.


Well-known member
I understand. I don't mind starting all over again if it helps to test it out.