XF 1.2 Importing from MyBB 1.6.9

[Joshua]

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!

 

[Jeremy]

Is this a second import? Have you chose to retain IDs?

 

[Joshua]

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

 

[Jeremy]

If you are choosing to retain IDs, you cannot have any data within the data based tables (such as nodes).

 

[Joshua]

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?

 

[Jeremy]

Are these just test imports? If so, just reinstall XenForo and delete the nodes.