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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

          Attachments

            Issue Links

              Activity

              Hide
              jerome 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
              jerome 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
              mina 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
              mina 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
              mina 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
              mina 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
              jerome Jérôme Mouneyrac added a comment -

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

              Show
              jerome Jérôme Mouneyrac added a comment - I've tested with qa.moodle.net and it worked too.
              Hide
              jerome 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
              jerome 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
              mina 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
              mina 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
              jerome 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
              jerome 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: