Issue Bug Closed

#15485dbal error in taskcenter_recent

Christian Welzel 01/22/06, 18:55 updated 10/14/10, 14:30

Description

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.