This was working till 2 days back. The only thing changed was i had restarted the server and then it started showing error. I have checked again.

Thanks

Hey sorry it put the only_full_by again by itself. I have disabled it now.

You can disable the MySQL mode permanently by adding to your config file so that the restart won’t enable them back.

# Get modes
SELECT @@sql_mode;

# Disable ONLY_FULL_GROUP_BY
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

# Disable NO_ZERO_DATE & NO_ZERO_IN_DATE
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE',''));
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'NO_ZERO_IN_DATE',''));

Permanently changing SQL mode

First, you can find out which configuration file our MySQL installation prefers.

mysql --verbose --help | grep -A 1 "Default options"

will result in something like this

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf 

You can copy result of SELECT @@sql_mode; to your my.ini file and remove the modes you want to disable.

[mysqld]
# ... other stuff will probably be here
sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Save, exit, and restart MySQL sudo service mysql restart