database error when using DISTINCT and ORDER BY

database error when using DISTINCT and ORDER BY

corey
Newbie
Posts: 5
Threads: 1
Joined: May 2017
Reputation: 0

05-05-2017, 03:15 AM

This select thing is working if i dont use order by but it shows error when order by is used with distinct or group by this error only shows when mysql is 5.7 they changed some stuff in it and i think codeigniter $this->distinct is not fixed for this type query in latest mysql version

Messages In This Thread

database error when using DISTINCT and ORDER BY - by corey - 05-04-2017, 11:36 PM

RE: database error when using DISTINCT and ORDER BY - by Rufnex - 05-05-2017, 01:42 AM

RE: database error when using DISTINCT and ORDER BY - by corey - 05-05-2017, 03:15 AM

RE: database error when using DISTINCT and ORDER BY - by corey - 05-05-2017, 10:06 PM

RE: database error when using DISTINCT and ORDER BY - by corey - 05-05-2017, 10:20 PM

RE: database error when using DISTINCT and ORDER BY - by Rufnex - 05-07-2017, 12:30 AM

RE: database error when using DISTINCT and ORDER BY - by corey - 05-09-2017, 08:35 PM

RE: database error when using DISTINCT and ORDER BY - by salain - 05-09-2017, 10:44 PM