Fixed Identical urlident field values in VB5 cause importer to error with duplicate entry for node_name

Paul B

XenForo moderator
Staff member
Affected version
1.2.4
As title.

Code:
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'others-Forum' for key 'node_name_unique' src/XF/Db/AbstractStatement.php:228
Generated by: admin Nov 26, 2019 at 10:54 PM
Stack trace
INSERT  INTO `xf_node` (`node_id`, `title`, `node_name`, `description`, `node_type_id`, `parent_node_id`, `display_order`, `style_id`, `effective_style_id`, `display_in_list`, `breadcrumb_data`, `navigation_id`, `effective_navigation_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Import/Data/EntityEmulator.php(326): XF\Db\AbstractAdapter->insert('xf_node', Array)
#5 src/XF/Import/Data/AbstractEmulatedData.php(55): XF\Import\Data\EntityEmulator->insert(285, Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Import/Data/AbstractData.php(127): XF\Import\Data\AbstractEmulatedData->write(285)
#7 src/addons/XFI/Import/Importer/vBulletin.php(2187): XF\Import\Data\AbstractData->save(285)
#8 src/addons/XFI/Import/Importer/vBulletin.php(2197): XFI\Import\Importer\vBulletin->importNodeTree(Array, Array, 49, 49)
#9 src/addons/XFI/Import/Importer/vBulletin.php(2197): XFI\Import\Importer\vBulletin->importNodeTree(Array, Array, 20, 20)
#10 src/addons/XFI/Import/Importer/vBulletin.php(2197): XFI\Import\Importer\vBulletin->importNodeTree(Array, Array, 2, 2)
#11 src/addons/XFI/Import/Importer/vBulletin.php(2110): XFI\Import\Importer\vBulletin->importNodeTree(Array, Array, 1)
#12 src/XF/Import/Runner.php(231): XFI\Import\Importer\vBulletin->stepForums(Object(XF\Import\StepState), Array, 8)
#13 src/XF/Import/Runner.php(59): XF\Import\Runner->runStep('forums', Object(XF\Import\StepState), 8)
#14 src/XF/Admin/Controller/Import.php(234): XF\Import\Runner->run()
#15 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#17 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#18 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#20 src/XF.php(391): XF\App->run()
#21 admin.php(13): XF::runApp('XF\\Admin\\App')
#22 {main}
Request state
array(4) {
  ["url"] => string(25) "/xf2/admin.php?import/run"
  ["referrer"] => string(46) "http://test.com/xf2/admin.php?import/run"
  ["_GET"] => array(1) {
    ["import/run"] => string(0) ""
  }
  ["_POST"] => array(1) {
    ["_xfToken"] => string(8) "********"
  }
}
 
Hi, may I know any update on this error? I am still waiting for the fix so that I can convert my vbulletin 5.4.4 to xenforo. many thanks
 
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XFI release (1.2.5).

Change log:
When importing from vBulletin 5 ensure that the node_name values are unique to avoid duplicate key errors.
There may be a delay before changes are rolled out to the XenForo Community.
 
Top Bottom