Server issue Search logs: XF\Db\Exception: MySQL fetch error [2014]

[soloarquitectura]

Affected version

2.3.2

When searching logs, this error is displayed if the "Admin logs" checkbox is checked:

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
1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 142
3. XF\Db\Mysqli\Statement->fetchRowValues() in src/XF/Db/AbstractStatement.php at line 95
4. XF\Db\AbstractStatement->fetchAliasGrouped() in src/XF/Mvc/Entity/Finder.php at line 1494
5. XF\Mvc\Entity\Finder->getCollectionFromResults() in src/XF/Mvc/Entity/Finder.php at line 1450
6. XF\Mvc\Entity\Finder->fetch() in src/XF/AdminSearch/AbstractFieldSearch.php at line 131
7. XF\AdminSearch\AbstractFieldSearch->search() in src/XF/LogSearch/Searcher.php at line 79
8. XF\LogSearch\Searcher->search() in src/XF/Admin/Controller/LogController.php at line 81
9. XF\Admin\Controller\LogController->actionSearch() in src/XF/Mvc/Dispatcher.php at line 362
10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
14. XF\App->run() in src/XF.php at line 802
15. XF::runApp() in admin.php at line 15

If Admin logs is unchecked, the search works correctly.
I tested in XenForo demo and it does work, so it must be related to my settings.
All I can say is that I have Moderator log length: 1 Days.
But even so, the error should not appear.

 

[Jeremy P]

This is likely down to an issue with the database server. What version of MySQL are you using? Does anything appear in the MySQL logs?

 

[soloarquitectura]

MySQL 8.0.39

I don't know how to view MySQL logs, sorry.

 

[soloarquitectura]

From what I see here:

XF 2.2 Thread '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 228'

Dec 22, 2020

Hi, if I try to enter banned users in acp or if they ban a user I get this error:
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 228

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 134
3. XF\Db\Mysqli\Statement->fetchRowValues() in src/XF/Db/AbstractStatement.php at line 93...

• Goose
• Replies: 3
• Forum: Troubleshooting and problems

It could be related to the MySQL version.

Error "1038 Out of sort memory, consider increasing sort buffer size

In symfony2, doctrine2, I have a query which triggers an error : Error "1038 Out of sort memory, consider increasing server sort buffer size The query : $queryBuilder = $this ->

stackoverflow.com

 

[soloarquitectura]

Fixed with:
XenForo 2.3.4
PHP 8.3.13
MySQL 8.0.40