Issue Bug Closed

#56390Could not parse where clause

Andreas Fernandez 02/27/14, 16:09 updated 10/02/18, 12:02

Description

The Upgrade Wizard in Install Tool crashes with “Could not parse where clause” using DBAL.
DBAL’s DatabaseConnection.php has a method “quoteWhereClause()” which calls “parseWhereClause()” in core/Classes/Database/SqlParser.

The method “nextPart” returns an empty string parsing the part

CAST(CAST(media AS DECIMAL) AS CHAR) <> media OR (CType = 'uploads' AND select_key != '')
^([[:alnum:]._]+)([[:space:]]+|&|\+|-|\*|\/|%|<=|>=|<|>|=|!=|IS)

Reviews 0

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