This is incompatible with sql_mode=only_full_group_by – MySQL

Your MySQL is enabled ONLY_FULL_GROUP_BY mode, don’t worry you can disable it simply

There are two solutions to disable it:

Remove ONLY_FULL_GROUP_BY from MySQL console

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Remove ONLY_FULL_GROUP_BY from phpmyadmin

  • Open phpmyadmin & select localhost
  • Click on menu Variables & scroll down for sql mode
  • Click on the edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.




Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.
Harinder Singh

Harinder Singh

My name is Harinder Singh and I specialize in Software industry. I consider myself as a life learner. I love learning new concepts, embracing new ideas and reading and searching for innovation.