Hi, I use MODX 2.6.1 with php 7.0.26.
Since I updated mySQL to 5.7.20 I get this error:
[2017-12-12 23:23:23] (ERROR @ ......./core/xpdo/om/xpdoobject.class.php : 240) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1055
[2] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'usr_web555_5.modManagerLog.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
I guess this issue is well known since mySQL version 5.7.5+ ?
e.g.:
stackoverflow.com
and it worked by changing the sql mode:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
My question please: Does this command really solve the error and why is it not fixed in MODX?
jo