Issue Bug Closed

#16960SQL error with DBAL/PostgreSQL: List or look up reviewed extensions

Mathias Behrle 02/08/07, 18:19 updated 03/13/07, 15:19

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.