fei

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!

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