[TYPO3-mvc] Really strange behavior with $query->statement.

[Braulio J. Solano-Rojas]

El 07/08/2010 10:47 p.m., Braulio J. Solano-Rojas escribió:
>  [Snip]
> $query->statement('SELECT tx_loginusertrack_pagestat.page_id,
> SUM(tx_loginusertrack_pagestat.hits) as hits

Returning the uid is mandatory, if not the query won't work as expected.

Working code:

$query->statement('SELECT tx_loginusertrack_pagestat.uid, 
tx_loginusertrack_pagestat.page_id, SUM(tx_loginusertrack_pagestat.hits) 
as hits

Best regards,

B.