Tag Archives: [Err] 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
Solution:
1.mysql -uĀ  root -p login mysql
2.show variables like ‘%sql_mode%’;
3.setĀ global sql_mode=(select replace(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));
4.exit;
Restart Navicat and you will not get this error anymore.