Как убрать ошибку MYSQL Syntax error or access violation: 1055 Expression #1 of ORDER BY

Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

Очень просто, добавляем в my.cnf строку:

sql-mode=""

И делаем service mysql restart