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

 xpression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

In Ubuntu

Step 1:

# nano /etc/mysql/mysql.conf.d/mysqld.cnf

Step 2: Go to last line and add the following

sql_mode = ""

Step 3: Save

ctrl+x -> Y

Step 4: Restart mysql server.

# /etc/init.d/mysql restart