Skaiman
Проверенные
- Сообщения
- 18,376
- Решения
- 234
- Реакции
- 33,972
- Баллы
- 21,375
При входе на главной, вместо списка узлов ошибка:
В админке:
Если перезагрузить сервер, все работает какое то время, потом снова
Версия PHP 7.4.32
Версия MySQL10.1.41 (10.1.41-MariaDB-0+deb9u1)
Код:
XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 136
XF\Db\Mysqli\Statement->fetchRowValues() in src/XF/Db/AbstractStatement.php at line 95
XF\Db\AbstractStatement->fetchAliasGrouped() in src/XF/Mvc/Entity/Finder.php at line 1432
XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 20
XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 54
XF\Pub\Controller\Forum->actionList() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
XF\App->run() in src/XF.php at line 524
XF::runApp() in index.php at line 20
Код:
XF\Db\Exception: MySQL query error [1712]: Index xf_post is corrupted src/XF/Db/AbstractStatement.php:230
Сгенерировано пользователем: Неизвестная учётная запись 21 Авг 2024 в 05:52
Трассировка стека
SELECT `xf_thread`.*, `xf_post_LastPost_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_thread`
LEFT JOIN `xf_post` AS `xf_post_LastPost_1` ON (`xf_post_LastPost_1`.`post_id` = `xf_thread`.`last_post_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '114003')
LIMIT 1
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1712, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1712, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Mvc/Entity/Finder.php(1397): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#4 src/XF/Mvc/Entity/Manager.php(151): XF\Mvc\Entity\Finder->fetchOne()
#5 src/XF/Pub/Controller/Thread.php(1628): XF\Mvc\Entity\Manager->find('XF:Thread', '114003', Array)
#6 src/XF/Pub/Controller/Thread.php(282): XF\Pub\Controller\Thread->assertViewableThread('114003', Array)
#7 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Thread->actionLatest(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Latest', Object(XF\Mvc\RouteMatch), Object(TickTackk\ChangeContentOwner\XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(TickTackk\ChangeContentOwner\XF\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2483): XF\Mvc\Dispatcher->run()
#12 src/XF.php(524): XF\App->run()
#13 index.php(20): XF::runApp('XF\\Pub\\App')
#14 {main}
Версия PHP 7.4.32
Версия MySQL10.1.41 (10.1.41-MariaDB-0+deb9u1)