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

XF 1.3 MyBB 1.6.9 import errors

Discussion in 'Installation, Upgrade, and Import Support' started by Joshua, Apr 12, 2014.

  1. Joshua

    Joshua Active Member

    I swear I just jinxed myself by saying "this is going pretty well" when I look up and see the following error:
    Code:
    Mysqli statement execute error : Duplicate entry '680407' for key 'PRIMARY'
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1624
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
    XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
    XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 1684
    XenForo_Model_Import->importPost() in XenForo/Importer/MyBb.php at line 1675
    XenForo_Importer_MyBb->stepThreads() in XenForo/Importer/Abstract.php at line 97
    XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 135
    XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /home/nginx/domains/domain.org/public/admin.php at line 13 
    I refreshed a couple times - same thing, different entry. Went back to "import external data" to continue the import - same thing, same entry.

    What happened besides me jinxing myself??
     
  2. Joshua

    Joshua Active Member

    Oh - It was ~80% through importing threads and posts
     
  3. Joshua

    Joshua Active Member

    Cursory research leads me to believe this happens sometimes with large DB imports and that I should just start over...
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yep. You should start over.

    Also make sure your MyBB database doesn't have two posts with id 680407.

    Also make sure no one is posting anything to XF during the import.
     
  5. Mike

    Mike XenForo Developer Staff Member

    If it happens again, it would probably be worth submitting a ticket so that we can attempt to look into it -- there really shouldn't be any duplicate IDs like that.
     

Share This Page