Bug Duplicate entry

[ichpen]

Happened only once but again nothing is enabled right now other than the inactivity digest.

• 
  
• XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '579-1' for key 'PRIMARY'
• src/XF/Db/AbstractStatement.php:217
• Generated by: Unknown account
• Apr 20, 2019 at 11: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(1267): DBTech\Mail\XF\Entity\User->rebuildUserGroupRelations(false)
#8 src/addons/DBTech/Credits/XF/Entity/User.php(91): 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(579, Array, Array, '32')
#15 src/XF/Entity/UserGroupPromotion.php(27): XF\Service\User\UserGroupChange->addUserGroupChange(579, 'ugPromotion13', '32')
#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(54) "https://mysite.com/forums/c4-forum.57/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Fillip H.]

I'll need step-by-step instructions for how to replicate the issue as this is not something I am able to replicate just now.

 

[ichpen]

I'll need step-by-step instructions for how to replicate the issue as this is not something I am able to replicate just now.

Yeah I wish I could tell you but alas that's the only log of it from yesterday. If I come across it again I'll let you know.

 

[DragonByte Technologies]

Hello @ichpen,

We hope your ticket regarding DragonByte Mail has been addressed to your satisfaction. This ticket has now been 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.