[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;
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.