Cant manage users

Permalink
Need detailed help on how to correct an error I am receiving when I try clinking Search Users in the dashboard. I am currently on version 5.6.3.5. It says there are no updates. I am not familiar with sql but I am the only one with access. So detailed help would be greatly appreciated. This is the first time I am running into issues with Concrete5. I update to sites and I was not the one who installed it, he no longer works here, I just maintain it. This is the error message I receive.

mysqli error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'intranet_concrete.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
hutman
You need to change the ONLY_FULL_GROUP_BY setting in MySQL 5.7 to fix this, on the server.
johnelenco replied on at Permalink Reply
Hi Hutman,

Thank you very much for the reply. I am new to all of this. Where and how do I do this. I apologize for my lack of knowledge.
johnelenco replied on at Permalink Reply
I only have access to the cpanel.
hutman replied on at Permalink Reply
hutman
I don't know where this would be in cPanel, perhaps contact your hosting company
cristi78 replied on at Permalink Reply
If you have access to phpMyAdmin in cPanel, go there and in the Variables menu search for "sql mode", click edit,delete ONLY_FULL_GROUP_BY and then click save.
Pay attention to the values delimiter which is comma.
johnelenco replied on at Permalink Reply
Thank you. I will give that a try this afternoon. Greatly appreciate your help. I will keep you posted.
johnelenco replied on at Permalink Reply
I tried making the changes and once I clicked save, I found out quickly I don't have permission. I am migrating all my sites away from this hosting company and these designers. I would like to regain control om my sites. I am hoping the problem self corrects once I do, if not I will try following the instructions once again. Greatly appreciate all your help. My apologies in the delayed response.