Not a bug XF\Db\DuplicateKeyException: MySQL query error [1062]

[Robf23]

Affected version

2.1.9

• XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '122-0' for key 'report'

 

[Chris D]

Do you still have the details of this in your Server error log?

Could you please provide the full stack trace and request details?

 

[Robf23]

I thought I did save them somewhere after clearing the error, but can't find them. It's happened again, this time I think it was 130-0.

On the data it seemed to have login/login, I don't know if that's any help. It happened to a different member as well.

 

[Mike]

We'd need the full stack trace from the log. I'm not 100% positive, but I believe this is likely related to an add-on (based on the index name).

 

[Robf23]

• XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '122-0' for key 'report'
• src/XF/Db/AbstractStatement.php:228
• Generated by: blueboy
• May 29, 2020 at 2:34 PM

Stack trace
UPDATE xf_sv_multiple_account_report_data SET report_id = ?, active = ? WHERE report_data_id = 53
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(78): 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(327): XF\Db\AbstractAdapter->query('UPDATE `xf_sv_...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1468): XF\Db\AbstractAdapter->update('xf_sv_multiple_...', Array, '`report_data_id...')
#5 src/XF/Mvc/Entity/Entity.php(1195): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/SV/SignupAbuseBlocking/Repository/MultipleAccount.php(228): XF\Mvc\Entity\Entity->save()
#7 src/addons/SV/SignupAbuseBlocking/Repository/MultipleAccount.php(60): SV\SignupAbuseBlocking\Repository\MultipleAccount->processMultipleAccountDetectionInternal(Object(SV\SignupAbuseBlocking\XF\Entity\User), Array, 'login')
#8 src/XF.php(479): SV\SignupAbuseBlocking\Repository\MultipleAccount->SV\SignupAbuseBlocking\Repository\{closure}()
#9 src/addons/SV/SignupAbuseBlocking/Repository/MultipleAccount.php(61): XF::asVisitor(Object(SV\SignupAbuseBlocking\XF\Entity\User), Object(Closure))
#10 src/addons/SV/SignupAbuseBlocking/XF/ControllerPlugin/Login.php(94): SV\SignupAbuseBlocking\Repository\MultipleAccount->processMultipleAccountDetection(Object(SV\SignupAbuseBlocking\XF\Entity\User), Array, 'login')
#11 src/XF/Pub/Controller/Login.php(117): SV\SignupAbuseBlocking\XF\ControllerPlugin\Login->completeLogin(Object(SV\SignupAbuseBlocking\XF\Entity\User), true)
#12 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Login->actionLogin(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(262): XF\Mvc\Dispatcher->dispatchClass('XF:Login', 'login', Object(XF\Mvc\RouteMatch), Object(SV\SignupAbuseBlocking\XF\Pub\Controller\Login), NULL)
#14 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\SignupAbuseBlocking\XF\Pub\Controller\Login), NULL)
#15 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#17 src/XF.php(391): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
Request state
array(4) {
["url"] => string(12) "/login/login"
["referrer"] => string(32) "https://shooting-the-breeze.com/"
["_GET"] => array(0) {
}
["_POST"] => array(5) {
["login"] => string(7) "blueboy"
["password"] => string(8) "********"
["remember"] => string(1) "1"
["_xfRedirect"] => string(32) "https://shooting-the-breeze.com/"
["_xfToken"] => string(8) "********"
}
}

 

[Chris D]

Yes that looks like it could be related to your signup abuse blocking/multiple account reporting add-on. Probably best to ask the author for support in the first instance.

 

[Robf23]

Thanks, will do