How can I disable this online_Full_group_by

Community Support General Questions
22

Yes it still doesn’t work.

A Database Error Occurred

Error Number: 1055

Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘yunus_web.cp.artia7.online.p.row_order’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `b`.`id` as `brand_id`, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`, `b`.`image` as `brand_img`, `b`.`status` as `brand_status` FROM `brands` `b` LEFT JOIN `products` `p` ON `p`.`brand` = `b`.`name` WHERE ( `b`.`status` = ‘1’ OR b.name = p.brand ) GROUP BY `b`.`id` ORDER BY `row_order` ASC LIMIT 12

Filename: models/Brand_model.php

Line Number: 56

23

I tried to delete it here, but it still won’t delete it.

Server variables and settings.PNG
Server variables and settings.PNG1352×711 161 KB

24 
grep -Ri ONLY_FULL_GROUP_BY /etc/mysql/
25

Yes, when I do this command: grep -Ri ONLY_FULL_GROUP_BY /etc/mysql/

It just shows me.

root@cp:~# grep -Ri ONLY_FULL_GROUP_BY /etc/mysql/
root@cp:~#

26

Then I don’t know where it is activated.

27

That’s okay, you did a great job solving my problem. We will find a solution to it in no time.

1 Like