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

mod_assign: upgrade: Fix graded group submissions

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      Talk to Damyon

      Show
      Talk to Damyon
    • Workaround:
      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;
    • Affected Branches:
      MOODLE_28_STABLE, MOODLE_29_STABLE, MOODLE_30_STABLE, MOODLE_32_STABLE
    • Fixed Branches:
      MOODLE_32_STABLE, MOODLE_33_STABLE
    • Pull from Repository:
    • Pull Master Branch:

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  15/May/17