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] 

$ sudo service mysql restart