Как убрать ошибку 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