mysql-error-1055 – Tarik Billa

Error Code: 1055 incompatible with sql_mode=only_full_group_by

September 4, 2023 by Tarik

In 5.7 the sqlmode is set by default to: ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION To remove the clause ONLY_FULL_GROUP_BY you can do this: SET sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”)); This supposed you need to make that GROUP BY with non aggregated columns. Regards

SELECT list is not in GROUP BY clause and contains nonaggregated column [duplicate]

July 20, 2023 by Tarik

As @Brian Riley already said you should either remove 1 column in your select select countrylanguage.language ,sum(country.population*countrylanguage.percentage/100) from countrylanguage join country on countrylanguage.countrycode = country.code group by countrylanguage.language order by sum(country.population*countrylanguage.percentage) desc ; or add it to your grouping select countrylanguage.language, country.code, sum(country.population*countrylanguage.percentage/100) from countrylanguage join country on countrylanguage.countrycode = country.code group by countrylanguage.language, country.code … Read more

#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

February 18, 2023 by Tarik

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: sudo vim /etc/mysql/conf.d/mysql.cnf Scroll to the bottom of file Copy and paste [mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION to the bottom of the file save and exit input mode sudo service mysql restart to restart … Read more