Page History

MySQL changed the default behavior in version 5.7.5 to enable "only_full_group_by". If you are using a version newer than that, or if you had changed your MySQL configuration file to enable "only_full_group_by", you will need to remove it. You should update your MySQL configuration file to disable "sql_mode", i.e., don't have it set to "only_full_group_by". You can run the following query to determine what the sql_mode is: SELECT @@GLOBAL.sql_mode, @@SESSION.sql_mode;