Mysql 'full_group_by' mode not compatible

[vasilvestre]

For query

SELECT DATE(s0_.created_at) AS sclr_0, count(s0_.id) AS sclr_1, MONTH(s0_.created_at) AS sclr_2, YEAR(s0_.created_at) AS sclr_3 FROM sylius_order s0_ WHERE s0_.created_at >= ? AND s0_.created_at <= ? GROUP BY sclr_2, sclr_3 ORDER BY sclr_0 ASC, sclr_2 ASC, sclr_3 ASC' with params ["1919-09-03 00:00:00", "2019-09-03 23:59:59"

The error

Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gifts.s0_.created_at' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by").

[songecko]

Hi @vasilvestre . You need to change the sql_mode. We need that configuration in order to make complex queries. For the near future we have the plan to use Elastic search instead of SQL to make the report queries.

[vasilvestre]

I hoped something else could have been done as the mode can reduce performance :/

[bigboss86]

Solved!