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:

Brogan

XenForo moderator
Staff member
You won't be able to retain keys and import into a forum with existing content - even if you only created test content.
 

SteveCo

Member
I'm not following... so I need to empty out the current content? I had 1 test thread in there and that was it.
 

Chris D

XenForo developer
Staff member
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.
 

SteveCo

Member
After removing the additional user groups, all went fine until I got to the Polls. I got this:

The field 'multiple' was not recognised.
 

Chris D

XenForo developer
Staff member
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?
 

SteveCo

Member
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.
 

Chris D

XenForo developer
Staff member
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