• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
query problem

#9
[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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.