I got mysql error when executing a command
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Solution to fix :
- Login to your server as root
- Open your mysql configuration file (for me its /etc/mysql/mysql.conf.d/mysqld.cnf)
- Add the following code after [mysqld] block
[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
- Restart mysql service ( systemctl restart mysql )
Issue fixed
No comments:
Post a Comment