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

Your email address will not be published. Required fields are marked *

Open chat