XF 1.3 MyBB 1.6.9 import errors

[Joshua]

I swear I just jinxed myself by saying "this is going pretty well" when I look up and see the following error:

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??

 

[Joshua]

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

 

[Joshua]

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

 

[Jake Bunce]

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.

 

[Mike]

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.