MySql Issue - Json

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c1_dev01.workings.id' which is not functionally dependent on columns in GROUP BY clause;
Incompatible with sql_mode=only_full_group_by Syntax error or access violation: 1055 Expression.

MySQL server-en Root módban

• SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',));

Vagy:

• PHP MyAdmin (root) -> Localhost -> Variables (Változók) -> sql mode

megjegyzés

/etc/mysql/my.cnf v. /etc/my.cnf

[mysqld]

sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

delete only_full_group_by

Forrás

https://stackoverflow.com/questions/23921117/disable-only-full-group-by