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
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
Concrete5 5759