#16960SQL error with DBAL/PostgreSQL: List or look up reviewed extensions
Description
While List or look up reviewed extensions ERROR: column “cache_extensions.category” must appear in the GROUP BY clause or be used in an aggregate function:
SELECT count(*) as “cnt” FROM “cache_extensions” WHERE 1 = 1 AND “reviewstate” > 0 AND “state” != 5 AND “lastreviewedversion” > 0 ORDER BY “category”, “title”
The ORDER BY clause must also be contained in GROUP BY clause.
Attached patch works for me on PostgreSQL.
typo3-dev 4.1 (svn)
postgresql 8.1.4-6~bpo.1
apache2 2.0.54-5sarge1
php5 5.2.0-8~bpo.2
Firefox/Iceweasel/2.0.0.1
(issue imported from #M4947)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.