Cannot Access LMS / Courses in 2.3
Posted: Thu Oct 17, 2019 9:41 am
When I tried to access LMS in 2.3 (from the admin page), the following error:
Expression #1 of ORDER BY clause is not in SELECT list, references column 'form960.learning_organization.path' which is not in SELECT list; this is incompatible with DISTINCT [ SELECT DISTINCT learning_organization.idOrg FROM learning_organization WHERE ((learning_organization.idParent = '0') AND (learning_organization.idCourse = '2')) ORDER BY learning_organization.path ]
Expression #1 of ORDER BY clause is not in SELECT list, references column 'form960.learning_organization.path' which is not in SELECT list; this is incompatible with DISTINCT [ SELECT DISTINCT learning_organization.idOrg FROM learning_organization WHERE ((learning_organization.idParent = '0') AND (learning_organization.idCourse = '2')) ORDER BY learning_organization.path ]