sql error when entering a course

Install and configure FormaLMS and DoceboCE
Post Reply
mwyres
Newbie
Posts: 1
Joined: Wed Jul 22, 2020 2:42 am

sql error when entering a course

Post by mwyres »

New to Forma LMS, so not sure what is happening here.

Whenever I create a new course, and attempt to click on that new course, I get the following:

Expression #1 of ORDER BY clause is not in SELECT list, references column 'formalms_dev.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 = '3')) ORDER BY learning_organization.path ]

Any ideas what is going on here?
alfa24
Senior Boarder
Posts: 1982
Joined: Fri Nov 24, 2017 8:45 am

Re: sql error when entering a course

Post by alfa24 »

Per supporto GRATUITO contattatemi in privato qui
Post Reply