XF 2.1 Server error

alternadiv

Well-known member
Hi, just got this one. Not sure what it means.

[LIST] [*]XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now [*] [*]src/XF/Db/AbstractStatement.php:228 [*]Generated by: Unknown account [*] [*]Sep 11, 2020 at 6:29 AM [/LIST] [HEADING=2]Stack trace[/HEADING] SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permissions_3`.* FROM `xf_thread` INNER JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1') WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`discussion_state` <> 'deleted') AND (`xf_thread`.`last_post_date` > 1568284156) ORDER BY `xf_thread`.`last_post_date` DESC LIMIT 200 ------------ #0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL fetch err...', 2014, 'HY000') #1 src/XF/Db/Mysqli/Statement.php(134): XF\Db\Mysqli\Statement->getException('MySQL fetch err...', 2014, 'HY000') #2 src/XF/Db/AbstractStatement.php(93): XF\Db\Mysqli\Statement->fetchRowValues() #3 src/XF/Mvc/Entity/Finder.php(1296): XF\Db\AbstractStatement->fetchAliasGrouped() #4 src/XF/FindNew/Thread.php(110): XF\Mvc\Entity\Finder->fetch('200') #5 src/XF/ControllerPlugin/FindNew.php(63): XF\FindNew\Thread->getResultIds(Array, '200') #6 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch(Object(XF\FindNew\Thread), Array) #7 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction(Object(XF\FindNew\Thread), Array) #8 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex(Object(XF\Mvc\ParameterBag)) #9 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:WhatsNewPost', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\WhatsNewPost), NULL) #10 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\WhatsNewPost), NULL) #11 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #12 src/XF/App.php(2190): XF\Mvc\Dispatcher->run() #13 src/XF.php(391): XF\App->run() #14 index.php(20): XF::runApp('XF\\Pub\\App') #15 {main} [HEADING=2]Request state[/HEADING] array(4) { ["url"] => string(24) "/whats-new/posts/604885/" ["referrer"] => bool(false) ["_GET"] => array(0) { } ["_POST"] => array(0) { } }
 
I think it's a SQL error maybe is not compatible with XF or you must upgrade it to a new version or use MariaDB is better than MySQL

  • XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now
  • src/XF/Db/AbstractStatement.php:228
  • Generated by: Unknown account
  • Sep 11, 2020 at 6:29 AM

Stack trace​

SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2., xf_permission_cache_content_Permissions_3.
FROM xf_thread
INNER JOIN xf_forum AS xf_forum_Forum_1 ON (xf_forum_Forum_1.node_id = xf_thread.node_id)
LEFT JOIN xf_node AS xf_node_Node_2 ON (xf_node_Node_2.node_id = xf_forum_Forum_1.node_id)
LEFT JOIN xf_permission_cache_content AS xf_permission_cache_content_Permissions_3 ON (xf_permission_cache_content_Permissions_3.content_type = 'node' AND xf_permission_cache_content_Permissions_3.content_id = xf_node_Node_2.node_id AND xf_permission_cache_content_Permissions_3.permission_combination_id = '1')
WHERE (xf_forum_Forum_1.find_new = 1) AND (xf_thread.discussion_type <> 'redirect') AND (xf_thread.discussion_state <> 'deleted') AND (xf_thread.last_post_date > 1568284156)
ORDER BY xf_thread.last_post_date DESC

LIMIT 200
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL fetch err...', 2014, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(134): XF\Db\Mysqli\Statement->getException('MySQL fetch err...', 2014, 'HY000')
#2 src/XF/Db/AbstractStatement.php(93): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1296): XF\Db\AbstractStatement->fetchAliasGrouped()
#4 src/XF/FindNew/Thread.php(110): XF\Mvc\Entity\Finder->fetch('200')
#5 src/XF/ControllerPlugin/FindNew.php(63): XF\FindNew\Thread->getResultIds(Array, '200')
#6 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch(Object(XF\FindNew\Thread), Array)
#7 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction(Object(XF\FindNew\Thread), Array)
#8 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:WhatsNewPost', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\WhatsNewPost), NULL)
#10 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\WhatsNewPost), NULL)
#11 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2190): XF\Mvc\Dispatcher->run()
#13 src/XF.php(391): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state​

array(4) {
["url"] => string(24) "/whats-new/posts/604885/"
["referrer"] => bool(false)
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Back
Top Bottom