Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.4
    • Fix Version/s: 2.4
    • Component/s: Enrolments
    • Labels:
      None
    • Testing Instructions:
      Hide

      1/ set up external database enrolment sync
      2/ create invalid enrolment records with following problems - invalid course id, missing user id, invalid user id
      3/ execute CLIsync with --verbose
      4/ verify the appropriate error messages are displayed for each invalid enrolment record (one problem report per record only)

      Show
      1/ set up external database enrolment sync 2/ create invalid enrolment records with following problems - invalid course id, missing user id, invalid user id 3/ execute CLIsync with --verbose 4/ verify the appropriate error messages are displayed for each invalid enrolment record (one problem report per record only)
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w38_MDL-35331_m24_verboseenroldb

      Description

      Hi there,

      I noticed that when we went with 2.2.4+, the notification of courses with no enrolments do not show up in the list as we had when we had 1.9.14+.

      In 2.2.4+, we saw that the list of courses only show up when there are enrolments assigned to them. In 1.9.14+ we had both (course that have enrolments and course that don't).

      We prefer the 1.9.14+ info instead ... more detailed and all in one run

      We want to know :

      1. Which courses have synchronized users
      2. Which courses do not exist in moodle that are in our db enrolment datastore
      3. which user accounts are sync with existing moodle users already in moodle
      4. which new user accounts are created during the sync which were not already in moodle.

      The 1.9.14+ tells us all this ... not the 2.2.x version.

      2.2.4+ EXAMPLES:

      Courses WITH NO enrolments attached to courses:
      ----------

      Course synchronisation skipped.
      Starting user enrolment synchronisation...
      ...user enrolment synchronisation finished.

      Course WITH enrolments attached to courses:
      ----------

      Course synchronisation skipped.
      Starting user enrolment synchronisation...
      enrolling: 60124 ==> HOSP 3999: Advanced Sales Skills & Management (Fall 2012) as student
      enrolling: 60123 ==> HOSP 3243: Advanced Sales Skills & Management (WINTER 2010) as student
      enrolling: 60124 ==> HOSP3102 - Fall 2012 as student
      enrolling: 60123 ==> HOSP3102 - Fall 2012 as student
      enrolling: 8189 ==> HOSP 4151 as student
      enrolling: 60124 ==> HOSP 4151 as student
      enrolling: 60123 ==> HOSP 4151 as student
      enrolling: 60123 ==> HOSP 3222 as student
      enrolling: 8189 ==> HOSP 3222 as student
      enrolling: 60124 ==> HOSP 3222 as student
      enrolling: 42514 ==> HOSP 1206 as student
      enrolling: 42514 ==> HOSP 1212 as student
      enrolling: 60126 ==> HOSP1101 as student
      enrolling: 60151 ==> HOSP1101 as student
      enrolling: 60142 ==> HOSP1101 as student
      enrolling: 60126 ==> HOSP 1104 as student
      enrolling: 60151 ==> HOSP 1104 as student
      enrolling: 60142 ==> HOSP 1104 as student
      enrolling: 60126 ==> HOSP 1106 as student
      enrolling: 60261 ==> HOSP 1106 as student
      enrolling: 60151 ==> HOSP 1106 as student
      enrolling: 60142 ==> HOSP 1106 as student
      enrolling: 45196 ==> HOSP 1107 as student
      enrolling: 60151 ==> HOSP 1107 as student
      enrolling: 25468 ==> HOSP 1107 as student
      enrolling: 60142 ==> HOSP 1107 as student
      enrolling: 60126 ==> HOSP 1107 as student
      enrolling: 60261 ==> HOSP 1107 as student
      enrolling: 60126 ==> HOSP 1103 as student
      enrolling: 60151 ==> HOSP 1103 as student
      enrolling: 60142 ==> HOSP 1103 as student
      enrolling: 3866 ==> HOSP 4260 [Kelleher] as student
      enrolling: 3866 ==> HOSP4263_EXCO as student
      enrolling: 3866 ==> HOSP 4264 as student
      enrolling: 3866 ==> HOSP 4153 as student
      enrolling: 54266 ==> PHYS 3001 (70197) as student
      enrolling: 17789 ==> PHYS 3001 (70197) as student
      enrolling: 39862 ==> PHYS 3001 (70197) as student
      enrolling: 15279 ==> PHYS 3001 (70197) as student
      enrolling: 54402 ==> PHYS 3001 (70197) as student
      enrolling: 4151 ==> PHYS 3001 (70197) as student
      enrolling: 55327 ==> PHYS 3001 (70197) as student
      ...user enrolment synchronisation finished.

      ----------
      1.9.14+ EXAMPLES (Preferred as it shows all activity):
      ----------

      === Syncing enrolments for role: admin ===
      === Syncing enrolments for role: coursemgr ===
      === Syncing enrolments for role: editingteacher ===
      === Syncing enrolments for role: teacher ===
      === Syncing enrolments for role: student ===
      Course 20127070153 does not exist, skipping
      Course 20127070154 does not exist, skipping
      Course 20127070197 does not exist, skipping
      Course 20127070203 does not exist, skipping
      Course 20127071039 does not exist, skipping
      Course 20127073587 does not exist, skipping
      Course 20127073588 does not exist, skipping
      Course 20127073597 does not exist, skipping
      Course 20127074155 does not exist, skipping
      Course 20127074156 does not exist, skipping
      Course 20127074157 does not exist, skipping
      Course 20127074158 does not exist, skipping
      Course 20127074159 does not exist, skipping
      Course 20127074160 does not exist, skipping
      Course 20127074178 does not exist, skipping
      Course 20127074179 does not exist, skipping
      Course 20127074180 does not exist, skipping
      Assigned role student to user 42514 in course 309 (HOSP1206 )
      Assigned role student to user 42514 in course 307 (HOSP1212)
      Course 20127074187 does not exist, skipping
      Course 20127074188 does not exist, skipping
      Course 20127074189 does not exist, skipping
      Course 20127074190 does not exist, skipping
      Course 20127074191 does not exist, skipping
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      Assigned role student to user 59875 in course 292 (HOSP1101)
      Assigned role student to user 59866 in course 292 (HOSP1101)
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      Assigned role student to user 59875 in course 315 (HOSP1104)
      Assigned role student to user 59866 in course 315 (HOSP1104)
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      Assigned role student to user 59875 in course 2490 (HOSP1106 )
      Assigned role student to user 59866 in course 2490 (HOSP1106 )
      Assigned role student to user 45196 in course 2491 (HOSP1107 )
      Assigned role student to user 59875 in course 2491 (HOSP1107 )
      Assigned role student to user 25468 in course 2491 (HOSP1107 )
      Assigned role student to user 59866 in course 2491 (HOSP1107 )
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      PHP Notice: weird! no user record entry? in /var/www/html/moodle/enrol/database/enrol.php on line 345
      Assigned role student to user 59875 in course 293 (HOSP1103 )
      Assigned role student to user 59866 in course 293 (HOSP1103 )
      Course 20127074197 does not exist, skipping
      Course 20127074202 does not exist, skipping
      Course 20127074203 does not exist, skipping
      Course 20127074204 does not exist, skipping
      Course 20127074205 does not exist, skipping
      Course 20127074206 does not exist, skipping
      Course 20127074213 does not exist, skipping
      Course 20127074214 does not exist, skipping
      Course 20127074215 does not exist, skipping
      Course 20127074216 does not exist, skipping
      Course 20127074217 does not exist, skipping
      Course 20127074218 does not exist, skipping
      Course 20127074236 does not exist, skipping
      Course 20127074237 does not exist, skipping
      Course 20127074238 does not exist, skipping
      Course 20127074239 does not exist, skipping
      Course 20127074240 does not exist, skipping
      Course 20127074241 does not exist, skipping
      Course 20127074338 does not exist, skipping
      Course 20127074770 does not exist, skipping
      Course 20127074772 does not exist, skipping
      Course 20127074773 does not exist, skipping
      Course 20127074774 does not exist, skipping
      Course 20127074775 does not exist, skipping
      Course 20127074776 does not exist, skipping
      Course 20127074777 does not exist, skipping
      Course 20127074778 does not exist, skipping
      Course 20127074779 does not exist, skipping
      Course 20127074780 does not exist, skipping
      Course 20127074781 does not exist, skipping
      Course 20127074785 does not exist, skipping
      Course 20127074786 does not exist, skipping
      === Syncing enrolments for role: guest ===
      === Syncing enrolments for role: user ===
      === Syncing enrolments for role: course_administrator ===
      === Syncing enrolments for role: admin2 ===
      === Syncing enrolments for role: ots_teacher ===
      === Syncing enrolments for role: guest2 ===
      === Syncing enrolments for role: mentor ===
      === Syncing enrolments for role: ace-it ===
      === Syncing enrolments for role: question_sharer ===
      === Syncing enrolments for role: editingteacher_1 ===
      === Syncing enrolments for role: courseidnumbereditorgroup ===
      === Syncing enrolments for role: fprc_member ===

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  3/Dec/12