[Problems with Era 6 installed on centos 6.7]

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!

[Problems with Era 6 installed on centos 6.7]

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