XF 1.3 MyBB 1.6.9 import errors


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


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

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.


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.