<< Back
Message for this thread
Posted by Messages text
Hawthorne Lantz

Noavatar
Total post : 12
> Profile
Written on : 27/06/2011 22:55 ( more than one month )
Object : Cannot delete course (not visible in admin)
Hi,
I'm not sure how I managed it, but courses I meant to delete aren't appearing in the admin area under the catagories section, but still appear in the catalog when a user logs in. Where can I find and delete these courses that are still in the catalog but not under any of my categories or at the top level?

Thanks,
Lantz 
 
Brown Joseph

Noavatar
Total post : 11
> Profile
Written on : 15/08/2011 19:42 ( more than one month )
Object : Re: Cannot delete course (not visible in admin)
I know this post is old, but maybe this will help someone else out. It sounds like the category that housed the courses somehow was modified or deleted.

If you have a Database Admin with modify access, you can try this. Simply have them change the 'idCategory' number from the Course back to the root category listing (0). Then delete the course after it reappears in the course category inside Docebo. This method has worked for me before, Queries would look similair to this:

--Find the idCourse to modify - look at the idCourse (YOURCOURSENUMBER) in relation to the code or name of the course you want to update:
SELECT idCourse, idCategory, code, name FROM 'YOURDOCEBODB'.'learning_course';

--Update the Course to the root idCategory:
UPDATE 'YOURDOCEBODB'.'learning_course' SET 'idCategory'=0 WHERE 'idCourse'=YOURCOURSENUMBER LIMIT 1;

The course should now be in the root or 'top level' category in your admin course categories menu and you can delete it there. Be extremely careful when modifying the db and do a backup before you start.
 
<< Back