| query problem |
|
[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. |
| 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
|
