Issue Bug Closed

#79322Invalid SQL Statement created in Extbase getObjectCountByQuery()

Morton Jonuschat 01/15/17, 06:32 updated 10/17/17, 23:28

Description

Opening the TER extension list with PostgreSQL Database (probably also in MySQL with ONLY_FULL_GROUP_BY enabled) triggers and SQL error due to counting all fields using COUNT and trying to sort the result.:

SQL Statement created:

SELECT COUNT(*) FROM "tx_extensionmanager_domain_model_extension" "tx_extensionmanager_domain_model_extension" WHERE ("tx_extensionmanager_domain_model_extension"."current_version" = :dcValue1) AND ("tx_extensionmanager_domain_model_extension"."review_state" >= :dcValue2) ORDER BY "tx_extensionmanager_domain_model_extension"."last_updated" DESC

Error:

SQLSTATE[42803]: Grouping error: 7 ERROR:  column "tx_extensionmanager_domain_model_extension.last_updated" must appear in the GROUP BY clause or be used in an aggregate function

Reviews 1