View Single Post
  #72  
Old 29th September 2017, 17:31
z3ro z3ro is offline
Senior Member
 
Join Date: Oct 2010
P2P
Posts: 121
Default re
Quote:
Originally Posted by cobra View Post
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
Not understand.
What is the problem?

For me working.
Attached Thumbnails
1.png  
Reply With Quote