Fixed Error when merging posts

[JackieChun]

Affected version

2.3.2

The following error is encountered when merging 2 posts from the same thread by the same user. Both messages had a like from another user.

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'post-15893-0' for key 'content_type_id_user_id'
src/XF/Db/AbstractStatement.php:230
Aug 27, 2024 at 12:08 PM

Stack trace​

UPDATE xf_reaction_content SET content_id = ?, content_user_id = ?, is_counted = ? WHERE reaction_content_id IN (1469)
------------

#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(323): XF\Db\AbstractAdapter->query('UPDATE `xf_rea...', Array)
#4 src/XF/Service/Post/MergerService.php(259): XF\Db\AbstractAdapter->update('xf_reaction_con...', Array, 'reaction_conten...')
#5 src/XF/Service/Post/MergerService.php(176): XF\Service\Post\MergerService->moveDataToTarget()
#6 src/XF/InlineMod/Post/Merge.php(74): XF\Service\Post\MergerService->merge(Array)
#7 src/XF/InlineMod/AbstractAction.php(161): XF\InlineMod\Post\Merge->applyInternal(Object(XF\Mvc\Entity\ArrayCollection), Array)
#8 src/XF/Pub/Controller/InlineModController.php(133): XF\InlineMod\AbstractAction->apply(Object(XF\Mvc\Entity\ArrayCollection), Array)
#9 src/XF/Mvc/Dispatcher.php(362): XF\Pub\Controller\InlineModController->actionPerform(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF\\Pub\\Controll...', 'Perform', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\InlineModController), Object(XF\Mvc\Reply\Reroute))
#11 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\InlineModController), Object(XF\Mvc\Reply\Reroute))
#12 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2813): XF\Mvc\Dispatcher->run()
#14 src/XF.php(802): XF\App->run()
#15 index.php(23): XF::runApp('XF\\Pub\\App')
#16 {main}

 

[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 XF release (2.3.3).

Change log:

Fix merging reactions with multiple source reactions from deleted users

There may be a delay before changes are rolled out to the XenForo Community.