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

Affected version
1.2.4

Brogan

XenForo moderator
Staff member
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) "********"
  }
}
 

holymannn

New member
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
 

XF Bug Bot

XenForo bug fixer bot
Staff member
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