Quote:
Originally Posted by cobra
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