Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause. Error in Maria DB
Correct answer for:
Ubuntu 18
MariaDB
[SOLUTION / FIX ]
Answer:
Edit file /etc/mysql/my.cnf
sudo nano /etc/mysql/my.cnf
and remove ONLY_FULL_GROUP_BY
Source:
https://discuss.phplist.org/t/database-error-1140-in-dashboard-and-1055-in-statistics/6497
Keywords:
Ubuntu 18
MariaDB
Mixing of Groups
Please write in comments if this solved / fixed your problem to help others.
