Search the Community
Showing results for tags 'full_group'.
Found 1 result
Hi all, I am getting the following error : Uncaught mysqli_sql_exception: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AO.co.country_name'; this is incompatible with sql_mode=only_full_group_by in Googling showed that this is because of sql_mode in the new version. I would like to ask if I should reset the sql_mode or make changes to the query? Which would be the right thing to do? Here is the current sql_mode If I was to go setting the sql_mode for compatibility way, then should I just remove the ONLY_FULL_GROUP_BY from the set of values above to get this working? Where (in the program) should I make the change to sql_mode ? At the time of creating a connection to the database? Is there another better way to set it ? Thanks all !