XF 1.5 vb4 Importer Errors

SteveCo

Member
Using the importer, I am getting errors and not sure how to proceed:

Server Error
Mysqli statement execute error : Duplicate entry '5' 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 1638
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
  7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 617
  8. XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 655
  9. XenForo_Model_Import->importUserGroup() in XenForo/Importer/vBulletin.php at line 331
  10. XenForo_Importer_vBulletin->stepUserGroups() in XenForo/Importer/Abstract.php at line 124
  11. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 189
  12. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 241
  13. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 184
  14. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 351
  15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  16. XenForo_FrontController->run() in /home/xxxxxx/public_html/forums/admin.php at line 13
Server error logs:

array(3) {
["url"] => string(59) "http://xxxxxx.com/forums/admin.php?import/start-step"
["_GET"] => array(1) {
["import/start-step"] => string(0) ""
}
["_POST"] => array(2) {
["step_userGroups"] => string(18) "Import User Groups"
["_xfToken"] => string(8) "********"
}
}
 
Last edited:
The particular error suggests you created an additional user group too.

If you can remove any test content, user groups, forums, users etc. then the import should continue. Alternatively you may want to consider doing a clean install.
 
We don't use the "multiple" field any more and I can't see anywhere in the code that tries to use it.

Do you have any add-ons installed?
 
I am using the built-in importer. I uninstalled the other one. Same error. I also uninstalled the style I added so I am back to 0 add-ons (other than the media gallery) and the default style.
 
If you have now uninstalled the non-default importer and that is what you started with, you will need to start the import again from scratch.

At this point, I recommend just doing a clean install of XenForo and starting from scratch.

Remove the following file:
internal_data/install-lock.php

And go to:
http://xxxxxxxxxx.com/install/

Before starting the import again, have a read through the Importing Guidelines: https://xenforo.com/community/threads/importing-guidelines.25325/
 
Top Bottom