DanielSiepmann / tracking

TYPO3 Extension providing server side tracking.
https://daniel-siepmann.de/projects/typo3-extension-tracking.html
GNU General Public License v2.0
17 stars 2 forks source link

SQL Mode ONLY_FULL_GROUP_BY causes Exception #35

Closed koritnik closed 4 years ago

koritnik commented 4 years ago

When SQL Mode ONLY_FULL_GROUP_BY activated, which is a default since version 5.7, the dashboard widget throws an exception.

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'typo3.tx_tracking_pageview.sys_language_uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by