XF 2.0 MySQL fetch error [2014]: Commands out of sync; you can't run this command now

Asser

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

Server error log
SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.*
FROM `xf_user`
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 5) AND (`xf_user_profile_Profile_1`.`dob_month` = 8) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1501940094) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
ORDER BY `xf_user`.`username` ASC

LIMIT 60
------------

#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(88): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1165): XF\Db\AbstractStatement->fetchAliasGrouped()
#4 src/XF/MemberStat/Birthdays.php(14): XF\Mvc\Entity\Finder->fetch(60)
#5 [internal function]: XF\MemberStat\Birthdays::getBirthdayUsers(Object(XF\Entity\MemberStat), Object(XF\Finder\User))
#6 src/XF/Service/MemberStat/Preparer.php(132): call_user_func_array(Array, Array)
#7 src/XF/Service/MemberStat/Preparer.php(190): XF\Service\MemberStat\Preparer->applyCallback('XF\\MemberStat\\B...', 'getBirthdayUser...', Object(XF\Finder\User))
#8 src/XF/Service/MemberStat/Preparer.php(62): XF\Service\MemberStat\Preparer->getResultsData()
#9 src/XF/Cron/MemberStats.php(19): XF\Service\MemberStat\Preparer->cache()
#10 [internal function]: XF\Cron\MemberStats::rebuildMemberStatsCache(Object(XF\Entity\CronEntry))
#11 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#12 src/XF/Job/Manager.php(241): XF\Job\Cron->run(8)
#13 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 8)
#14 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 8)
#15 job.php(15): XF\Job\Manager->runQueue(false, 8)
#16 {main}

array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(87) "https://example.com/resources/................................../"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Top Bottom