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

Assignment Upgrade Helper causes duplication in the gradebook

XMLWordPrintable

    • MOODLE_23_STABLE
    • MOODLE_23_STABLE
    • Hide

      If anyone needs some SQL to fix their install it would be possible (delete the second grade item from the database).

      Show
      If anyone needs some SQL to fix their install it would be possible (delete the second grade item from the database).
    • Hide

      Steps to reproduce:

      1. Ensure both assignment versions are enabled and visible via site admin
      2. Create brand new empty course with some students
      3. Create 2 x v2.2 assignments of any type
      4. I added at least one grade for each assignment
      5. Run the Assignment Upgrade Helper. The two assignments you just created should be listed. Click 'Upgrade all'.
      6. Go to the course and verify that the assignments have been upgraded.
      7. Go to the course gradebook and see how many assignments appear for the course.

      Expected result.

      1. There should be 2 assignments in the gradebook
        Actual result
      2. There are 4 assignments in the gradebook
      Show
      Steps to reproduce: Ensure both assignment versions are enabled and visible via site admin Create brand new empty course with some students Create 2 x v2.2 assignments of any type I added at least one grade for each assignment Run the Assignment Upgrade Helper. The two assignments you just created should be listed. Click 'Upgrade all'. Go to the course and verify that the assignments have been upgraded. Go to the course gradebook and see how many assignments appear for the course. Expected result. There should be 2 assignments in the gradebook Actual result There are 4 assignments in the gradebook

      Running the 'Assignment Upgrade Helper' to convert v2.2 assignments to v2.3 assignments causes the assignments to duplicate in the gradebook.

      The above is a simple test, but it did massive damage to a test upgrade of 24,000 assignments, including overstamping 'category' records with itemmodule='assign'.

        1. categories_getting_overwritten.png
          categories_getting_overwritten.png
          100 kB
        2. Categories and Items view of gradebook after the assignment upgrade.jpg
          Categories and Items view of gradebook after the assignment upgrade.jpg
          49 kB
        3. mdl_grade_items AFTER assignment upgraade.jpg
          mdl_grade_items AFTER assignment upgraade.jpg
          34 kB
        4. mdl_grade_items BEFORE assignment upgrade.jpg
          mdl_grade_items BEFORE assignment upgrade.jpg
          23 kB

            damyon Damyon Wiese
            mcwoods Michael Woods
            Ankit Agarwal Ankit Agarwal
            Dan Poltawski Dan Poltawski
            Frédéric Massart Frédéric Massart
            Votes:
            19 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved:

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