Issue Bug Closed

#56499SqlParser: Subselect in WHERE not suported

Andreas Fernandez 03/03/14, 16:21 updated 07/30/15, 12:47

Description

Hello TYPO3 team,

updating the extension list after deleting “1.extensions.xml.gz” and “1.mirrors.xml.gz” results in a catchable fatal error:

> PHP Catchable Fatal Error: Argument 1 passed to TYPO3\CMS\Dbal\Database\DatabaseConnection::_quoteWhereClause() must be an array, string given, called in typo3/sysext/dbal/Classes/Database/DatabaseConnection.php on line 1214 and defined in typo3/sysext/dbal/Classes/Database/DatabaseConnection.php line 1702

After some investigation I found out that the error is triggered by the following part:

integer_version=(SELECT MAX("integer_version") FROM "tx_extensionmanager_domain_model_extension"  "b" WHERE   "b"."repository" = 1 AND  "a"."extension_key" = "b"."extension_key") AND repository=1
in typo3/sysext/core/Classes/Database/SqlParser.php in line 1210.

The used regex does not support any subselect in WHERE clause, so the following parse error is triggered:
> No operator, but parsing not finished in parseWhereClause()

Reviews 0

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