Server Upgrade

Install and configure FormaLMS and DoceboCE
Post Reply
Posts: 13
Joined: Tue May 19, 2015 4:41 pm
Version: forma.lms 1.4

Server Upgrade

Post by 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?

User avatar
FormaLms Guru
Posts: 2448
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4

Re: Server Upgrade

Post by max »

Hi Tim,
I already answered to your e-mail
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management[at]
Skype: m_ferrari_it

User avatar
FormaLms Guru
Posts: 492
Joined: Thu Nov 08, 2012 12:21 pm
Version: forma.lms 2.0

Re: Server Upgrade

Post by 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:
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology

Post Reply