The Elearning Community

Hi we have upgraded our server to run CentOS7 and we now get this error message whenever you try to click into the course documents of any student : Here's the message : Expression #1 of ORDER BY clause is not in SELECT list, references column 'kengonl_dbase.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 = '20')) ORDER BY learning_organization.path ]

Does anyone have any thoughts?
Thanks

Hi Tim,
I already answered to your e-mail

Hi Kingsway

the issue you faced out is related with the mysql or mariadb settings
I suppose you are using mysql 5.7 or greater.
you need to change the "sql_mode setting" in the my.cnf config or whatever in the mysql / maria configuration

check this posts:
viewtopic.php?f=10&t=13146&p=19982#p19984