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 ")
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 ")
You need to change the ONLY_FULL_GROUP_BY setting in MySQL 5.7 to fix this, on the server.
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.
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.
I only have access to the cpanel.
I don't know where this would be in cPanel, perhaps contact your hosting company
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.
Pay attention to the values delimiter which is comma.
Thank you. I will give that a try this afternoon. Greatly appreciate your help. I will keep you posted.
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.
