XF 2.2 XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:230

isadorcj

New member
I am on V 2.2.9

I have multiple related error like this. What can I do ? Please help.


SELECT xf_post., xf_user_User_1., xf_user_option_Option_2., xf_user_profile_Profile_3., xf_user_privacy_Privacy_4., xf_permission_combination_PermissionCombination_5., xf_session_activity_Activity_6., xf_reaction_content_Reactions_7., xf_bookmark_item_Bookmarks_8.*
FROM xf_post
LEFT JOIN xf_user AS xf_user_User_1 ON (xf_user_User_1.user_id = xf_post.user_id)
LEFT JOIN xf_user_option AS xf_user_option_Option_2 ON (xf_user_option_Option_2.user_id = xf_user_User_1.user_id)
LEFT JOIN xf_user_profile AS xf_user_profile_Profile_3 ON (xf_user_profile_Profile_3.user_id = xf_user_User_1.user_id)
LEFT JOIN xf_user_privacy AS xf_user_privacy_Privacy_4 ON (xf_user_privacy_Privacy_4.user_id = xf_user_User_1.user_id)
LEFT JOIN xf_permission_combination AS xf_permission_combination_PermissionCombination_5 ON (xf_permission_combination_PermissionCombination_5.permission_combination_id = xf_user_User_1.permission_combination_id)
LEFT JOIN xf_session_activity AS xf_session_activity_Activity_6 ON (xf_session_activity_Activity_6.user_id = xf_user_User_1.user_id AND xf_session_activity_Activity_6.unique_key = CONCAT(xf_user_User_1.user_id, ''))
LEFT JOIN xf_reaction_content AS xf_reaction_content_Reactions_7 ON (xf_reaction_content_Reactions_7.content_type = 'post' AND xf_reaction_content_Reactions_7.content_id = xf_post.post_id AND xf_reaction_content_Reactions_7.reaction_user_id = '6665')
LEFT JOIN xf_bookmark_item AS xf_bookmark_item_Bookmarks_8 ON (xf_bookmark_item_Bookmarks_8.content_type = 'post' AND xf_bookmark_item_Bookmarks_8.content_id = xf_post.post_id AND xf_bookmark_item_Bookmarks_8.user_id = '6665')
WHERE (xf_post.thread_id = 188767) AND ((xf_post.message_state = 'moderated' AND xf_post.user_id = 6665) OR (xf_post.message_state IN ('visible'))) AND (xf_post.position >= 30) AND (xf_post.position < 60)
ORDER BY xf_post.position ASC, xf_post.post_date ASC

------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL fetch err...', 2014, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(136): XF\Db\Mysqli\Statement->getException('MySQL fetch err...', 2014, 'HY000')
#2 src/XF/Db/AbstractStatement.php(95): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1394): XF\Db\AbstractStatement->fetchAliasGrouped()
#4 src/XF/Pub/Controller/Thread.php(65): XF\Mvc\Entity\Finder->fetch()
#5 src/addons/AddonFlare/GlobalIgnore/XF/Pub/Controller/Thread.php(11): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(352): AddonFlare\GlobalIgnore\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(263): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(AddonFlare\GlobalIgnore\XF\Pub\Controller\Thread), NULL)
#8 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(AddonFlare\GlobalIgnore\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2352): XF\Mvc\Dispatcher->run()
#11 src/XF.php(524): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}
 
Top