XF 2.2 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

[Goose]

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
4. XF\Db\AbstractStatement->fetchAliasGrouped() in src/XF/Mvc/Entity/Finder.php at line 1381
5. XF\Mvc\Entity\Finder->fetch() in src/XF/Admin/Controller/Banning.php at line 48
6. XF\Admin\Controller\Banning->actionUsers() in src/XF/Mvc/Dispatcher.php at line 350
7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
11. XF\App->run() in src/XF.php at line 488
12. XF::runApp() in admin.php at line 13

In mysql log : [ERROR] [MY-013131] [Server] Out of sort memory, consider increasing server sort buffer size!

 

[Chris D]

This is unlikely to be a bug and it may instead be MySQL server version related.

Please provide details of the current version of MySQL that you are using.

 

[Goose]

mysql Ver 8.0.22-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)

This is unlikely to be a bug and it may instead be MySQL server version related.

Please provide details of the current version of MySQL that you are using.

 

[Goose]

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