View Single Post
  #73  
Old 29th September 2017, 19:19
cobra cobra is offline
Member
 
Join Date: Aug 2012
P2P
Posts: 9
Default
Quote:
Originally Posted by z3ro View Post
Not understand.
What is the problem?

For me working.
Hi,

I click on the main page I get this

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
Reply With Quote