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

Import/Restore : Database error caused by course grade book settings

    Details

    • Testing Instructions:
      Hide
      1. Create 2 new courses source and destination for the importation
      2. In each course, go in the course grade settings and modify the "Grade display type" element to something different than the default. Click to save changes.
      3. In the source course, create an assignment activity.
      4. Process the importation from source course to destination course.
        You should see that the importation is successful and that the "Grade display type" of the destination course is the same as before (Before the patch you would see a database error)
      1. Create 2 new courses source and destination for another importation
      2. Do the same operations as before but without modifying the "Grade display type" of the destination course.
        You should see that the importation is successful and that the "Grade display type" of the destination course is the one from the source course
      Show
      Create 2 new courses source and destination for the importation In each course, go in the course grade settings and modify the "Grade display type" element to something different than the default. Click to save changes. In the source course, create an assignment activity. Process the importation from source course to destination course. You should see that the importation is successful and that the "Grade display type" of the destination course is the same as before (Before the patch you would see a database error) Create 2 new courses source and destination for another importation Do the same operations as before but without modifying the "Grade display type" of the destination course. You should see that the importation is successful and that the "Grade display type" of the destination course is the one from the source course
    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Pull Master Branch:
      MDL-37161-master

      Description

      A Database error is displayed when importating or restorating into a course if both source and destination have informations (Display type, Range decimal points...) in grade book settings.

      This error breaks the content of the targeted course :

      • Imported or restored activities and resources not visible but exists in course.
      • Grade book displays "error" message in users grades related to the activities imported/restored.

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  14/Jan/13