XF 1.3 Importing Users Error

stonerbuddy

New member
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?
 
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!
 
Top Bottom