KSA
Well-known member
Hey @Xon getting these errors recently not sure what is going on!
Code:
XF\Db\InvalidQueryException: MySQL statement prepare error [3143]: Invalid JSON path expression. The error is around character position 3. src/XF/Db/AbstractStatement.php:230
Generated by: Sep 16, 2023 at 9:19 PM
Stack trace
UPDATE xf_user
SET sv_sent_reactions = JSON_SET(coalesce(sv_sent_reactions, '{}'), '$.1', greatest(0, coalesce(JSON_VALUE(coalesce(sv_sent_reactions, '{}'), '$.1'), 0) + 1) )
WHERE user_id = ?
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 3143, '42000')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 3143, '42000')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/addons/SV/ContentRatings/XF/Repository/Reaction.php(773): XF\Db\AbstractAdapter->query('
...', Array)
#5 src/addons/SV/ContentRatings/XF/Entity/ReactionContent.php(108): SV\ContentRatings\XF\Repository\Reaction->svUpdateUserReactions(31770, Array, true)
#6 src/XF/Entity/ReactionContent.php(117): SV\ContentRatings\XF\Entity\ReactionContent->adjustUserReactionScore(43354, 0)
#7 src/addons/SV/ContentRatings/XF/Entity/ReactionContent.php(180): XF\Entity\ReactionContent->_postSave()
#8 src/XF/Mvc/Entity/Entity.php(1277): SV\ContentRatings\XF\Entity\ReactionContent->_postSave()
#9 src/XF/Repository/Reaction.php(191): XF\Mvc\Entity\Entity->save()
#10 src/addons/SV/ContentRatings/XF/Repository/Reaction.php(1006): XF\Repository\Reaction->insertReaction(1, 'post', 5307566, Object(SV\SearchImprovements\XF\Entity\User), true, false)
#11 src/XF/Repository/Reaction.php(144): SV\ContentRatings\XF\Repository\Reaction->insertReaction(1, 'post', 5307566, Object(SV\SearchImprovements\XF\Entity\User), true, false)
#12 src/XF/ControllerPlugin/Reaction.php(67): XF\Repository\Reaction->reactToContent(1, 'post', 5307566, Object(SV\SearchImprovements\XF\Entity\User), true)
#13 src/XF/ControllerPlugin/Reaction.php(21): XF\ControllerPlugin\Reaction->actionToggleReaction(Object(SV\WarningImprovements\XF\Entity\Post), 'posts/reactions', 'posts')
#14 src/XF/ControllerPlugin/Reaction.php(14): XF\ControllerPlugin\Reaction->actionReact(Object(SV\WarningImprovements\XF\Entity\Post), 'posts', 'posts/react', 'posts/reactions')
#15 src/XF/Pub/Controller/Post.php(381): XF\ControllerPlugin\Reaction->actionReactSimple(Object(SV\WarningImprovements\XF\Entity\Post), 'posts')
#16 src/addons/KL/EditorManager/XF/Pub/Controller/Post.php(30): XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(352): KL\EditorManager\XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Post', 'React', Object(XF\Mvc\RouteMatch), Object(LiamW\MentionMiniAvatar\XF\Pub\Controller\Post), NULL)
#19 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(LiamW\MentionMiniAvatar\XF\Pub\Controller\Post), NULL)
#20 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#22 src/XF.php(524): XF\App->run()
#23 index.php(20): XF::runApp('XF\\Pub\\App')
#24 {main}
Code:
XF\Db\InvalidQueryException: MySQL statement prepare error [3143]: Invalid JSON path expression. The error is around character position 4. src/XF/Db/AbstractStatement.php:230
Generated by: Sep 16, 2023 at 9:11 PM
Stack trace
UPDATE xf_user
SET sv_sent_reactions = JSON_SET(coalesce(sv_sent_reactions, '{}'), '$.24', greatest(0, coalesce(JSON_VALUE(coalesce(sv_sent_reactions, '{}'), '$.24'), 0) + 1) )
WHERE user_id = ?
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 3143, '42000')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 3143, '42000')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/addons/SV/ContentRatings/XF/Repository/Reaction.php(773): XF\Db\AbstractAdapter->query('
...', Array)
#5 src/addons/SV/ContentRatings/XF/Entity/ReactionContent.php(108): SV\ContentRatings\XF\Repository\Reaction->svUpdateUserReactions(8209, Array, true)
#6 src/XF/Entity/ReactionContent.php(117): SV\ContentRatings\XF\Entity\ReactionContent->adjustUserReactionScore(48936, 0)
#7 src/addons/SV/ContentRatings/XF/Entity/ReactionContent.php(180): XF\Entity\ReactionContent->_postSave()
#8 src/XF/Mvc/Entity/Entity.php(1277): SV\ContentRatings\XF\Entity\ReactionContent->_postSave()
#9 src/XF/Repository/Reaction.php(191): XF\Mvc\Entity\Entity->save()
#10 src/addons/SV/ContentRatings/XF/Repository/Reaction.php(1006): XF\Repository\Reaction->insertReaction(24, 'post', 5307478, Object(SV\SearchImprovements\XF\Entity\User), true, false)
#11 src/XF/Repository/Reaction.php(144): SV\ContentRatings\XF\Repository\Reaction->insertReaction(24, 'post', 5307478, Object(SV\SearchImprovements\XF\Entity\User), true, false)
#12 src/XF/ControllerPlugin/Reaction.php(67): XF\Repository\Reaction->reactToContent(24, 'post', 5307478, Object(SV\SearchImprovements\XF\Entity\User), true)
#13 src/XF/ControllerPlugin/Reaction.php(21): XF\ControllerPlugin\Reaction->actionToggleReaction(Object(SV\WarningImprovements\XF\Entity\Post), 'posts/reactions', 'posts')
#14 src/XF/ControllerPlugin/Reaction.php(14): XF\ControllerPlugin\Reaction->actionReact(Object(SV\WarningImprovements\XF\Entity\Post), 'posts', 'posts/react', 'posts/reactions')
#15 src/XF/Pub/Controller/Post.php(381): XF\ControllerPlugin\Reaction->actionReactSimple(Object(SV\WarningImprovements\XF\Entity\Post), 'posts')
#16 src/addons/KL/EditorManager/XF/Pub/Controller/Post.php(30): XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(352): KL\EditorManager\XF\Pub\Controller\Post->actionReact(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Post', 'React', Object(XF\Mvc\RouteMatch), Object(LiamW\MentionMiniAvatar\XF\Pub\Controller\Post), NULL)
#19 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(LiamW\MentionMiniAvatar\XF\Pub\Controller\Post), NULL)
#20 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#22 src/XF.php(524): XF\App->run()
#23 index.php(20): XF::runApp('XF\\Pub\\App')