Loading sys_language records fails with MySQL 5.7
Ticket on Forge: https://forge.typo3.org/issues/79855
Author: Sebastian Michaelsen
Description:
In \SGalinski\Lfeditor\Service\SysLanguageService::selectFromSysLanguageByUids the following query is created:
SELECT uid, title, flag FROM sys_language GROUP BY flag ASC
It works for me with MySQL 5.6.19 but fails for MySQL 5.7.17:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'naturata.sys_language.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
5.7 seems to have changed behaviour regarding GROUP BY: https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html