PHP - This is incompatible with sql_mode only_full_group_by not working

You are here

Some older PHP MySQL applications were developed on a version of Mysql that allow you to group in a certain way. The latest version of MYSQL and MariaDB don't turn this functionality on by default. To overcome this add the following to your my.cnf on ubuntu 18.04.

$ sudo vim /etc/mysql/mysql.cnf

// add the sql_mode string below [mysqld] 
[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

$ sudo service mysql restart