Moodle
  1. Moodle
  2. MDL-15489

Restore fails: Could not restore modules!

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Won't Fix
    • Affects Version/s: 1.9, 1.9.1, 1.9.2
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Environment:
      Debian stable, Apache 1.3, PHP 5
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Rank:
      1505

      Description

      Restore of courses sometimes fails with:
      Could not restore modules!
      and
      An error has occured and the restore could not be completed!

      The error occurs while restoring a test.
      Additionally the layout of the site is changed, all blocks are deleted and I have to add manually the blocks I want to see. It's really strange that a restore not working can change the page layout and delete the blocks.

      And last but not least a backup of the site is not running without errors, because the course with the crashed restore cannot be backuped, the log says "error".

      With this problem the migration to a new server is a really big problem, so far we have to stay on our old server.

      mfg ar

      1. restorelibpre15.php.patch1.txt
        55 kB
        Eloy Lafuente (stronk7)
      1. Bild 1.png
        31 kB
      2. failing_sql_statement_restore_process.png
        9 kB
      3. retore_fatal_error.png
        13 kB

        Issue Links

          Activity

          Hide
          Andreas Rittershofer added a comment -

          Is there any chance to get this bug fixed in the near future? We urgently need a new moodle-version on our new server, but this way 1.9 is not usable, we will get a lot of user complaints when they try to migrate their courses.

          mfg ar

          Show
          Andreas Rittershofer added a comment - Is there any chance to get this bug fixed in the near future? We urgently need a new moodle-version on our new server, but this way 1.9 is not usable, we will get a lot of user complaints when they try to migrate their courses. mfg ar
          Hide
          Brian McFarlane added a comment -

          We had this issue and ended up tracking it down to null values trying to be insterted into the resource table. Changed summary, alltext, and popup to allow nulls and the restores begain working just fine once again.

          Hope that helps others.

          Show
          Brian McFarlane added a comment - We had this issue and ended up tracking it down to null values trying to be insterted into the resource table. Changed summary, alltext, and popup to allow nulls and the restores begain working just fine once again. Hope that helps others.
          Hide
          Andreas Rittershofer added a comment -

          I tried what you proposed but it doesn't work for me, the error remains the same.

          So 1.9 is still not really usable - I wonder if nobody else but me tries to restore courses and fails.

          mfg ar

          Show
          Andreas Rittershofer added a comment - I tried what you proposed but it doesn't work for me, the error remains the same. So 1.9 is still not really usable - I wonder if nobody else but me tries to restore courses and fails. mfg ar
          Hide
          Brian McFarlane added a comment -

          Looks like there are more tables that must have null removed as a requirement. So here are the changes to make it work doing more restore testing.

          Change these fields to allow nulls:
          mdl_resource: summary, alltext, popup
          mdl_quiz: intro
          mdl_quiz_feedback: feedbacktext

          Looks like the import process isn't taking a null and replacing it with ''. I am sure there are more, just turn debugging up a notch and you will see the nulls in the insert statements.

          Show
          Brian McFarlane added a comment - Looks like there are more tables that must have null removed as a requirement. So here are the changes to make it work doing more restore testing. Change these fields to allow nulls: mdl_resource: summary, alltext, popup mdl_quiz: intro mdl_quiz_feedback: feedbacktext Looks like the import process isn't taking a null and replacing it with ''. I am sure there are more, just turn debugging up a notch and you will see the nulls in the insert statements.
          Hide
          Andreas Rittershofer added a comment -

          I just tried the changes mentioned above - the error remains the same.

          mfg ar

          Show
          Andreas Rittershofer added a comment - I just tried the changes mentioned above - the error remains the same. mfg ar
          Hide
          OEE_Dev KW_Univ added a comment -

          I got the same problem when restoring a course. I had tracked down the error and it seems that rejecting inserting a row in table mdl_forum_discussions with field has value of '-64800' which generates 'out of range value' error.

          I am using Moodle1.9.1+, on Apache 2.2, PHP 5.1 and MySQL 5 on Windows XP.

          Show
          OEE_Dev KW_Univ added a comment - I got the same problem when restoring a course. I had tracked down the error and it seems that rejecting inserting a row in table mdl_forum_discussions with field has value of '-64800' which generates 'out of range value' error. I am using Moodle1.9.1+, on Apache 2.2, PHP 5.1 and MySQL 5 on Windows XP.
          Hide
          Jens Gammelgaard added a comment -

          Can this issue be updated to a 'blocker'?

          Show
          Jens Gammelgaard added a comment - Can this issue be updated to a 'blocker'?
          Hide
          Andreas Rittershofer added a comment -

          Upgrade to 1.9 on new server not possible due to crashes in restore of some courses.

          Show
          Andreas Rittershofer added a comment - Upgrade to 1.9 on new server not possible due to crashes in restore of some courses.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Andreas...

          can you provide some course backup to test & debug in out dev environment? That way it'll be really easier to see what's happening. I've restored a couple of backups under Moodle 1.9.x and haven't found that problem.

          Feel free to send it to stronk7 [at] moodle [dot] org if possible. Obviously the course will be deleted after tests here.

          TIA and ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Andreas... can you provide some course backup to test & debug in out dev environment? That way it'll be really easier to see what's happening. I've restored a couple of backups under Moodle 1.9.x and haven't found that problem. Feel free to send it to stronk7 [at] moodle [dot] org if possible. Obviously the course will be deleted after tests here. TIA and ciao
          Hide
          Daniele Cordella added a comment -

          I have a similar problem since this morning.
          I am quite sure my problem is related to the questionnaire module so I informed Joseph R. of it.
          If you be may believe that the backup of my course may be useful for the solution of this issue, don't hesitate to contact me.
          Ciao.

          Show
          Daniele Cordella added a comment - I have a similar problem since this morning. I am quite sure my problem is related to the questionnaire module so I informed Joseph R. of it. If you be may believe that the backup of my course may be useful for the solution of this issue, don't hesitate to contact me. Ciao.
          Hide
          Jens Gammelgaard added a comment -

          Hi,

          Danielle, I don't think that is the only reason. We get the error when restoring from a course created in M. vers. 1.6+

          Show
          Jens Gammelgaard added a comment - Hi, Danielle, I don't think that is the only reason. We get the error when restoring from a course created in M. vers. 1.6+
          Hide
          Daniele Cordella added a comment -

          Sorry Gens
          consider my comment like nothing.
          People maintaining questionnaire solved my problem.
          It was a questionnaire restore bug.
          Sorry.

          Show
          Daniele Cordella added a comment - Sorry Gens consider my comment like nothing. People maintaining questionnaire solved my problem. It was a questionnaire restore bug. Sorry.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi all,

          about the "lost blocks" problem, I've created MDL-15803. It only affects Moodle 1.3 and Moodle 1.4 backups and should be working in next weekly 1.9.2+ release (or updating from CVS in a couple of hours).

          Show
          Eloy Lafuente (stronk7) added a comment - Hi all, about the "lost blocks" problem, I've created MDL-15803 . It only affects Moodle 1.3 and Moodle 1.4 backups and should be working in next weekly 1.9.2+ release (or updating from CVS in a couple of hours).
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Andreas, thanks a lot for your backup file, it has been really useful to fix the blocks problem arrive and to check your problem when restoring quizzes.

          I've seen that the backup file is a Moodle 1.4.x one. That's really old...

          Anyway, I've been playing a bit here with the mod/quiz/restorelibpre15.php file (the one in charge of restoring 1.4 quizzes) and I've been able to finish the restore process:

          • Apparently, all categories and questions have been restored ok.
          • Also attempts and grades look ok.
          • BUT responses in attempt (in some type of questions) are 100% lost so, when reviewing or regrading atempts, that is really a big problem.

          Looking to responses in DB (mdl_question_states table), it seems that the format of the "answer" field (where the student responses are saved) has changed and the code in mod/quiz/restorelibpre15.php isn't converting it to the correct (new) format. For example, multichoice questions used to have one simple number (pointing to the selected choice answer). But now... it has another format (to support the shuffle of answers - one "recent" feature).

          I'm adding Tim Hunt here, to know his expert opinion about this. Perhaps we can modify that script to support the new contents of that "answer" field?

          I've added one version of mod/quiz/restorelibpre15.php that allows the restore to end ok. BUT DON'T USE IT in production environments. Remember that attempt answers WILL BE LOST!

          In the mean time... I want to comment you one workaround for this sort of problems with backup, knowing that it isn't optimal, but uses to work:

          1) Install one Moodle 1.x (where x is the version where the backup was performed).
          2) Upgrade that Moodle 1.x to 1.9
          3) Make backup of the course
          4) That course should restore perfectly in Moodle 1.9

          Ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Andreas, thanks a lot for your backup file, it has been really useful to fix the blocks problem arrive and to check your problem when restoring quizzes. I've seen that the backup file is a Moodle 1.4.x one. That's really old... Anyway, I've been playing a bit here with the mod/quiz/restorelibpre15.php file (the one in charge of restoring 1.4 quizzes) and I've been able to finish the restore process: Apparently, all categories and questions have been restored ok. Also attempts and grades look ok. BUT responses in attempt (in some type of questions) are 100% lost so, when reviewing or regrading atempts, that is really a big problem. Looking to responses in DB (mdl_question_states table), it seems that the format of the "answer" field (where the student responses are saved) has changed and the code in mod/quiz/restorelibpre15.php isn't converting it to the correct (new) format. For example, multichoice questions used to have one simple number (pointing to the selected choice answer). But now... it has another format (to support the shuffle of answers - one "recent" feature). I'm adding Tim Hunt here, to know his expert opinion about this. Perhaps we can modify that script to support the new contents of that "answer" field? I've added one version of mod/quiz/restorelibpre15.php that allows the restore to end ok. BUT DON'T USE IT in production environments. Remember that attempt answers WILL BE LOST! In the mean time... I want to comment you one workaround for this sort of problems with backup, knowing that it isn't optimal, but uses to work: 1) Install one Moodle 1.x (where x is the version where the backup was performed). 2) Upgrade that Moodle 1.x to 1.9 3) Make backup of the course 4) That course should restore perfectly in Moodle 1.9 Ciao
          Hide
          Martin Dougiamas added a comment -

          Andreas (original reporter), are you using any non-standard modules or blocks? Can you list them all please?

          Show
          Martin Dougiamas added a comment - Andreas (original reporter), are you using any non-standard modules or blocks? Can you list them all please?
          Hide
          Tim Hunt added a comment -

          I see I never replied to Eloy's last comment. That is because restoring pre15 files relates to work done by Gustav before I took over as quiz maintainer and I have never had to look at this code, so I don't know much about it. For example I did not even know that the format of the answer column had changed in the quiz's past.

          Basically, I have been hoping that the problem of old quiz backups will just go away, but I realise that that may be unduly optimistic on my part.

          Show
          Tim Hunt added a comment - I see I never replied to Eloy's last comment. That is because restoring pre15 files relates to work done by Gustav before I took over as quiz maintainer and I have never had to look at this code, so I don't know much about it. For example I did not even know that the format of the answer column had changed in the quiz's past. Basically, I have been hoping that the problem of old quiz backups will just go away, but I realise that that may be unduly optimistic on my part.
          Hide
          Andreas Rittershofer added a comment -

          I'm not using any non-standard modules or blocks. It's a Moodle directly out-of-the-box without any modifications or additions.

          mfg ar

          Show
          Andreas Rittershofer added a comment - I'm not using any non-standard modules or blocks. It's a Moodle directly out-of-the-box without any modifications or additions. mfg ar
          Hide
          Judith Wilson added a comment -

          Unsure if this is the same problem

          I'm trying to import documents from one course to another (in v1.9.2). The documents have been added to course A in v1.9.2 and i want to import them to course B. It works fine until the final restore - then i get the following error message.

          ' Could not restore modules!

          Creating roles definitions
          Creating course level role assignments and overrides
          Creating module level role assignments and overrides
          Creating user level role assignments and overrides
          Closing the Restorelog.html file.

          An error has occurred and the restore could not be completed! '

          Show
          Judith Wilson added a comment - Unsure if this is the same problem I'm trying to import documents from one course to another (in v1.9.2). The documents have been added to course A in v1.9.2 and i want to import them to course B. It works fine until the final restore - then i get the following error message. ' Could not restore modules! Creating roles definitions Creating course level role assignments and overrides Creating module level role assignments and overrides Creating user level role assignments and overrides Closing the Restorelog.html file. An error has occurred and the restore could not be completed! '
          Hide
          Andreas Rittershofer added a comment -

          I just upgraded to 1.9.2, but the error when restoring some courses is still there.

          mfg ar

          Show
          Andreas Rittershofer added a comment - I just upgraded to 1.9.2, but the error when restoring some courses is still there. mfg ar
          Hide
          Andreas Rittershofer added a comment -

          I just tried to restore another course and got:

          Gruppen einrichtenXML error: Invalid character at line 7780

          What is wrong here?

          mfg ar

          Show
          Andreas Rittershofer added a comment - I just tried to restore another course and got: Gruppen einrichtenXML error: Invalid character at line 7780 What is wrong here? mfg ar
          Hide
          Tim Hunt added a comment -

          I think an Invalid character error means that the file is not properly encoded using charset UTF-8. Try looking at that line of the moodle.xml file inside the backup file in a good text editor (gedit on linux, JEdit might be a good choice on Windows).

          Show
          Tim Hunt added a comment - I think an Invalid character error means that the file is not properly encoded using charset UTF-8. Try looking at that line of the moodle.xml file inside the backup file in a good text editor (gedit on linux, JEdit might be a good choice on Windows).
          Hide
          Andreas Rittershofer added a comment -

          And again: The next course which is not restorable.

          This is a really big problem, so I cannot switch from our old server with 1.4 to our new server with 1.9.2.

          Would it be helpful to use an intermediate version, for example:

          save on 1.4.
          restore on 1.x
          save on 1.x
          restore on 1.9

          with 4 < x < 9?

          mfg ar

          Show
          Andreas Rittershofer added a comment - And again: The next course which is not restorable. This is a really big problem, so I cannot switch from our old server with 1.4 to our new server with 1.9.2. Would it be helpful to use an intermediate version, for example: save on 1.4. restore on 1.x save on 1.x restore on 1.9 with 4 < x < 9? mfg ar
          Hide
          Tim Hunt added a comment -

          Another plan that may work is:

          1. Clone your 1.4 install (database, moodledata and code).
          2. Upgrade that 1.4 site to 1.9, probably in several steps 1.4 -> 1.6 -> 1.8 -> 1.9 or something.
          3. Backup from that 1.9 site.
          4. Restore to your real 1.9 site.

          Show
          Tim Hunt added a comment - Another plan that may work is: 1. Clone your 1.4 install (database, moodledata and code). 2. Upgrade that 1.4 site to 1.9, probably in several steps 1.4 -> 1.6 -> 1.8 -> 1.9 or something. 3. Backup from that 1.9 site. 4. Restore to your real 1.9 site.
          Hide
          Ray Lawrence added a comment -

          Just a quick note so that we don't get pre-occupied with upgrades from much earlier versions I couldn't restore last week from 1.9.something_earlier to a fresh install of 1.9.2 _(last)weekly. Restoring the db and moodle files and then upgrading to the same newer version, and then attempting the restore worked fine. No changes to the db other than droping the tables and installing from scratch as normal which I imagine shouldn't have affected the db encoding.

          Show
          Ray Lawrence added a comment - Just a quick note so that we don't get pre-occupied with upgrades from much earlier versions I couldn't restore last week from 1.9.something_earlier to a fresh install of 1.9.2 _(last)weekly. Restoring the db and moodle files and then upgrading to the same newer version, and then attempting the restore worked fine. No changes to the db other than droping the tables and installing from scratch as normal which I imagine shouldn't have affected the db encoding.
          Hide
          Steve Turley added a comment -

          I just installed a fresh version of 1.9.2_(last) weekly and tried to do a backup and restore from the same versoin and ran into troubles. It works sometimes, but not with a particular large course I'm most concerned about. This is a blocker for me as well since migration to another server will be impossible if this is not fixed. Eloy, would it help to have a copy of the backup file from a recent version that fails? I would be glad to send you mine as well.

          Show
          Steve Turley added a comment - I just installed a fresh version of 1.9.2_(last) weekly and tried to do a backup and restore from the same versoin and ran into troubles. It works sometimes, but not with a particular large course I'm most concerned about. This is a blocker for me as well since migration to another server will be impossible if this is not fixed. Eloy, would it help to have a copy of the backup file from a recent version that fails? I would be glad to send you mine as well.
          Hide
          Hans de Zwart added a comment -

          I would like to add that we also have a Moodle site has problems restoring certain courses (within the same 1.9.x site; so no old course backups). Again it seems to be related to the restore process trying to store null values in database fields where NULL values are not allowed (just like Brian McFarlane) above.

          In one of our cases it seemed to be in the 'alltext' field in the 'resource' table and in the 'feedbacktext' field in the 'quiz_feedback' table (also see the failing_sql_statement_restore_process.png file attachment showing a failing query relating to this field).

          Should the restore function be made more robust so that it doesn't fail like this? Is there something wrong with the database definitions? Is there any chance of this bug being closed? What can we do to help resolve this bug?

          Kind regards,

          Hans

          Show
          Hans de Zwart added a comment - I would like to add that we also have a Moodle site has problems restoring certain courses (within the same 1.9.x site; so no old course backups). Again it seems to be related to the restore process trying to store null values in database fields where NULL values are not allowed (just like Brian McFarlane) above. In one of our cases it seemed to be in the 'alltext' field in the 'resource' table and in the 'feedbacktext' field in the 'quiz_feedback' table (also see the failing_sql_statement_restore_process.png file attachment showing a failing query relating to this field). Should the restore function be made more robust so that it doesn't fail like this? Is there something wrong with the database definitions? Is there any chance of this bug being closed? What can we do to help resolve this bug? Kind regards, Hans
          Hide
          Hans de Zwart added a comment -

          File belongs to comment from Hans de Zwart

          Show
          Hans de Zwart added a comment - File belongs to comment from Hans de Zwart
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Hans, Steve, Brian...

          I think it would be great to have some backup files causing that problem in your servers. Those problems related to NULL values. I don't need user data at all, just one backup containing the activity that is failing on restore. Also, please, don't forget to specify the DB used in your sites (MySQL, Postgres, MSSQL...) and the error showed on restore.

          I'll try to reproduce it here and look if the failure is in backup (wrongly exported data) or restore. I've tried here creating all sort of resources under 1.9.x and all them restore properly under MySQL and PostgreSQL, so having access to some backup able to reproduce the problem will be really helpful.

          About the problems in quizzes... as stated above... it seems that, definitively... 1.4 ==> 1.9 is broken, so the 1.4 ==> upgrade to 1.9 ==> backup & restore ==> 1.9 seems to be the only possible path to follow.

          TIA and ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Hans, Steve, Brian... I think it would be great to have some backup files causing that problem in your servers. Those problems related to NULL values. I don't need user data at all, just one backup containing the activity that is failing on restore. Also, please, don't forget to specify the DB used in your sites (MySQL, Postgres, MSSQL...) and the error showed on restore. I'll try to reproduce it here and look if the failure is in backup (wrongly exported data) or restore. I've tried here creating all sort of resources under 1.9.x and all them restore properly under MySQL and PostgreSQL, so having access to some backup able to reproduce the problem will be really helpful. About the problems in quizzes... as stated above... it seems that, definitively... 1.4 ==> 1.9 is broken, so the 1.4 ==> upgrade to 1.9 ==> backup & restore ==> 1.9 seems to be the only possible path to follow. TIA and ciao
          Hide
          Hans de Zwart added a comment -

          Hello Eloy,

          Thanks for getting back to us. I will try and obtain a restore file and precise information about the database that gives the issue...

          Nice X-mas!

          Hans

          Show
          Hans de Zwart added a comment - Hello Eloy, Thanks for getting back to us. I will try and obtain a restore file and precise information about the database that gives the issue... Nice X-mas! Hans
          Hide
          Trenton added a comment -

          We have experienced this issue as well. We upgraded to the latest version 1.9.3 and are just trying to use a backup/restore to make a copy of a course. If you would like we can include a backup file for you to look at. Thanks in advance for working on this issue.

          Show
          Trenton added a comment - We have experienced this issue as well. We upgraded to the latest version 1.9.3 and are just trying to use a backup/restore to make a copy of a course. If you would like we can include a backup file for you to look at. Thanks in advance for working on this issue.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Trenton,

          yes, any backup file able to reproduce the problem here will be really useful. Along some info like which DB are you using and the error displayed in restore. TIA!

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Trenton, yes, any backup file able to reproduce the problem here will be really useful. Along some info like which DB are you using and the error displayed in restore. TIA!
          Hide
          Hans de Zwart added a comment -

          Hello Eloy,

          I have sent a backup file to your stronk7 email address at moodle.org. I hope it can help you in resolving this issue...

          Kind regards,

          Hans

          Show
          Hans de Zwart added a comment - Hello Eloy, I have sent a backup file to your stronk7 email address at moodle.org. I hope it can help you in resolving this issue... Kind regards, Hans
          Hide
          Trenton added a comment -

          Stronk7,
          Thanks for your help .. I have sent the information you requested to your e-mail. Please let me know what other information would be useful to you.

          Show
          Trenton added a comment - Stronk7, Thanks for your help .. I have sent the information you requested to your e-mail. Please let me know what other information would be useful to you.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Hans, Trenton.

          Thanks a lot for your backup files... I'll test restore with them later today. I'll keep you informed here!

          Ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Hans, Trenton. Thanks a lot for your backup files... I'll test restore with them later today. I'll keep you informed here! Ciao
          Hide
          Jackie Gu added a comment -

          I got same issue on 1.9.3 latest 20090107, same issue at 20081231

          When do the restoration, I deselect (remove the ticks) all selection of course contents, put all yes/no choice to no, the same error still occurs!

          • Creating new course
            o ?????? (??MC) copy 14 (SEC3ANA_14)
            o Category: Miscellaneous
          • Creating the Restorelog.html in the course backup folder
          • Creating sections
          • Creating categories and questions
            o Category "??????"
            . . . . . Could not recode parent 36182 for question 4533
            . Could not recode parent 36182 for question 4534
            Could not recode parent 36182 for question 4535
            . Could not recode parent 36182 for question 4536
            Could not recode parent 36182 for question 4537
            . Could not recode parent 36182 for question 4538
            Could not recode parent 36182 for question 4539
            . Could not recode parent 36182 for question 4540
            Could not recode parent 36182 for question 4541
            . Could not recode parent 36182 for question 4542
            o Category "????????"
            . . . . .
            Could not restore categories and questions!
          • Creating roles definitions
          • Creating course level role assignments and overrides
          • Creating module level role assignments and overrides
          • Creating block level role assignments and overrides
          • Creating user level role assignments and overrides
          • Closing the Restorelog.html file.

          An error has occurred and the restore could not be completed!

          Show
          Jackie Gu added a comment - I got same issue on 1.9.3 latest 20090107, same issue at 20081231 When do the restoration, I deselect (remove the ticks) all selection of course contents, put all yes/no choice to no, the same error still occurs! Creating new course o ?????? (??MC) copy 14 (SEC3ANA_14) o Category: Miscellaneous Creating the Restorelog.html in the course backup folder Creating sections Creating categories and questions o Category "??????" . . . . . Could not recode parent 36182 for question 4533 . Could not recode parent 36182 for question 4534 Could not recode parent 36182 for question 4535 . Could not recode parent 36182 for question 4536 Could not recode parent 36182 for question 4537 . Could not recode parent 36182 for question 4538 Could not recode parent 36182 for question 4539 . Could not recode parent 36182 for question 4540 Could not recode parent 36182 for question 4541 . Could not recode parent 36182 for question 4542 o Category "????????" . . . . . Could not restore categories and questions! Creating roles definitions Creating course level role assignments and overrides Creating module level role assignments and overrides Creating block level role assignments and overrides Creating user level role assignments and overrides Closing the Restorelog.html file. An error has occurred and the restore could not be completed!
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Hans, Trenton (and everybody else using MSSQL)...

          I've been able to reproduce your problem here! B-) and it seems to be related to one bug in the FreeTDS driver that you are using. Sadly I wasn't able to reproduce it here because I've a fixed FreeTDS running in my test environment.

          For your info... the bug happens in backup (not in restore) and causes empty fields from DB to be retrieved as NULLs. Then, in the restore process, those NULLs cannot be inserted in "NOT NULL" fields (obviously), so the process break.

          See bugs like MDL-11810 and, especially, MDL-14725. In this last bug we were able to compile one FreeTDS 0.82 driver free of the problems exposed above. It's available thanks to Trevor Johnson as one attachment. So, if you are running Moodle over Windows, I'd suggest you to replace your current php_dblib.dll extension by the one available in that bug (curiously the problem doesn't affect linux users working against MSSQL).

          Don't forget to save the current extension in a safe place to be able to return to it (just in case the new one doesn't work for you) !

          If you can test restore using that extension and feedback here about your results... it'll be great! If works ok, we'll update the Moodle Docs page pointing to that extension and will publicly that in Moodle forums in order to allow all MSSQL+Windows users to know and fix about it.

          In case you want to build your own extension... you can find a HOW-TO about that (written by my some weeks ago) here: http://docs.moodle.org/en/Development:Compiling_FreeTDS_under_Windows

          Ciao

          P.S: Offtopic: when testing your courses I've detected other bug (MDL-17826) when restoring course scales... I'm going to commit fix for it in some minutes. So I guess you'll be interested about to update your Moodle 1.9 instalations (only affect MSSQL and Oracle) next Wednesday (MOODLE_19_WEEKLY).

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Hans, Trenton (and everybody else using MSSQL)... I've been able to reproduce your problem here! B-) and it seems to be related to one bug in the FreeTDS driver that you are using. Sadly I wasn't able to reproduce it here because I've a fixed FreeTDS running in my test environment. For your info... the bug happens in backup (not in restore) and causes empty fields from DB to be retrieved as NULLs. Then, in the restore process, those NULLs cannot be inserted in "NOT NULL" fields (obviously), so the process break. See bugs like MDL-11810 and, especially, MDL-14725 . In this last bug we were able to compile one FreeTDS 0.82 driver free of the problems exposed above. It's available thanks to Trevor Johnson as one attachment. So, if you are running Moodle over Windows, I'd suggest you to replace your current php_dblib.dll extension by the one available in that bug (curiously the problem doesn't affect linux users working against MSSQL). Don't forget to save the current extension in a safe place to be able to return to it (just in case the new one doesn't work for you) ! If you can test restore using that extension and feedback here about your results... it'll be great! If works ok, we'll update the Moodle Docs page pointing to that extension and will publicly that in Moodle forums in order to allow all MSSQL+Windows users to know and fix about it. In case you want to build your own extension... you can find a HOW-TO about that (written by my some weeks ago) here: http://docs.moodle.org/en/Development:Compiling_FreeTDS_under_Windows Ciao P.S: Offtopic: when testing your courses I've detected other bug ( MDL-17826 ) when restoring course scales... I'm going to commit fix for it in some minutes. So I guess you'll be interested about to update your Moodle 1.9 instalations (only affect MSSQL and Oracle) next Wednesday (MOODLE_19_WEEKLY).
          Hide
          Eloy Lafuente (stronk7) added a comment -

          IMPORTANT: When testing, remember that the bug is in backup... so you'll need to re-backup the course (because your current .zip backup file has incorrect data).

          Show
          Eloy Lafuente (stronk7) added a comment - IMPORTANT: When testing, remember that the bug is in backup... so you'll need to re-backup the course (because your current .zip backup file has incorrect data).
          Hide
          Hans de Zwart added a comment -

          Wow Eloy,

          Thanks for all the information. I will post my feedback as soon as I can!

          Kind regards,

          Hans

          Show
          Hans de Zwart added a comment - Wow Eloy, Thanks for all the information. I will post my feedback as soon as I can! Kind regards, Hans
          Hide
          Petr Škoda added a comment -

          lowering priority, seems only small number of servers is affected

          Show
          Petr Škoda added a comment - lowering priority, seems only small number of servers is affected
          Hide
          Wen Hao Chuang added a comment -

          The problem exist here in SFSU too. If you use JMeter script to hit your local development server to simulate 1000+ quiz attempts, then try to backup/restore, I think you could consistently reproduce this issue...

          Show
          Wen Hao Chuang added a comment - The problem exist here in SFSU too. If you use JMeter script to hit your local development server to simulate 1000+ quiz attempts, then try to backup/restore, I think you could consistently reproduce this issue...
          Hide
          Wen Hao Chuang added a comment -

          Here is an example, tested with the latest 1.9.4+ (Build: 20090217). When you have a lot of attempts in the quiz and you tried to restore with these attempts, restore will eventually time out and break.

          Show
          Wen Hao Chuang added a comment - Here is an example, tested with the latest 1.9.4+ (Build: 20090217). When you have a lot of attempts in the quiz and you tried to restore with these attempts, restore will eventually time out and break.
          Hide
          Tim Hunt added a comment -

          Wen, your problem is MDL-14302.

          See my comment http://tracker.moodle.org/browse/MDL-14302?focusedCommentId=47604&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_47604 which explains the issue. There is no easy solution, there is a fundamental flaw in the restore architecture. The only option is to completely redo backup and restore. Ooh! what is that I see on the 2.0 roadmap? http://docs.moodle.org/en/Roadmap#Improvements_to_other_parts_of_Moodle

          Show
          Tim Hunt added a comment - Wen, your problem is MDL-14302 . See my comment http://tracker.moodle.org/browse/MDL-14302?focusedCommentId=47604&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_47604 which explains the issue. There is no easy solution, there is a fundamental flaw in the restore architecture. The only option is to completely redo backup and restore. Ooh! what is that I see on the 2.0 roadmap? http://docs.moodle.org/en/Roadmap#Improvements_to_other_parts_of_Moodle
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi,

          I've been performing some tests last week (thanks to the example backup files sent - Wen, Jackeline...). I've tried a lot of alternatives and have added results to:

          http://docs.moodle.org/en/Development:Backup_2.0_-_Improve_XML_parsing

          Without further analysis (I'll comment each result later this week), it seems that we have one clear winner for Moodle 2.0 (Method 2). But it cannot be used in Moodle 1.9.x because that stuff is PHP 5.2 dependent.

          So, perhaps, one alternative could be to use Method 5 for 1.9.

          Anyway, it's work in progress, so some more thoughts will arrive soon in that page (and here).

          Ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi, I've been performing some tests last week (thanks to the example backup files sent - Wen, Jackeline...). I've tried a lot of alternatives and have added results to: http://docs.moodle.org/en/Development:Backup_2.0_-_Improve_XML_parsing Without further analysis (I'll comment each result later this week), it seems that we have one clear winner for Moodle 2.0 (Method 2). But it cannot be used in Moodle 1.9.x because that stuff is PHP 5.2 dependent. So, perhaps, one alternative could be to use Method 5 for 1.9. Anyway, it's work in progress, so some more thoughts will arrive soon in that page (and here). Ciao
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi, just refreshing info here:

          In the past days I've been reviewing the whole restore under Moodle 1.9 and have fixed some bugs and improvements. The two improvements I wanted to share here are:

          • MDL-18468: Splitting of moodle.xml for speed (controlled by experimental setting).
          • MDL-18482: Skipping non-selected activities to be processed in restore.

          While both improvements are related to speed, the second one has one side effect, enabling to restore courses causing memory problems by restoring them into multiple executions, selecting different activities each time. This workaround wasn't possible previously because ALL activities were processed always no matter if they finally were created in the restored course.

          In the next days I'll be fixing some more minor bugs in restore and then will try to find the definitive way to fix this memory problem in the quiz restore (now that I've been playing with the XML parsers a lot, I think it would be possible to introduce some fix).

          And that's all for now, I'll keep you informed. Ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi, just refreshing info here: In the past days I've been reviewing the whole restore under Moodle 1.9 and have fixed some bugs and improvements. The two improvements I wanted to share here are: MDL-18468 : Splitting of moodle.xml for speed (controlled by experimental setting). MDL-18482 : Skipping non-selected activities to be processed in restore. While both improvements are related to speed, the second one has one side effect, enabling to restore courses causing memory problems by restoring them into multiple executions, selecting different activities each time. This workaround wasn't possible previously because ALL activities were processed always no matter if they finally were created in the restored course. In the next days I'll be fixing some more minor bugs in restore and then will try to find the definitive way to fix this memory problem in the quiz restore (now that I've been playing with the XML parsers a lot, I think it would be possible to introduce some fix). And that's all for now, I'll keep you informed. Ciao
          Hide
          Glenys Hanson added a comment -

          Hi,

          I don't understand the previous discussions very well as I'm not a developer, but I haven't got a reply to a "Could not restore modules" problem that I posted in the "Back up and restore" forum. Others seem to be having a similar problem. See : http://moodle.org/mod/forum/discuss.php?d=117337

          On 1.9.4 local restore of a course is only possible without forum user data. If forum user data is included the "Could not restore modules" error message appears and restore is blocked. The course is hosted here : http://uepd.moodle.com.au

          This is a fairly complex course using a number of activities. Simpler, smaller courses on the same platform can be restored locally including forum user dater with no problem.

          Is there a solution? Do you need more information?

          TIA,
          Glenys

          Show
          Glenys Hanson added a comment - Hi, I don't understand the previous discussions very well as I'm not a developer, but I haven't got a reply to a "Could not restore modules" problem that I posted in the "Back up and restore" forum. Others seem to be having a similar problem. See : http://moodle.org/mod/forum/discuss.php?d=117337 On 1.9.4 local restore of a course is only possible without forum user data. If forum user data is included the "Could not restore modules" error message appears and restore is blocked. The course is hosted here : http://uepd.moodle.com.au This is a fairly complex course using a number of activities. Simpler, smaller courses on the same platform can be restored locally including forum user dater with no problem. Is there a solution? Do you need more information? TIA, Glenys
          Hide
          Don Hinkelman added a comment -

          Hi Glenys,

          As posted on MDL-14302, here is an emergency workaround that might help Backup/Restore in your situation.
          "FYI, we found a workaround to complete Restore. But it takes 29 minutes for the restore! We changed the php settings in php.ini to allow greater memory. First, we upped it from 128MB to 512MB, but got a similar error message. Then we upped it to 1024MB and restore continued for 29 minutes before success. Normally we could restore this course with Moodle 1.6 in less than minute, so there is still some kind of bug in there[1.8/1.9]. We also increased the execution time to allow item analysis to finish, which now works, but slowly. So these are the settings we changed in php.ini:"
          memory_limit = 1024MB
          max_execution_time = 120

          Thanks, too, to Eloy, for working on this. I hope it is at the top of your list. You are indeed our Knight in Shining Armour!

          Don

          Show
          Don Hinkelman added a comment - Hi Glenys, As posted on MDL-14302 , here is an emergency workaround that might help Backup/Restore in your situation. "FYI, we found a workaround to complete Restore. But it takes 29 minutes for the restore! We changed the php settings in php.ini to allow greater memory. First, we upped it from 128MB to 512MB, but got a similar error message. Then we upped it to 1024MB and restore continued for 29 minutes before success. Normally we could restore this course with Moodle 1.6 in less than minute, so there is still some kind of bug in there [1.8/1.9] . We also increased the execution time to allow item analysis to finish, which now works, but slowly. So these are the settings we changed in php.ini:" memory_limit = 1024MB max_execution_time = 120 Thanks, too, to Eloy, for working on this. I hope it is at the top of your list. You are indeed our Knight in Shining Armour! Don
          Hide
          Sean Keogh added a comment -

          Hi ELoy (and everyone else),

          I am getting a similar problem on a site for one of our clients.

          They have a backup that was taken on a 1.9.4+ system - trying to restore the backup to the same system as a new course fails at the point when it is starting to create modules.

          I have tried this on the very latest weekly 1.9.5+ as well, with essentially the same result - the restore aborts at the point where it is starting to create modules, with the error "Could not restore modules!"

          I have tried increasing the memory limit for PHP on the server up to 1024MB, but it made no difference - the restore fails as soon as it gets to the "creating modules" section - there is no wait involved.

          I also tried running the restore with everyting unselected except two of the modules - with exactly the same result.

          ...........

          I've just tried again, and by selectively enabling and disabling modules, I can report that it is actually questionnaire that is the culprit.

          Our client quite rightly feels that a system that cannot restore it's own backups is defective...but now I have to explain that the thing causing the problem is a non-standard module that they wanted, that we said was OK.

          ugh....

          Sean K

          Show
          Sean Keogh added a comment - Hi ELoy (and everyone else), I am getting a similar problem on a site for one of our clients. They have a backup that was taken on a 1.9.4+ system - trying to restore the backup to the same system as a new course fails at the point when it is starting to create modules. I have tried this on the very latest weekly 1.9.5+ as well, with essentially the same result - the restore aborts at the point where it is starting to create modules, with the error "Could not restore modules!" I have tried increasing the memory limit for PHP on the server up to 1024MB, but it made no difference - the restore fails as soon as it gets to the "creating modules" section - there is no wait involved. I also tried running the restore with everyting unselected except two of the modules - with exactly the same result. ........... I've just tried again, and by selectively enabling and disabling modules, I can report that it is actually questionnaire that is the culprit. Our client quite rightly feels that a system that cannot restore it's own backups is defective...but now I have to explain that the thing causing the problem is a non-standard module that they wanted, that we said was OK. ugh.... Sean K
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Hi Sean,

          yup. Immediate abort/error sounds like something being wrong in the restore (or backup!) code (logic), instead of memory/timeout problems. I've some template courses here covering as much as possible of core and 1 use to backup and restore them really often, when fixing other problems, bugs...

          So I'd say that backup/restore of core modules is 99.9% functional (apart from nasty limit constraints by design - like this bug). But contrib code... well I haven't it in my templates so cannot "guarantee" that at all.

          In any case... I hope it's a restore problem, that means that, by fixing restore, everything will work in that module. In the other side, if the original problem is in the backup of the module... that's worse because can lead to un-restoreable modules

          Also, about this bug (memory usage on restore), I haven't updated recently it mainly because I haven't been able to find one satisfactory solution until now (to reduce that crazy memory usage in the quiz) without breaking other modules restore. grrr...

          I hope to be able to return to this issue (and hopefully find a working solution) in 2 weeks or so (until then I'm centred in other - DB related - critical tasks that need to be addressed asap). Feel free to ping me here if I don't comment anything here after that period!!

          Ciao

          Show
          Eloy Lafuente (stronk7) added a comment - Hi Sean, yup. Immediate abort/error sounds like something being wrong in the restore (or backup!) code (logic), instead of memory/timeout problems. I've some template courses here covering as much as possible of core and 1 use to backup and restore them really often, when fixing other problems, bugs... So I'd say that backup/restore of core modules is 99.9% functional (apart from nasty limit constraints by design - like this bug). But contrib code... well I haven't it in my templates so cannot "guarantee" that at all. In any case... I hope it's a restore problem, that means that, by fixing restore, everything will work in that module. In the other side, if the original problem is in the backup of the module... that's worse because can lead to un-restoreable modules Also, about this bug (memory usage on restore), I haven't updated recently it mainly because I haven't been able to find one satisfactory solution until now (to reduce that crazy memory usage in the quiz) without breaking other modules restore. grrr... I hope to be able to return to this issue (and hopefully find a working solution) in 2 weeks or so (until then I'm centred in other - DB related - critical tasks that need to be addressed asap). Feel free to ping me here if I don't comment anything here after that period!! Ciao
          Hide
          Glenys Hanson added a comment -

          Hi Sean, Eloy and everybody,

          Just to say that the restore problem I reported on the 2nd of April has been solved since updating to 1.9.5 (and also two other problems to do with the dates of forum messages and the inability to install language packs).

          The course that does now restore includes two Questionnaires.

          Cheers,
          Glenys

          Show
          Glenys Hanson added a comment - Hi Sean, Eloy and everybody, Just to say that the restore problem I reported on the 2nd of April has been solved since updating to 1.9.5 (and also two other problems to do with the dates of forum messages and the inability to install language packs). The course that does now restore includes two Questionnaires. Cheers, Glenys
          Hide
          Chardelle Busch added a comment -

          I can confirm this is still a problem when restoring a quiz (with perhaps a large # of users?-the quiz b/u alone was 1.5MB). I just tried it with a course b/u from 1.8.3the problem occurred only when the quiz was included. The questions are created but not the actual quiz-only the icon appears in the course with the correct id #. I tried restore on 1.9.4 and 1.9.5.

          Show
          Chardelle Busch added a comment - I can confirm this is still a problem when restoring a quiz (with perhaps a large # of users?- the quiz b/u alone was 1.5MB). I just tried it with a course b/u from 1.8.3 the problem occurred only when the quiz was included. The questions are created but not the actual quiz -only the icon appears in the course with the correct id #. I tried restore on 1.9.4 and 1.9.5.
          Hide
          Andrew Greig added a comment -

          A copy of my post from http://moodle.org/mod/forum/discuss.php?d=125006

          Could not recode truefalse answer id random248828-790606 for state 3769312
          Could not recode multichoice answer id random247789-788657 for state 3769313
          Could not recode newest state id 3769305

          A sample backup file that can be used for testing can be obtained here: https://p2.kvcc.edu/morp/broken_backup.zip

          We are running version 1.9.4 build 20090205
          backup version 2008030301 (obtained from within the moodle.xml backup file)

          Show
          Andrew Greig added a comment - A copy of my post from http://moodle.org/mod/forum/discuss.php?d=125006 Could not recode truefalse answer id random248828-790606 for state 3769312 Could not recode multichoice answer id random247789-788657 for state 3769313 Could not recode newest state id 3769305 A sample backup file that can be used for testing can be obtained here: https://p2.kvcc.edu/morp/broken_backup.zip We are running version 1.9.4 build 20090205 backup version 2008030301 (obtained from within the moodle.xml backup file)
          Hide
          Frédéric Hoogstoel added a comment -

          Restoring in Moodle 1.9.8+ a course backup from a Moodle 1.9 containing a questionnaire instance failed with the error :
          Could not restore modules!
          and
          An error has occured and the restore could not be completed!

          This is because the backup of the questionnaire instance contains values in lowercase 'y' or 'n' in several fields, but the databse constraints require values 'Y' or 'N' in uppercase.

          In debug mode, we see several errors like :
          ------------------
          ERREUR: la nouvelle ligne viole la contrainte de vérification « mdl_questionnaire_survey » de la relation « mdl_questionnaire_survey_public_check »

          INSERT INTO mdl_questionnaire_survey ( ID, NAME, OWNER, REALM, PUBLIC, STATUS, TITLE, EMAIL, SUBTITLE, INFO, THEME, THANKS_PAGE, THANK_HEAD, THANK_BODY )
          VALUES ( 48, 'SERPE_2008_copy1_copy', '192', 'private', 'y', 0, 'Questionnaire', '', 'Suivi Et Réalisation de Projet Etudiant en 2008', '', 'qu_orangechoc.css', '', '', '' )
          o line 1554 of lib/dmllib.php: call to debugging()
          o line 117 of mod/questionnaire/restorelib.php: call to insert_record()
          -------------------

          Show
          Frédéric Hoogstoel added a comment - Restoring in Moodle 1.9.8+ a course backup from a Moodle 1.9 containing a questionnaire instance failed with the error : Could not restore modules! and An error has occured and the restore could not be completed! This is because the backup of the questionnaire instance contains values in lowercase 'y' or 'n' in several fields, but the databse constraints require values 'Y' or 'N' in uppercase. In debug mode, we see several errors like : ------------------ ERREUR: la nouvelle ligne viole la contrainte de vérification « mdl_questionnaire_survey » de la relation « mdl_questionnaire_survey_public_check » INSERT INTO mdl_questionnaire_survey ( ID, NAME, OWNER, REALM, PUBLIC, STATUS, TITLE, EMAIL, SUBTITLE, INFO, THEME, THANKS_PAGE, THANK_HEAD, THANK_BODY ) VALUES ( 48, 'SERPE_2008_copy1_copy', '192', 'private', 'y', 0, 'Questionnaire', '', 'Suivi Et Réalisation de Projet Etudiant en 2008', '', 'qu_orangechoc.css', '', '', '' ) o line 1554 of lib/dmllib.php: call to debugging() o line 117 of mod/questionnaire/restorelib.php: call to insert_record() -------------------
          Hide
          Mark van Hoek added a comment -

          We still have this issue with 1.9.9

          Show
          Mark van Hoek added a comment - We still have this issue with 1.9.9
          Hide
          Sebastián Gómez Velasco added a comment -

          Hi everyone,

          I'm working with a very customized Moodle based on Moodle 1.9.4+, and I have the same problem described in this forum. I get a message like this "Could not recode multichoice answer id random1436-3054 for state 60297" when a course is restored.

          The backup was generated from a course that I didn't create, so I've been trying to make this error happen with new courses created by me. I just found out how to make this error happen. I followed these steps:

          • First I created a new course (course X) with only one quiz. It has only 2 questions: one added by me, and the other randomly added.
          • Next, I made a backup (from course X).
          • Next, I restored the course with no errors (course Y), but when I looked into the quiz the student's attempts of the randomly added question were lost. The grades restored perfectly by the way.
          • Next, I made again a new backup (from course Y).
          • I restored the course using this new backup and finally I got the error "Could not recode multichoice answer id random1436-3054 for state 60297".

          After this I returned to the first course which had the error, and I noticed that all the questions were randomly added.

          In my opinion this error is caused by the random questions. Today I've been making a lot of backups (with no random questions) and everything went fine.

          I hope this help someone.

          Tomorrow I'm going to check the source code, and I hope I can fix it because I need the students attempts correctly restored.

          PD: If someone had solved this problem, please I need help.

          Show
          Sebastián Gómez Velasco added a comment - Hi everyone, I'm working with a very customized Moodle based on Moodle 1.9.4+, and I have the same problem described in this forum. I get a message like this "Could not recode multichoice answer id random1436-3054 for state 60297" when a course is restored. The backup was generated from a course that I didn't create, so I've been trying to make this error happen with new courses created by me. I just found out how to make this error happen. I followed these steps: First I created a new course (course X) with only one quiz. It has only 2 questions: one added by me, and the other randomly added. Next, I made a backup (from course X). Next, I restored the course with no errors (course Y), but when I looked into the quiz the student's attempts of the randomly added question were lost. The grades restored perfectly by the way. Next, I made again a new backup (from course Y). I restored the course using this new backup and finally I got the error "Could not recode multichoice answer id random1436-3054 for state 60297". After this I returned to the first course which had the error, and I noticed that all the questions were randomly added. In my opinion this error is caused by the random questions. Today I've been making a lot of backups (with no random questions) and everything went fine. I hope this help someone. Tomorrow I'm going to check the source code, and I hope I can fix it because I need the students attempts correctly restored. PD: If someone had solved this problem, please I need help.
          Hide
          Sebastián Gómez Velasco added a comment -

          Hi everyone,

          I've solved "Could not recode ...... answer id random####-#### for state ####". This was caused by a random question bug, and it seems to be present in Moodle 2.0 (I reviewed the code). Do I need to create a new bug report for this problem and its solution?

          Show
          Sebastián Gómez Velasco added a comment - Hi everyone, I've solved "Could not recode ...... answer id random####-#### for state ####". This was caused by a random question bug, and it seems to be present in Moodle 2.0 (I reviewed the code). Do I need to create a new bug report for this problem and its solution?
          Hide
          Amanda Doughty added a comment -

          Could I have your fix please?

          Show
          Amanda Doughty added a comment - Could I have your fix please?
          Hide
          Stephen Martin added a comment -

          Seeing this issue in 1.9.10 when trying to restore a course with forums containing user data. If I backup and restore without the user data, it works. But I need the user data (there are a number of Q&A forums with seeded questions and answers). Seems to fail on forum messages that contain embedded images.

          Running with Developer DEBUG on, I don't get anything helpful. No reference to SQL statement failing. Just the following in the stack trace:

          • line 1664 of lib/deprecatedlib.php: call to debugging()
          • line 69 of backup/restore_execute.html: call to error()
          • line 174 of backup/restore.php: call to include_once()

          Posted in the Forums as well (http://moodle.org/mod/forum/discuss.php?d=168493)

          The backup file is very large (200MB--includes a number of Captivate and Presenter apps), but I can provide access to it if needed.

          Show
          Stephen Martin added a comment - Seeing this issue in 1.9.10 when trying to restore a course with forums containing user data. If I backup and restore without the user data, it works. But I need the user data (there are a number of Q&A forums with seeded questions and answers). Seems to fail on forum messages that contain embedded images. Running with Developer DEBUG on, I don't get anything helpful. No reference to SQL statement failing. Just the following in the stack trace: line 1664 of lib/deprecatedlib.php: call to debugging() line 69 of backup/restore_execute.html: call to error() line 174 of backup/restore.php: call to include_once() Posted in the Forums as well ( http://moodle.org/mod/forum/discuss.php?d=168493 ) The backup file is very large (200MB--includes a number of Captivate and Presenter apps), but I can provide access to it if needed.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          This is one follow-up for the problem reported by Stephen (problem while restoring forums): MDL-26528

          Show
          Eloy Lafuente (stronk7) added a comment - This is one follow-up for the problem reported by Stephen (problem while restoring forums): MDL-26528
          Hide
          Eloy Lafuente (stronk7) added a comment -

          U P S T R E A M I Z E D !

          Many thanks, this is now available in all the repos (git & cvs).

          Closing, ciao

          Show
          Eloy Lafuente (stronk7) added a comment - U P S T R E A M I Z E D ! Many thanks, this is now available in all the repos (git & cvs). Closing, ciao
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Doh,

          somehow this issue was closed incorrectly when processing all the integrated issues this week. (sort of most voted and current in integration filters mix). Apologies for the confusion, reseting to previous status!

          Ciao, Eloy

          Show
          Eloy Lafuente (stronk7) added a comment - Doh, somehow this issue was closed incorrectly when processing all the integrated issues this week. (sort of most voted and current in integration filters mix). Apologies for the confusion, reseting to previous status! Ciao, Eloy
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Closing this as won't fix. 19_STABLE fell out of support some years ago.

          Show
          Eloy Lafuente (stronk7) added a comment - Closing this as won't fix. 19_STABLE fell out of support some years ago.

            Dates

            • Created:
              Updated:
              Resolved: