XF 1.2 Importing from MyBB 1.6.9


Active member
I'm testing a MyBB import. When I clicked to complete the forum/node portion of the import process, I got the following error message:

Mysqli statement execute error : Duplicate entry '7' 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 1612
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
  7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
  8. XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 1253
  9. XenForo_Model_Import->importForum() in XenForo/Importer/MyBb.php at line 1258
  10. XenForo_Importer_MyBb->_importForumTree() in XenForo/Importer/MyBb.php at line 1277
  11. XenForo_Importer_MyBb->_importForumTree() in XenForo/Importer/MyBb.php at line 1219
  12. XenForo_Importer_MyBb->stepForums() in XenForo/Importer/Abstract.php at line 77
  13. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 195
  14. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 247
  15. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 190
  16. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
  17. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  18. XenForo_FrontController->run() in /home/tforum/public_html/xf/admin.php at line 13
I've tried dropping the XF node table and I've made sure there are not two entries in the source db with FID=7
Can someone help me understand exactly what's going on here and how I might fix it?

Thanks in advance!


Active member
First import though there was existing data from test nodes/threads/posts/members
I believe I did choose to retain IDs


Active member
So what is the best course of action for a re-test? Is there an easy way to remove all data from the database? Can I just re-try and NOT select Retain IDs?