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