Issue Bug Closed

#86986Commands out of sync; you can't run this command now - error on TYPO3 backend module of EXT:indexed_search

Peter Kraume 11/23/18, 16:05 updated 02/09/23, 08:37

Description

In the production environment of my TYPO3 8.7 installation I get this error message when I try to open the TYPO3 backend module “Indexing”:

Commands out of sync; you can't run this command now 

Doctrine\DBAL\Driver\Mysqli\MysqliException thrown in file
/home/www/html-data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php in line 280.

The problem seems to be in the loop in vendor/typo3/cms/typo3/sysext/indexed_search/Classes/Domain/Repository/AdministrationRepository.php in function getRecordsNumbers()

After some research it seems that closeCursor() is necessary, but I wasn’t able to integrate that.

The funny thing is, that the error only occurs in my production environment. On the development machine, everything works fine!

So is this now a TYPO3 bug or a configuration problem of my production machine?

My environment:

- TYPO3 8.7.20

*- Production:*
— PHP 7.2.8
— MySQL 5.6.37
— mysqlnd 5.0.12-dev

*- Development:*
— PHP 7.2.7
— MySQL 5.5.60
— mysqlnd 5.0.12-dev

Only difference is that in the development environment pdo_mysql is not present.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.