[FIXED] Reactions error

Waves

Member
Got this in the server error log:
  • XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'reaction_score' at row 1
  • src/XF/Db/AbstractStatement.php:217
Stack trace
Code:
UPDATE  `xf_tl_group_comment` SET `reaction_score` = ?, `reactions` = ?, `reaction_users` = ? WHERE `comment_id` = 605
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(326): XF\Db\AbstractAdapter->query('UPDATE  `xf_tl_...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1457): XF\Db\AbstractAdapter->update('xf_tl_group_com...', Array, '`comment_id` = ...')
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Reaction/AbstractHandler.php(107): XF\Mvc\Entity\Entity->save()
#7 src/XF/Repository/Reaction.php(269): XF\Reaction\AbstractHandler->updateContentReactions(Object(Truonglv\Groups\Entity\Comment), Array, Array)
#8 src/XF/Entity/ReactionContent.php(198): XF\Repository\Reaction->rebuildContentReactionCache('tl_group_commen...', 605, false)
#9 src/XF/Entity/ReactionContent.php(140): XF\Entity\ReactionContent->rebuildContentReactionCache()
#10 src/XF/Mvc/Entity/Entity.php(1208): XF\Entity\ReactionContent->_postSave()
#11 src/XF/Repository/Reaction.php(184): XF\Mvc\Entity\Entity->save()
#12 src/XF/Repository/Reaction.php(137): XF\Repository\Reaction->insertReaction(15, 'tl_group_commen...', 605, Object(SV\SignupAbuseBlocking\XF\Entity\User), true, false)
#13 src/addons/ThemeHouse/ReactPlus/XF/Repository/Reaction.php(20): XF\Repository\Reaction->reactToContent(15, 'tl_group_commen...', 605, Object(SV\SignupAbuseBlocking\XF\Entity\User), true, false)
#14 src/XF/ControllerPlugin/Reaction.php(65): ThemeHouse\ReactPlus\XF\Repository\Reaction->reactToContent(15, 'tl_group_commen...', 605, Object(SV\SignupAbuseBlocking\XF\Entity\User), true)
#15 src/addons/ThemeHouse/ReactPlus/XF/ControllerPlugin/Reaction.php(17): XF\ControllerPlugin\Reaction->actionToggleReaction(Object(Truonglv\Groups\Entity\Comment), 'groups/comments...', 'groups/comments')
#16 src/XF/ControllerPlugin/Reaction.php(19): ThemeHouse\ReactPlus\XF\ControllerPlugin\Reaction->actionToggleReaction(Object(Truonglv\Groups\Entity\Comment), 'groups/comments...', 'groups/comments')
#17 src/XF/ControllerPlugin/Reaction.php(12): XF\ControllerPlugin\Reaction->actionReact(Object(Truonglv\Groups\Entity\Comment), 'groups/comments', 'groups/comments...', 'groups/comments...')
#18 src/addons/Truonglv/Groups/Pub/Controller/Comment.php(82): XF\ControllerPlugin\Reaction->actionReactSimple(Object(Truonglv\Groups\Entity\Comment), 'groups/comments')
#19 src/XF/Mvc/Dispatcher.php(321): Truonglv\Groups\Pub\Controller\Comment->actionReact(Object(XF\Mvc\ParameterBag))
#20 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('Truonglv\\Groups...', 'React', Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Comment), NULL)
#21 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Comment), NULL)
#22 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#23 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#24 src/XF.php(390): XF\App->run()
#25 index.php(20): XF::runApp('XF\\Pub\\App')
#26 {main}
 
Disabling Reaction Plus add-on, outputs this error:

Code:
XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'reaction_score' at row 1 src/XF/Db/AbstractStatement.php:217


UPDATE  `xf_tl_group_comment` SET `reaction_score` = ?, `reactions` = ?, `reaction_users` = ? WHERE `comment_id` = 605
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(326): XF\Db\AbstractAdapter->query('UPDATE  `xf_tl_...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1457): XF\Db\AbstractAdapter->update('xf_tl_group_com...', Array, '`comment_id` = ...')
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Reaction/AbstractHandler.php(107): XF\Mvc\Entity\Entity->save()
#7 src/XF/Repository/Reaction.php(269): XF\Reaction\AbstractHandler->updateContentReactions(Object(Truonglv\Groups\Entity\Comment), Array, Array)
#8 src/XF/Entity/ReactionContent.php(198): XF\Repository\Reaction->rebuildContentReactionCache('tl_group_commen...', 605, false)
#9 src/XF/Entity/ReactionContent.php(140): XF\Entity\ReactionContent->rebuildContentReactionCache()
#10 src/XF/Mvc/Entity/Entity.php(1208): XF\Entity\ReactionContent->_postSave()
#11 src/XF/Repository/Reaction.php(184): XF\Mvc\Entity\Entity->save()
#12 src/XF/Repository/Reaction.php(137): XF\Repository\Reaction->insertReaction(15, 'tl_group_commen...', 605, Object(SV\SignupAbuseBlocking\XF\Entity\User), true, false)
#13 src/XF/ControllerPlugin/Reaction.php(65): XF\Repository\Reaction->reactToContent(15, 'tl_group_commen...', 605, Object(SV\SignupAbuseBlocking\XF\Entity\User), true)
#14 src/XF/ControllerPlugin/Reaction.php(19): XF\ControllerPlugin\Reaction->actionToggleReaction(Object(Truonglv\Groups\Entity\Comment), 'groups/comments...', 'groups/comments')
#15 src/XF/ControllerPlugin/Reaction.php(12): XF\ControllerPlugin\Reaction->actionReact(Object(Truonglv\Groups\Entity\Comment), 'groups/comments', 'groups/comments...', 'groups/comments...')
#16 src/addons/Truonglv/Groups/Pub/Controller/Comment.php(82): XF\ControllerPlugin\Reaction->actionReactSimple(Object(Truonglv\Groups\Entity\Comment), 'groups/comments')
#17 src/XF/Mvc/Dispatcher.php(321): Truonglv\Groups\Pub\Controller\Comment->actionReact(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('Truonglv\\Groups...', 'React', Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Comment), NULL)
#19 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Comment), NULL)
#20 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#22 src/XF.php(390): XF\App->run()
#23 index.php(20): XF::runApp('XF\\Pub\\App')
#24 {main}

But! I've just confirmed this only occurs when using other reactions (added ones) AND only to posts of users that are NOT a member of that group.
 
It's fixed now. It's not related to member belong to group or not. Just table structure issue.
 
Back
Top