View Single Post
  #70  
Old 28th September 2017, 17:31
cobra cobra is offline
Member
 
Join Date: Aug 2012
P2P
Posts: 9
Default index error
Hi,

please help!Thanks!

Index error.

Please try again later or contact an Administrator.
(1055) Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxxxx.s.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT m.memberid, m.membername, m.gender, m.visible, profile.custom_title, profile.country, g.groupname, g.groupstyle, s.date FROM tsue_members m INNER JOIN tsue_member_profile profile USING(memberid) INNER JOIN tsue_membergroups g USING(membergroupid) INNER JOIN tsue_session s ON (m.memberid=s.memberid) WHERE m.membergroupid IN (5,6,7,11) GROUP BY m.memberid ORDER BY g.sort ASC, m.lastactivity DESC

Last edited by cobra; 28th September 2017 at 17:52.
Reply With Quote