MySql error on /index.php/dashboard/users/search page for non Admin users.

Permalink
Error occurred if user non Admin will go to /index.php/dashboard/users/search page. For Admin user no have any errors.

Error message:
An exception occurred while executing 'SELECT distinct (u.uID) FROM Users u LEFT JOIN UserSearchIndexAttributes ua ON u.uID = ua.uID LEFT JOIN UserGroups ugRequired ON ugRequired.uID = u.uID WHERE (ugRequired.gID in (-1,3)) OR (ugRequired.gID is null) ORDER BY u.uDateAdded desc LIMIT 10 OFFSET 0': SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'u.uDateAdded' which is not in SELECT list; this is incompatible with DISTINCT


Concrete5 Versions:
Core Version - 5.7.5.8
Version Installed - 5.7.5.8
Database Version - 20160412000000

kvt
View Replies:
dantheman replied on at Permalink Reply
dantheman
I have this exact same issue.

Concrete5 5759
dantheman replied on at Permalink Reply
dantheman
I have this exact same issue.

Concrete5 5759