MySQL - Issue with SELECT & GROUP BY [SOLVED]

MySQL - Issue with SELECT & GROUP BY [SOLVED]

creatiko
Newbie
Posts: 2
Threads: 0
Joined: Mar 2020
Reputation: 0

03-19-2020, 02:37 PM

(11-29-2018, 01:28 PM)Ettore Wrote: Don't know if useful, but for a quick fix I found this hint:
https://simplerisk.freshdesk.com/support...6000164283

PHP Code:
$this->db->query("SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));")

This is the answer that helped me!

Messages In This Thread

MySQL - Issue with SELECT & GROUP BY [SOLVED] - by Coool6 - 11-29-2018, 06:05 AM

RE: MySQL - Issue with SELECT & GROUP BY - by Pertti - 11-29-2018, 06:49 AM

RE: MySQL - Issue with SELECT & GROUP BY - by Coool6 - 11-29-2018, 07:22 AM

RE: MySQL - Issue with SELECT & GROUP BY - by Pertti - 11-29-2018, 07:29 AM

RE: MySQL - Issue with SELECT & GROUP BY - by Coool6 - 11-29-2018, 07:47 AM

RE: MySQL - Issue with SELECT & GROUP BY - by Pertti - 11-29-2018, 08:29 AM

RE: MySQL - Issue with SELECT & GROUP BY [SOLVED] - by Ettore - 11-29-2018, 01:28 PM

RE: MySQL - Issue with SELECT & GROUP BY [SOLVED] - by creatiko - 03-19-2020, 02:37 PM

RE: MySQL - Issue with SELECT & GROUP BY [SOLVED] - by inumaru - 06-07-2021, 08:32 PM