[TYPO3-core] FYI: Fixed bug #4947: SQL error with DBAL/PostgreSQL when listing or looking up reviewed extensions

[Martin Kutschker]

Hi!

Problem: PostgreSQL doesn't like an order clause to conatain fields not 
in a grouping clause or in an aggregate function. This broke the EM on 
PostgreSQL.

Solution: Remove superfluos order clause in a select for COUNT(*).

Note: the patch also removes one line of dead code (duplication of the 
count(*) SQL statement.

Masi
-------------- next part --------------
A non-text attachment was scrubbed...
Name: em_xmlhandler.php-count.diff
Type: text/x-diff
Size: 924 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20070215/be32d042/attachment.bin