XF 1.3 Importing Users Error

[stonerbuddy]

A little background...

Installed a new install of 1.1.3 to the server. (forum new)

Installed the old forums into another directory that was 1.1.1 (forum old)

Upgraded (forum old) to 1.1.2 so that I could import into the new forum install

(now the reason behind this is to get rid of all the template crap, addons and plugins the old forum manager installed and move everything into a truly clean install. )

Now I'm getting stuck on on importing users.

Mysqli statement execute error : Duplicate entry '1' 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 599
8. XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 905
9. XenForo_Model_Import->importAdmin() in XenForo/Importer/XenForo.php at line 777
10. XenForo_Importer_XenForo->_importUser() in XenForo/Importer/XenForo.php at line 623
11. XenForo_Importer_XenForo->_importOrMergeUser() in XenForo/Importer/XenForo.php at line 377
12. XenForo_Importer_XenForo->stepUsers() in XenForo/Importer/Abstract.php at line 97
13. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
14. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
15. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
16. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
17. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
18. XenForo_FrontController->run() in /opt/bitnami/apps/wordpress/htdocs/forums/admin.php at line 13

Now, I need to keep ID's from the old install for SEO reasons.

I only have one user in the new install (super admin)

Can anyone help?

 

[stonerbuddy]

So I just got passed this by editing the old user tables, and setting the conflicting user id (which was the old super admin) to a value of 0, which seemed to allow me to start the user import process. There are over 200,000 users... lol, so the process may take some time, so far so good!