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

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

    XMLWordPrintable

Details

    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • MDL-37161-master
    • 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

    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.

      Attachments

        1. Grades_ Settings.png
          126 kB
          Jean-Philippe Gaudreau
        2. import_database_error.png
          75 kB
          Jean-Philippe Gaudreau

        Activity

          People

            gaudreaj Jean-Philippe Gaudreau
            gaudreaj Jean-Philippe Gaudreau
            Andrew Davis Andrew Davis
            Sam Hemelryk Sam Hemelryk
            Adrian Greeve Adrian Greeve
            Votes:
            4 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Clockify

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