XF 2.1 Ошибка в журнале, MySQL fetch error

Статус
В этой теме нельзя размещать новые ответы.
Версия XenForo
2.1.6

xenforomen

Проверенные
Сообщения
419
Реакции
123
Баллы
11,045
Привет!

Начали сыпаться ошибки от разных пользователей, кто нибудь сталкивался с такими проблемами? Хостинг не помогает, говорит, что скажите что нужно сделать, сделаем)))

Код:
XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228
Сгенерирована пользователем: Неизвестная учётная запись 21 Янв 2020 в 17:03
Трассировка стека
            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` = 21) AND (`xf_user_profile_Profile_1`.`dob_month` = 1) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1548068596) 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(93): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1296): 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(138): call_user_func_array(Array, Array)
#7 src/XF/Service/MemberStat/Preparer.php(199): XF\Service\MemberStat\Preparer->applyCallback('XF\\MemberStat\\B...', 'getBirthdayUser...', Object(XF\Finder\User))
#8 src/XF/Service/MemberStat/Preparer.php(63): 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(34): call_user_func(Array, Object(XF\Entity\CronEntry))
#12 src/XF/Job/Manager.php(253): XF\Job\Cron->run(G)
#13 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#14 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#15 job.php(42): XF\Job\Manager->runQueue(false, 8)
#16 {main}
Содержимое запроса
array(4) {
  ["url"] => string(8) "/job.php"
  ["referrer"] => string(58) "/threads/vzlom-icloud.4203/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

или такие
Код:
XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228
Сгенерирована пользователем: Неизвестная учётная запись 21 Янв 2020 в 15:08
Трассировка стека
            SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.*, `xf_snog_forms_promotions_Promotions_6`.*
            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_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
LEFT JOIN `xf_snog_forms_promotions` AS `xf_snog_forms_promotions_Promotions_6` ON (`xf_snog_forms_promotions_Promotions_6`.`post_id` = `xf_post`.`post_id`)
            WHERE (`xf_post`.`thread_id` = 9764) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
            ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
       
------------

#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/Pub/Controller/Thread.php(35): XF\Mvc\Entity\Finder->fetch()
#5 src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php(16): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(350): Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(Snog\Forms\XF\Pub\Controller\Thread), NULL)
#8 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Snog\Forms\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#11 src/XF.php(391): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}
Содержимое запроса
array(4) {
  ["url"] => string(54) "/threads/instrukcii.9764/"
  ["referrer"] => bool(false)
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
Такие же ошибки появляются с периодичностью раз в сутки в одно и то же время. Не могу понять причину.
  • XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228

Трассировка стека​

Код:
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` > 1598322457)
            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}

Содержимое запроса​

Код:
array(4) {
  ["url"] => string(24) "/whats-new/posts/472269/"
  ["referrer"] => bool(false)
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
StopCod, выполни этот код в БД и посмотри на что ругнется
Код:
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` > 1598322457)
            ORDER BY `xf_thread`.`last_post_date` DESC
        
LIMIT 200
 
Последнее редактирование:
выполни этот код в БД и посмотри на что ругнется
SQL-запрос успешно выполнен.

EXPLAIN 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` > 1598322457)
ORDER BY `xf_thread`.`last_post_date` DESC

LIMIT 200


1 SIMPLE xf_forum_Forum_1
NULL
ALL PRIMARY
NULL

NULL

NULL
55 10.00 Using where; Using temporary; Using filesort
1 SIMPLE xf_node_Node_2
NULL
eq_ref PRIMARY PRIMARY 4 admin_base.xf_forum_Forum_1.node_id 1 100.00
NULL

1 SIMPLE xf_permission_cache_content_Permissions_3
NULL
eq_ref PRIMARY PRIMARY 35 const,const,admin_base.xf_node_Node_2.node_id 1 100.00 Using where
1 SIMPLE xf_thread
NULL
ref node_id_last_post_date,node_id_sticky_state_last_p... node_id_last_post_date 4 admin_base.xf_forum_Forum_1.node_id 52 4.35 Using index condition; Using where
 
Ребята, проблема у кого ни будь решилась? Я пару часов назад переехал с шаред хостинга на виртуальный сервер у другого хостера и появилась такая ошибка в журнале. На старом хосте такого не было.
v2.1.12

Код:
XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228
Сгенерирована пользователем: Неизвестная учётная запись Янв 13, 2021 в 2:16 PM

Код:
Трассировка стека
            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` = 13) AND (`xf_user_profile_Profile_1`.`dob_month` = 1) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1579000581) 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(93): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1296): 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(138): call_user_func_array(Array, Array)
#7 src/XF/Service/MemberStat/Preparer.php(199): XF\Service\MemberStat\Preparer->applyCallback('XF\\MemberStat\\B...', 'getBirthdayUser...', Object(XF\Finder\User))
#8 src/XF/Service/MemberStat/Preparer.php(63): 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(253): XF\Job\Cron->run(G)
#13 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#14 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#15 job.php(42): XF\Job\Manager->runQueue(false, 8)
#16 {main}

Код:
array(4) {
  ["url"] => string(8) "/job.php"
  ["referrer"] => string(23) "https://slivkursov.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
ццмянный.jpg
 
Последнее редактирование:
Ребята, проблема у кого ни будь решилась? Я пару часов назад переехал с шаред хостинга на виртуальный сервер у другого хостера и появилась такая ошибка в журнале. На старом хосте такого не было.
v2.1.12

Код:
XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now src/XF/Db/AbstractStatement.php:228
Сгенерирована пользователем: Неизвестная учётная запись Янв 13, 2021 в 2:16 PM

Код:
Трассировка стека
            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` = 13) AND (`xf_user_profile_Profile_1`.`dob_month` = 1) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1579000581) 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(93): XF\Db\Mysqli\Statement->fetchRowValues()
#3 src/XF/Mvc/Entity/Finder.php(1296): 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(138): call_user_func_array(Array, Array)
#7 src/XF/Service/MemberStat/Preparer.php(199): XF\Service\MemberStat\Preparer->applyCallback('XF\\MemberStat\\B...', 'getBirthdayUser...', Object(XF\Finder\User))
#8 src/XF/Service/MemberStat/Preparer.php(63): 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(253): XF\Job\Cron->run(G)
#13 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#14 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#15 job.php(42): XF\Job\Manager->runQueue(false, 8)
#16 {main}

Код:
array(4) {
  ["url"] => string(8) "/job.php"
  ["referrer"] => string(23) "https://slivkursov.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
Посмотреть вложение 124699
Привет. Такая-же ошибка на новом сервере постоянно выскакивает. Подскажи пожалуйста как решил проблему?
 
Статус
В этой теме нельзя размещать новые ответы.
Современный облачный хостинг провайдер | Aéza
Назад
Сверху Снизу