Duplicate Vb4 Import issue

[fotografik]

Affected version

XF2

Received this error on our test import.

XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: 'Countries' for column 'prefix_group_id' at row 1 src/XF/Db/AbstractStatement.php:212
Generated by: Unknown account Dec 1, 2017 at 6:08 PM
Stack trace
INSERT INTO xf_thread_prefix_group (`prefix_group_id`, `display_order`) VALUES (?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(69): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(69): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(145): XF\Db\AbstractAdapter->query('INSERT INTO xf...', Array)
#4 src/XF/Import/Data/EntityEmulator.php(207): XF\Db\AbstractAdapter->insert('xf_thread_prefi...', Array)
#5 src/XF/Import/Data/AbstractEmulatedData.php(34): XF\Import\Data\EntityEmulator->insert('Countries', Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Import/Data/AbstractData.php(99): XF\Import\Data\AbstractEmulatedData->write('Countries')
#7 src/XF/Import/Importer/vBulletin.php(2193): XF\Import\Data\AbstractData->save('Countries')
#8 src/XF/Import/Runner.php(161): XF\Import\Importer\vBulletin->stepThreadPrefixes(Object(XF\Import\StepState), Array, 8)
#9 src/XF/Import/Runner.php(75): XF\Import\Runner->runStep('threadPrefixes', Object(XF\Import\StepState), 8)
#10 src/XF/Cli/Command/Import.php(64): XF\Import\Runner->run()
#11 src/vendor/symfony/console/Command/Command.php(242): XF\Cli\Command\Import->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 src/vendor/symfony/console/Application.php(843): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 src/vendor/symfony/console/Application.php(194): Symfony\Component\Console\Application->doRunCommand(Object(XF\Cli\Command\Import), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 src/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 src/XF/Cli/Runner.php(63): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 cmd.php(15): XF\Cli\Runner->run()
#17 {main}
Request state
array(4) {
["url"] => string(0) ""
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Mike]

https://xenforo.com/community/threa...group_id-and-prefix_id-arent-integers.138094/

There is a rough workaround there, though the easiest workaround may be to import to 1.5 and upgrade.