SELECT list is not in GROUP BY clause and contains nonaggregated column

Below method solved my problem:

In ubuntu

Type: sudo vi /etc/mysql/my.cnf

type A to enter insert mode

In the last line paste below two line code:


Type esc to exit input mode

Type :wq to save and close vim.

Type sudo service mysql restart to restart MySQL.

Leave a Comment

Pin It on Pinterest

Share This
Open chat