XF 1.5 vb4 Importer Errors

[SteveCo]

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) "********"
}
}

 

[Paul B]

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

 

[SteveCo]

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]

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]

I did create new user groups for XenWord Bridge. I will clear those out.

Thanks for the reply.

 

[SteveCo]

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]

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]

These:

vBulletin 4 Importer To XenForo 1.1
XenForo Media Gallery 1.1.12

 

[Paul B]

vBulletin 4 Importer To XenForo 1.1

Is that this?
https://xenforo.com/community/resources/vb4-importer.1025/

You should be using the built in importer - admin.php?import/

 

[SteveCo]

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]

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/