HOW TO SOLVE MYSQL GROUP BY ISSUE ?

HOW TO SOLVE MYSQL GROUP BY ISSUE ?

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

->group_by('b.product_info_id')
->group_by('c.product_title_id')
->group_by('e.id')