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

[Paul B]

Affected version

1.2.4

As title.

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) "********"
  }
}

 

[thedude]

Affected version listed above your post might need an adjustment

 

[Paul B]

Affected version listed above your post might need an adjustment

Why is that?

 

[holymannn]

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]

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.