Bug Duplicate key

[ichpen]

This happens very infrequently so not a big deal but I still see the below (not sure if it's some race condition with the newsletter unsubscription).

• 
  
• XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '2222-1' for key 'PRIMARY'
• src/XF/Db/AbstractStatement.php:217
• Generated by: Unknown account
• May 21, 2019 at 12:20 AM

Stack trace
INSERT INTO xf_dbtech_mail_subscription (user_id, mailing_list_id, subscription_state) 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/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_dbtech_mail_...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/DBTech/Mail/XF/Entity/User.php(53): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Entity/User.php(1282): DBTech\Mail\XF\Entity\User->rebuildUserGroupRelations(false)
#8 src/addons/DBTech/Credits/XF/Entity/User.php(157): XF\Entity\User->_postSave()
#9 src/addons/DBTech/Mail/XF/Entity/User.php(105): DBTech\Credits\XF\Entity\User->_postSave()
#10 src/addons/ThemeHouse/ImageOptimizer/XF/Entity/User.php(13): DBTech\Mail\XF\Entity\User->_postSave()
#11 src/addons/ThemeHouse/XLink/XF/Entity/User.php(34): ThemeHouse\ImageOptimizer\XF\Entity\User->_postSave()
#12 src/XF/Mvc/Entity/Entity.php(1208): ThemeHouse\XLink\XF\Entity\User->_postSave()
#13 src/XF/Service/User/UserGroupChange.php(191): XF\Mvc\Entity\Entity->save(false, false)
#14 src/XF/Service/User/UserGroupChange.php(45): XF\Service\User\UserGroupChange->applyUserGroupChanges(2222, Array, Array, '30')
#15 src/XF/Entity/UserGroupPromotion.php(27): XF\Service\User\UserGroupChange->addUserGroupChange(2222, 'ugPromotion12', '30')
#16 src/XF/Repository/UserGroupPromotion.php(116): XF\Entity\UserGroupPromotion->promote(Object(ForumApps\API\XF\Entity\User))
#17 src/XF/Cron/UserGroupPromotion.php(37): XF\Repository\UserGroupPromotion->updatePromotionsForUser(Object(ForumApps\API\XF\Entity\User), Array, Array)
#18 [internal function]: XF\Cron\UserGroupPromotion::runPromotions(Object(XF\Entity\CronEntry))
#19 src/XF/Job/Cron.php(34): call_user_func(Array, Object(XF\Entity\CronEntry))
#20 src/XF/Job/Manager.php(253): XF\Job\Cron->run(G)
#21 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#22 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#23 job.php(42): XF\Job\Manager->runQueue(false, 8)
#24 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(73) "https://mysite.com/forums/parts-for-sale-wanted.12/page-9"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Fillip H.]

I'll add a workaround to the next version, thanks

 

[DragonByte Technologies]

Hello @ichpen,

We hope your ticket regarding DragonByte Mail 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.

 

[DragonByte Technologies]

Hello @ichpen,

As we have not heard back from you, your ticket regarding DragonByte Mail has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.