Moodle
  1. Moodle
  2. MDL-30483

When restoring a course from a community hub, DDL sql error occurs

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.2
    • Fix Version/s: STABLE backlog
    • Component/s: Backup, Hub
    • Labels:
    • Affected Branches:
      MOODLE_22_STABLE
    • Rank:
      33167

      Description

      See MDLQA-1368.

      > This is failing at step 8: the restore process is aborted with following error message: "DDL sql execution error".

      > Incidentally, one gets the same message when trying to duplicate a resource or an activity (clicking on the x2 icon).

        Issue Links

          Activity

          Hide
          Jérôme Mouneyrac added a comment -

          I tested with the last course published on Mooch and it works
          Nicolas, what course did you pick up?

          Show
          Jérôme Mouneyrac added a comment - I tested with the last course published on Mooch and it works Nicolas, what course did you pick up?
          Hide
          Nicolas Martignoni added a comment -

          This one: "Enig'Math'TIC : un défi mathématique en ligne",
          see http://hub.moodle.org/?sesskey=FFohKM0aId&redirectcourseid=55

          Show
          Nicolas Martignoni added a comment - This one: "Enig'Math'TIC : un défi mathématique en ligne", see http://hub.moodle.org/?sesskey=FFohKM0aId&redirectcourseid=55
          Hide
          Nicolas Martignoni added a comment -

          Just tried with this course "iPads for Middle School Teachers", and still getting the same error, even as an admin and restoring in a new course.

          Show
          Nicolas Martignoni added a comment - Just tried with this course "iPads for Middle School Teachers", and still getting the same error, even as an admin and restoring in a new course.
          Hide
          Jérôme Mouneyrac added a comment -

          I've tested with qa.moodle.net and it worked too.

          Show
          Jérôme Mouneyrac added a comment - I've tested with qa.moodle.net and it worked too.
          Hide
          Jérôme Mouneyrac added a comment - - edited

          The iPad course works too: https://skitch.com/mouneyrac/gccqp/site-pages-my-home

          It's weird. Can you detail your test steps:

          • what Moodle version are you using?
          • what role you are using?
          • if you are using qa.moodle.net, you can not run this QA test except if you are admin and you unregister first. (the registration token is broken for sites that rollback their database after an admin re-register)
          • what are your restore settings
          Show
          Jérôme Mouneyrac added a comment - - edited The iPad course works too: https://skitch.com/mouneyrac/gccqp/site-pages-my-home It's weird. Can you detail your test steps: what Moodle version are you using? what role you are using? if you are using qa.moodle.net, you can not run this QA test except if you are admin and you unregister first. (the registration token is broken for sites that rollback their database after an admin re-register) what are your restore settings
          Hide
          Nicolas Martignoni added a comment -

          Suggesting closing, as this duplicates MDL-25545.

          The error message returned is not helpful at all and should be improved for such situations.

          Show
          Nicolas Martignoni added a comment - Suggesting closing, as this duplicates MDL-25545 . The error message returned is not helpful at all and should be improved for such situations.
          Hide
          Jérôme Mouneyrac added a comment -

          Thanks Nicolas, I close the issue as your issue has been resolved. Feel free to create a new issue if you consider that a better warning important in the publication process (imo I think you'll have this error in so many other places that it is not required here, specially I think it's not a community hub issue.) Cheers,
          Jerome

          Show
          Jérôme Mouneyrac added a comment - Thanks Nicolas, I close the issue as your issue has been resolved. Feel free to create a new issue if you consider that a better warning important in the publication process (imo I think you'll have this error in so many other places that it is not required here, specially I think it's not a community hub issue.) Cheers, Jerome

            People

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

              Dates

              • Created:
                Updated:
                Resolved: