XF 2.0 vBulletin 3.8.11 Import

[Stubentiger]

Hi,
get the following error message when importing a vBulletin 3.8.11 forum (at user import):

• XF\Db\DuplicateKeyException: MySQL query error [1048]: Column 'field_value' cannot be null
• src/XF/Db/AbstractStatement.php:212

Stack trace
INSERT INTO xf_user_field_value (user_id, field_id, field_value) VALUES (8294,'skype',NULL) ON DUPLICATE KEY UPDATE field_value = VALUES(field_value)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1048, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1048, '23000')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(206): XF\Db\AbstractAdapter->query('INSERT INTO `x...')
#4 src/XF/Import/Data/AbstractData.php(287): XF\Db\AbstractAdapter->insertBulk('xf_user_field_v...', Array, false, 'field_value = V...')
#5 src/XF/Import/Data/User.php(269): XF\Import\Data\AbstractData->insertCustomFieldValues('xf_user_field_v...', 'user_id', 8294, Array)
#6 src/XF/Import/Data/AbstractData.php(135): XF\Import\Data\User->postSave(8293, 8294)
#7 src/XF/Import/Helper.php(107): XF\Import\Data\AbstractData->save(8293)
#8 src/XF/Import/Importer/AbstractCoreImporter.php(107): XF\Import\Helper->importUser(8293, Object(XF\Import\Data\User), Array)
#9 src/addons/XFI/Import/Importer/vBulletin.php(1015): XF\Import\Importer\AbstractCoreImporter->importUser(8293, Object(XF\Import\Data\User), Array)
#10 src/XF/Import/Runner.php(160): XFI\Import\Importer\vBulletin->stepUsers(Object(XF\Import\StepState), Array, 8)
#11 src/XF/Import/Runner.php(74): XF\Import\Runner->runStep('users', Object(XF\Import\StepState), 8)
#12 src/XF/Admin/Controller/Import.php(232): XF\Import\Runner->run()
#13 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#14 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', 'html', Object(XF\Mvc\ParameterBag), 'importData', Object(XF\Admin\Controller\Import), NULL)
#15 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#17 src/XF.php(333): XF\App->run()
#18 admin.php(13): XF::runApp('XF\\Admin\\App')
#19 {main}

Request state
array(4) {
["url"] => string(21) "/admin.php?import/run"
["referrer"] => string(58) "https://xenforo.serversupportforum.de/admin.php?import/run"
["_GET"] => array(1) {
["import/run"] => string(0) ""
}
["_POST"] => array(1) {
["_xfToken"] => string(8) "****"
}
}

XenForo Importers 1.0.2

best regards

 

[Mike]

I'm adding some code to the next XFI release (which will be with 2.1) that should help protect against this situation.