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

      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).

        Gliffy Diagrams

          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: