Concrete5 MySQL query issue

Hi I'm getting following SQL error at Concrete5 ( CMS, just to give you the background we've recently updated MySQL from 5.6 yo 5.7 and this has started to happen. Any fix would be highly appreciated. I've already tried repairing database but it didn't work

mysqlt error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'scotnew_c5.u.uDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT u.uID, u.uName FROM Users u left join UserSearchIndexAttributes on (UserSearchIndexAttributes.uID = u.uID) where 1=1 order by uDateAdded desc limit 0,10 ")

View Replies:
hutman replied on at Permalink Reply
for mysql 5.7 - the sql_mode needs to be set in the /etc/mysql/mysql.conf.d/mysqld.cnf

shahzaib replied on at Permalink Reply
Thanks mate, aprreciated