Welcome Guest, Not a member yet? Register   Sign In
query problem
#9

(This post was last modified: 07-04-2019, 08:21 AM by neuron.)

[quote pid='365734' dateline='1562061900']
here's the error


Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_codeignite.fb_usr.id_fb_us' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

[/quote]
 as error says you need to disable only_full_group_by

https://stackoverflow.com/questions/2392...l-group-by
I faced the same error, fixed it by disabling only_full_group_by mode. 
Disabling should not break your existing queries, in my case I did not face any problems.
Reply


Messages In This Thread
query problem - by midav - 07-02-2019, 03:05 AM
RE: query problem - by hc-innov - 07-02-2019, 05:37 AM
RE: query problem - by midav - 07-02-2019, 07:12 AM
RE: query problem - by php_rocs - 07-02-2019, 08:01 AM
RE: query problem - by midav - 07-02-2019, 08:22 AM
RE: query problem - by php_rocs - 07-02-2019, 10:04 AM
RE: query problem - by midav - 07-04-2019, 05:48 AM
RE: query problem - by midav - 07-04-2019, 05:52 AM
RE: query problem - by hc-innov - 07-04-2019, 08:59 AM
RE: query problem - by neuron - 07-04-2019, 08:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB