SQL_MODE not working on MySQL 5.7.18


I'm getting the following error from my PHP application:


Incorrect SQL query (Database) In aggregated query without GROUP BY expression #1 of SELECT list contains nonaggregated column 'db_20172201.cm_order.buyer'; this is incompatible with sql_mode=only_full_group_by


After looking around for a while and after trying to identify the query that gave this error I decided that I should change the SQL_MODE option in my MySQL server.

I did 2 things to accomplish this:

  • executed this query