View Single Post
  #76  
Old 15th October 2018, 11:01
MrVon MrVon is offline
Member
 
Join Date: Oct 2018
Posts: 1
Default
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

1. Connect to the server using SSH .

2. Edit the /etc/mysql/my.cnf file using vi editor remove ONLY_FULL_GROUP_BY from sql-mode option under [mysqld] section in the file.

3. Restart MySQL service:
# service mysql restart
Reply With Quote