If you face this kind of problem..Mysql Error 1055.. How to solve this
I solved this issue in two ways -
Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console
Answer: First access in your database with mysql root user. Then run the following query-
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Solution 2: Updating the Mysql query
Answer: To solve this issue permanently you have to update your query.
Update all group column by primary key of a table and Set multiple group by if there is any column which is not functionally dependent on columns in GROUP BY clause
Total votes: 1
Sharing is caring, show love and share the thread with your friends.