Problem with "only_full_group_by"

[Jose Ferronato]

Hi, i have a problem with the "only_full_group_by".

I have a ETL file running, to collect data and bulk on another database, but i receive the error below:

Quote

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'zabbix_reports.ft_events_ciclo.seg_month'; this is incompatible with sql_mode=only_full_group_by

But i configure the MySQL do ignore the sql_mode.

Below the MySQL configuration:

Quote

[mysqld]
sql_mode = ""

Or in MySQL CLI

mysql> select @@sql_mode;
+------------+
| @@sql_mode |
+------------+
| |
+------------+
1 row in set (0.00 sec)

I restarted the MySQL.

What is wrong?


Thanks so much