0

I have migrated my database from older version to newer one.

I have mysql version 5.7.24 now.

I am getting ERROR 1055 (sql_mode=only_full_group_by) for a query which has group by.

I have set sql_mode='' in both global variable as well as my.cnf file and restarted mysql server.

Still problem persists and getting the same error.

Please help me out resolving this.

Nikesh Kedlaya
  • 1
  • 1
    Possible duplicate of [Disable ONLY\_FULL\_GROUP\_BY](https://stackoverflow.com/questions/23921117/disable-only-full-group-by) – A J Apr 09 '19 at 05:25
  • Consider to fix your queries instead of disabling `only_full_group_by`. – Paul Spiegel Apr 09 '19 at 07:13

0 Answers0