1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Importing Users Error

Discussion in 'Installation, Upgrade, and Import Support' started by stonerbuddy, Apr 28, 2014.

  1. stonerbuddy

    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?
  2. stonerbuddy

    stonerbuddy New Member

    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!

Share This Page