All users being added to Course Creator upon login

All users being added to Course Creator upon login

by Jim Rollo -
Number of replies: 8
2 days ago, all users start to be automagically adding anyone who logs in to the course creator role. I'm sure this must be a config issue somewhere, I have yet to find it. Any suggestions?
Average of ratings: -
In reply to Jim Rollo

Re: All users being added to Course Creator upon login

by Helen Foster -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators
Hi Jim,

Please check that the default role for all users in Administration > Users > Permissions > User policies is set to authenticated user.
In reply to Helen Foster

Re: All users being added to Course Creator upon login

by Jim Rollo -
Hi Helen,

Thanks for responding. The default role for all users in Administration > Users > Permissions > User policies is indeed set to authenticated user.

Jim
In reply to Jim Rollo

Re: All users being added to Course Creator upon login

by Jim Rollo -
hmmmm, getting desperate. On a lark, I ran the unit tests and is this bad?

Fail: lib/simpletest/slowtestcode.php / slow_code_test / test_php_syntax /
Cannot test PHP syntax because PHP is not on the path. at [/opt/lampp/htdocs/moodle/lib/simpletest/slowtestcode.php line 32]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
this one should fail too: Equal expectation fails because [Integer: 1] differs from [Integer: 0] by 1 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 180]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
two events should in queue: Equal expectation fails because [Integer: 2] differs from [String: 1] by 1 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 182]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
verify no event dispatched yet: Equal expectation fails because [Integer: 0] differs from [Integer: 1] by 1 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 183]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
this one should go to queue directly: Equal expectation fails because [Integer: 1] differs from [Integer: 0] by 1 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 185]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
three events should in queue: Equal expectation fails because [Integer: 3] differs from [String: 1] by 2 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 186]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
verify previous event was not dispatched: Equal expectation fails because [Integer: 0] differs from [Integer: 2] by 2 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 187]
Fail: lib/simpletest/testeventslib.php / eventslib_test / test__events_trigger__failed_instant /
all events should be dispatched: Equal expectation fails because [Integer: 3] differs from [Integer: 1] by 2 at [/opt/lampp/htdocs/moodle/lib/simpletest/testeventslib.php line 188]
22/22 test cases complete: 545 passes, 8 fails and 0 exceptions.

In reply to Jim Rollo

Re: All users being added to Course Creator upon login

by Jim Rollo -
Also ran a check on the tables, found plenty of index problems. All the role related tables are affected. Anyone if this could be a problem?

Problems with indexes of table `mdl_choice`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_choice_answers`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_choice_options`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_course_categories`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_course_display`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_course_modules`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_event`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_forum`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_forum_read`
More than one INDEX key was created for column `userid`
Problems with indexes of table `mdl_forum_subscriptions`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_grade_grades`
UNIQUE and INDEX keys should not both be set for column `userid`
Problems with indexes of table `mdl_grade_outcomes`
UNIQUE and INDEX keys should not both be set for column `courseid`
Problems with indexes of table `mdl_grade_outcomes_courses`
UNIQUE and INDEX keys should not both be set for column `courseid`
Problems with indexes of table `mdl_grade_settings`
UNIQUE and INDEX keys should not both be set for column `courseid`
Problems with indexes of table `mdl_modules`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_post`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_question_numerical_units`
UNIQUE and INDEX keys should not both be set for column `question`
Problems with indexes of table `mdl_resource`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_role`
UNIQUE and INDEX keys should not both be set for column `sortorder`
Problems with indexes of table `mdl_role_allow_assign`
UNIQUE and INDEX keys should not both be set for column `roleid`
Problems with indexes of table `mdl_role_allow_override`
UNIQUE and INDEX keys should not both be set for column `roleid`
Problems with indexes of table `mdl_role_assignments`
UNIQUE and INDEX keys should not both be set for column `contextid`
Problems with indexes of table `mdl_role_capabilities`
UNIQUE and INDEX keys should not both be set for column `roleid`
Problems with indexes of table `mdl_role_names`
UNIQUE and INDEX keys should not both be set for column `roleid`
Problems with indexes of table `mdl_role_sortorder`
UNIQUE and INDEX keys should not both be set for column `userid`
Problems with indexes of table `mdl_scorm`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_scorm_scoes`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_scorm_scoes_track`
More than one INDEX key was created for column `userid`
Problems with indexes of table `mdl_scorm_seq_mapinfo`
UNIQUE and INDEX keys should not both be set for column `scoid`
Problems with indexes of table `mdl_scorm_seq_objective`
UNIQUE and INDEX keys should not both be set for column `scoid`
Problems with indexes of table `mdl_scorm_seq_rolluprule`
UNIQUE and INDEX keys should not both be set for column `scoid`
Problems with indexes of table `mdl_scorm_seq_rolluprulecond`
UNIQUE and INDEX keys should not both be set for column `scoid`
Problems with indexes of table `mdl_scorm_seq_rulecond`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_scorm_seq_ruleconds`
UNIQUE and INDEX keys should not both be set for column `scoid`
Problems with indexes of table `mdl_survey_analysis`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_survey_answers`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_user_lastaccess`
UNIQUE and INDEX keys should not both be set for column `userid`
Problems with indexes of table `mdl_user_preferences`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `mdl_workshop_assessments`
More than one INDEX key was created for column `submissionid`
More than one INDEX key was created for column `userid`
Problems with indexes of table `mdl_workshop_submissions`
More than one INDEX key was created for column `userid`

In reply to Helen Foster

Re: All users being added to Course Creator upon login

by Jim Rollo -
Hi Helen,

I did some more playing with the setting you mentioned. Turns out regardless of what I set the user policy to, all users who log get arbitrarily place into the wrong role, (course creator, in this case).


In reply to Jim Rollo

Re: All users being added to Course Creator upon login

by Helen Foster -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators
Hi Jim,

You could also check the default role in your course settings and also the default front page role in Administration > Front Page > Front Page settings.
In reply to Helen Foster

Re: All users being added to Course Creator upon login

by Jim Rollo -
I did check that too. Turns out the only fix was to delete every system role and re-create them. then the user magically stopped getting assigned to system roles upon login regardless of the settings. My gut thinking is there was a corrupt table causing voodoo.
In reply to Jim Rollo

Re: All users being added to Course Creator upon login

by Alick Brown -
I have exactly the same problem... when anyone logs in they are automatically given system-wide 'course creator' role.
We use ldap authentication, and this problem only happens with staff not with students logging in.
Just wondered if anyone had any other ideas for fixing the bug?

Thanks,
Alick