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. |