Skip to content

#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by


I had a struggle getting this to work i’ve tested it and it’s working on lamp server mysql version 5.12

So, steps to success:

  1. sudo vim /etc/mysql/conf.d/mysql.cnf
  2. Scroll to the bottom of file Copy and paste


to the bottom of the file

  1. save and exit input mode
  2. sudo service mysql restart to restart MySQL.


Posted in mysql. Tagged with , , .