Best practice forum (Archived)
This forum discussion has been removed
I'm not sure where you are going wrong here Liz. If I set up competencies, link them to courses, link the competencies to an organisation, set the plan template to automatically include by org and include linked courses.
Then create a dynamic audience based on organisation, save the rules, check the audience member list then go to the Learning Plan tab of the Audience and click Create Plans, then the learning plans are generated for all the members of the audience, with the appropriate competencies and courses already included.
The error message you are getting is also very very strange - prioritymode has been a field in the mdl_dp_course_settings table since the very first release of Totara 1.0 back in 2010. Could you tell me what fields exist in that table, and what records are in it?
Not dp_component_settings, dp_course_settings :-)
Unless of course dp_course_settings is missing, which would explain why you are having problems!
If it is there, it should have columns id, templateid, duedatemode, prioritymode and priorityscale. None of them should be NULL, and prioritymode I think is usually 0. There should be one record for each Learning Plan Template you have (usually just the one).
Aha! In Template IDs 4 and 5 the course component is disabled, and in Template 6 the competency component is disabled. In Manage Templates, Components tab, use the eye icon to turn courses or competencies on.
So if you were trying to autogenerate learning plans using one of those templates pulling in courses and competencies, but either of those components is disabled, Stuff will probably go wrong.
Does that help?