Multiple Records in Role Assignment Table

Re: Multiple Records in Role Assignment Table

by Blair F. -
Number of replies: 0
Picture of Particularly helpful Moodlers

Hi, Séverin.

Here's my version info:

Version: 2.8.8+ (2014111008.06)
Release: 10.16.2015
PHP: 5.5.6
MySQL: 5.5.41

Regarding your other questions,

  • It's many students that have multiple records like this in the mdl_role_assignments table.
  • We use Manual, Self-Enrolment, Cohort-enrolment and auto-enrol from BANNER.  However, not all with the same students.  In this case and others that I'm looking at, the students were manually enrolled.
  • The BANNER autoenrol would insert into tables, but not in this students case, or others that I've checked.
  • I've only discovered it, as I was trying to do an SQL JOIN with mdl_logstore_standard_log and mdl_role_assignments, on userid and contextid, and receiving more records than I expected.

Thanks for your time.  Let me know if you have any other questions. 


Average of ratings: -