# Problem with "only\_full\_group\_by"

**URL:** <https://forums.percona.com/t/problem-with-only-full-group-by/5011>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [August 2, 2016, 9:49am UTC](https://forums.percona.com/t/problem-with-only-full-group-by/5011 "2016-08-02T09:49:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![augusto.ferronato](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@augusto.ferronato](https://forums.percona.com/u/augusto.ferronato)\
**Post date:** [August 2, 2016, 9:49am UTC](https://forums.percona.com/t/problem-with-only-full-group-by/5011/1 "2016-08-02T09:49:20Z")

</div>

Hello,  
I try to run a ETL file, but i receive the error below:

> [@](#):
>
> 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

The problem is, i disabled the mode on MySQL:

mysql\> select @@sql\_mode;  
±-----------+  
| @@sql\_mode |  
±-----------+  
| |  
±-----------+  
1 row in set (0.00 sec)

in my.cnf to

> [@](#):
>
> [mysqld]  
> sql\_mode = “”

Restart the MySQL, and the same error occur, how can i solve this? It’s a MySQL problem? Or ETL (Spoon/Pentaho) have some problem?

Thanks so much!
