Server Upgrade

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

Server Upgrade

Post by kingsway » Fri Feb 08, 2019 6:08 pm

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

User avatar
max
FormaLms Guru
Posts: 1871
Joined: Thu Mar 01, 2012 10:41 am

Re: Server Upgrade

Post by max » Fri Feb 08, 2019 6:45 pm

Hi Tim,
I already answered to your e-mail
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
http://www.elearnit.net
http://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
http://elearnit.wordpress.com
Skype: m_ferrari_it

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

Re: Server Upgrade

Post by canelli » Sat Feb 09, 2019 11:30 am

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

http://www.joint-tech.com
---------------

Post Reply