Server Upgrade

[kingsway]

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

[max]

Hi Tim,
I already answered to your e-mail

[canelli]

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