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

mod_assign: upgrade: Fix graded group submissions

    XMLWordPrintable

Details

    • 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

    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

              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

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

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