TYPO3 Core

class.tx_taskcenterrecent.php uses the following sql-query in line 86ff.

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
'sys_log.*, max(sys_log.tstamp) AS tstamp_MAX',
'sys_log,pages',
'pages.uid=sys_log.event_pid AND sys_log.userid='.intval($this->BE_USER->user['uid']).
$this->logWhere.
' AND '.$this->perms_clause,
'tablename,recuid',
'tstamp_MAX DESC',
$this->numberOfRecentAll
);

this query produces the following error message when using postgresql through dbal:

ERROR: column "sys_log.uid" must appear in the GROUP BY clause or be used in an aggregate function.

most of the databases following the standards require all columns in GROUP BY also to be in the select clause.

(issue imported from #M2360)