XF 2.1 XF\Db\DuplicateKeyException: MySQL query error [1062]

[Goatpod]

Hello,

While doing a VB4 import to XF2.1.3 using XFI 1.2.3 I received the following error at step 14:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '140' for key 'PRIMARY' in src/XF/Db/AbstractStatement.php at line 217

2. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
4. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
6. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
8. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
10. XF\Db\AbstractAdapter->insert() in src/XF/Import/Data/EntityEmulator.php at line 326
12. XF\Import\Data\EntityEmulator->insert() in src/XF/Import/Data/AbstractEmulatedData.php at line 55
14. XF\Import\Data\AbstractEmulatedData->write() in src/XF/Import/Data/AbstractData.php at line 127
16. XF\Import\Data\AbstractData->save() in src/addons/XFI/Import/Importer/vBulletin.php at line 3055
18. XFI\Import\Importer\vBulletin->stepThreads() in src/XF/Import/Runner.php at line 231
20. XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 59
22. XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 234
24. XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 321
26. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
28. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
30. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
32. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
34. XF\App->run() in src/XF.php at line 390
36. XF::runApp() in admin.php at line 13

 

[Chris D]

While they shouldn't be frequent, these issues can happen.

It looks like you got the import completed, did you have to do anything specific or did the import proceed as normal?