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


    SET SESSION sql_mode = 'STRICT_TRANS_TABLES