Environment
Local installation MODX 2.7.1, MySQL 5.7.23, CrossContextSettings 1.0.5-pl
Error
Errorlog:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xyz.modContextSetting.context_key' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
No values are shown in the grid.
Workaround
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Only valid until restart of mysql server
The option ONLY_FULL_GROUP_BY seems to be default in MySQL.
Expected behaviour
no error
Environment
Local installation MODX 2.7.1, MySQL 5.7.23, CrossContextSettings 1.0.5-pl
Error
Errorlog:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xyz.modContextSetting.context_key' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byNo values are shown in the grid.
Workaround
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));Only valid until restart of mysql server
The option
ONLY_FULL_GROUP_BYseems to be default in MySQL.Expected behaviour
no error