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
SET SESSION sql_mode = 'STRICT_TRANS_TABLES