Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-52501

mod_assign: upgrade: Fix graded group submissions

XMLWordPrintable

    • MOODLE_28_STABLE, MOODLE_29_STABLE, MOODLE_30_STABLE, MOODLE_32_STABLE
    • MOODLE_32_STABLE, MOODLE_33_STABLE
    • Hide

      Remove duplicated submission record by running this query:

      SELECT g.assignment, g.userid, count(*)
      		 
          FROM mdl_assign_grades g
      		 
          LEFT JOIN mdl_assign_submission s
      		 
          ON s.assignment = g.assignment
      		 
          AND s.userid = g.userid
      		 
          WHERE s.id IS NULL group by g.assignment, g.userid having count(*) > 1;

      Show
      Remove duplicated submission record by running this query: SELECT g.assignment, g.userid, count (*) FROM mdl_assign_grades g LEFT JOIN mdl_assign_submission s ON s.assignment = g.assignment AND s.userid = g.userid WHERE s.id IS NULL group by g.assignment, g.userid having count (*) > 1;
    • Hide

      Talk to Damyon

      Show
      Talk to Damyon

      I haven't been able to determine the cause of how a delete student had two grades for an assignment but not associated a submission record.

      In the upgrade to Moodle 2.8 or above, the assignment creates the submission record which is missing group submissions that have been graded for who didn't submit the assignment in the group.

      The assignment in question was configured to have Attempts reopened - manual and submission in groups.

      The upgrade script needs to be fixed to only add a submission record per assignment / user.

      Backups created from assignments that are affected by this bug in Moodle versions below 2.8 will cause a similar error during restore if user data is included.

            nmagill Neill Magill
            tlock Tim Lock
            Damyon Wiese Damyon Wiese
            David Monllaó David Monllaó
            Marina Glancy Marina Glancy
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.