Duplicate Migration Error From vB5 to XF2.0.9

[James Z]

Came up with this error while trying to migrate a test forum from vB5 to XF 2.0.9.

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'old_id' at row 1 in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 161
XF\Db\AbstractAdapter->insert() in src/XF/Import/Log.php at line 117
XF\Import\Log->log() in src/XF/Import/DataManager.php at line 116
XF\Import\DataManager->log() in src/addons/XFI/Import/Importer/vBulletin5.php at line 531
XFI\Import\Importer\vBulletin5->logExtraForumData() in src/addons/XFI/Import/Importer/vBulletin.php at line 2105
XFI\Import\Importer\vBulletin->importNodeTree() in src/addons/XFI/Import/Importer/vBulletin.php at line 2116
XFI\Import\Importer\vBulletin->importNodeTree() in src/addons/XFI/Import/Importer/vBulletin.php at line 2026
XFI\Import\Importer\vBulletin->stepForums() in src/XF/Import/Runner.php at line 160
XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 74
XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 232
XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13

 

[Claudio]

Came up with this error while trying to migrate a test forum from vB5 to XF 2.0.9.

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'old_id' at row 1 in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 78
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 161
XF\Db\AbstractAdapter->insert() in src/XF/Import/Log.php at line 117
XF\Import\Log->log() in src/XF/Import/DataManager.php at line 116
XF\Import\DataManager->log() in src/addons/XFI/Import/Importer/vBulletin5.php at line 531
XFI\Import\Importer\vBulletin5->logExtraForumData() in src/addons/XFI/Import/Importer/vBulletin.php at line 2105
XFI\Import\Importer\vBulletin->importNodeTree() in src/addons/XFI/Import/Importer/vBulletin.php at line 2116
XFI\Import\Importer\vBulletin->importNodeTree() in src/addons/XFI/Import/Importer/vBulletin.php at line 2026
XFI\Import\Importer\vBulletin->stepForums() in src/XF/Import/Runner.php at line 160
XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 74
XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 232
XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13

https://xenforo.com/community/threads/vb5-import-data-too-long-for-column-old_id-at-row-1.143978/