View Single Post
  #3  
Old 26 Apr 2021, 02:41
svoeric svoeric is offline
 
Join Date: May 2008
grabbed this query, It's a ton of help, but the group by statements are causing some issues... if I remove the group by, it works.



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.



any thoughts on this ?

get this when I run With the group-by in.
failed : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DB_bb.node.iconid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Reply With Quote