Question Import Error

[jim]

Hi. The import was going well, but then came across this error. Any ideas

• XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '913971' for key 'PRIMARY'
• src/XF/Db/AbstractStatement.php:230
• Generated by: Jim
• Nov 14, 2024 at 12:17 PM

Stack trace​

INSERT INTO xf_edit_history (edit_history_id, content_type, content_id, edit_user_id, edit_date, old_text) VALUES (?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Import/Data/EntityEmulator.php(336): XF\Db\AbstractAdapter->insert('xf_edit_history', Array)
#5 src/XF/Import/Data/AbstractEmulatedData.php(73): XF\Import\Data\EntityEmulator->insert(913971, Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Import/Data/AbstractData.php(132): XF\Import\Data\AbstractEmulatedData->write(913971)
#7 src/addons/DBTech/SocialGroups/Import/Importer/SnogSocialGroups.php(1145): XF\Import\Data\AbstractData->save(913971)
#8 src/XF/Import/Runner.php(244): DBTech\SocialGroups\Import\Importer\SnogSocialGroups->stepMessageEditHistory(Object(XF\Import\StepState), Array, 8)
#9 src/XF/Import/Runner.php(61): XF\Import\Runner->runStep('messageEditHist...', Object(XF\Import\StepState), 8)
#10 src/XF/Admin/Controller/ImportController.php(247): XF\Import\Runner->run()
#11 src/XF/Mvc/Dispatcher.php(362): XF\Admin\Controller\ImportController->actionRun(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\ImportController), NULL)
#13 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\ImportController), NULL)
#14 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#16 src/XF.php(806): XF\App->run()
#17 admin.php(15): XF::runApp('XF\\Admin\\App')
#18 {main}

Request state​

array(4) {
["url"] => string(27) "/forum/admin.php?import/run"
["referrer"] => string(57) "https://www.motorhomefun.co.uk/forum/admin.php?import/run"
["_GET"] => array(1) {
["import/run"] => string(0) ""
}
["_POST"] => array(1) {
["_xfToken"] => string(8) "********"
}
}
Delete

 

[Fillip H.]

I'll look into this as soon as I can and get back to you once I have more information or if I need further information from you

 

[Fillip H.]

Have you edited the xf_edit_history table in any way? Or are you running some kind of database replication, or is your database running on some cloud service?

This error is not possible in normal operation.

 

[jim]

Hi Filip

Never edited a table in my life
No database replication and it's hosted on our own dedicated server.

 

[Fillip H.]

Could you please use the "Attach secure data" button to allow me access to your site so I can look into this further?

The attached data is encrypted before being saved, and the decryption key will be emailed to both of us. The decrypted information is not stored in the browser nor on our servers. You can purge the data entirely at any point by clicking the "Delete secure data" button.

As this is a much more secure method of exchanging sensitive information, I am unable to accept private messages / conversations with sensitive information. If you have previously submitted private messages / conversations with sensitive information, please ensure this information has been changed and that it is no longer valid.

 

[jim]

Hi no worries I'm going to start afresh and with new groups

 

[DragonByte Technologies]

Hello @jim,

We hope your ticket regarding DragonByte Social Groups has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.