fei
-
Posts
2 -
Joined
-
Last visited
Posts posted by fei
-
-
I have an issue with the the latest Era server installed on Centos 6.7
The issue seems like a problem with Mysql connection.
In the server trace.log i get this message
Error: CCleanupModule [Thread 7f256d9e8700]: [MySQL][ODBC 5.3(a) Driver][mysqld-5.7.10]Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'era_db.a.SourceUuid_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Anybody out there who knows how i can sort this issue?
Regards,
Fei
Problems with Era 6 installed on centos 6.7
in ESET PROTECT On-prem (Remote Management)
Posted
Hi Marcos,
I have tried to edit the my.cnf in /etc but i still get the same error.
Is it sql-mode or sql_mode?
when i do a select @@sql-mode; i see the mode is enabled without only_full_group_by but i just dont understand why.
Maybe there's another file that i need to edit?
Thanks!