Moodle in English: How to clean up a failed restore?

How to clean up a failed restore?

by A. T. Wyatt - Friday, August 17, 2007, 11:35 PM

I seem to have a bad archive. Twice, I have tried to restore it (originally a 1.6.3, restored to 1.8.2). It stops and no errors are reported. (I have restored about 60 other courses, and they all worked, so I think it has to do with this particular zip file).

I can't seem to delete this course (it shows up in the courses list, but if you try to delete you get a title at the top and the rest is a blank page). I can't complete the restore either because my unique shortname is already taken and we use that to do the batch enroll of students! So I am stuck!

I think it stopped on a line that started with the words "checking course". This was not a complicated archive--nothing, really, but a couple of labels and 2 documents. No users.

So I want to delete these two partial courses manually out of the database.

I haven't a clue as to which tables I should check. I do know the course IDs for the partially restored course.

Can anyone help? Please speak in words of one syllable and I will forward to my IT department! wink

Thanks,
atw

Re: How to clean up a failed restore?

by Andy Tagliani - Saturday, August 18, 2007, 6:53 AM

In the past i remember, i don´t if this problem already exist, when a user has no description in his profile, the moodle.xml file inside the archive makes some trouble. Can you download the zip-file and extract them? If you can do this, open the moodle.xml with the firefox browser. Is there a problem, it will shows you the line.

Second idea, i got some trouble with a 3rd party hack of the assignment module. In moodle 1.6.x exist a feature "Upload & Review", where teachers can reload a student file. This makes this trouble, that the course will show in the list, but a click on the course link shows a blank page.

I must modify a file in the assignment module (it was moodle 1.8.1 and even today i had the same trouble with a customer, he did upgrade from 1.6.3 to 1.8.2) to modifiy or delete the course.

Andy

Average of ratings: -

Re: How to clean up a failed restore?

by A. T. Wyatt - Tuesday, August 21, 2007, 12:38 AM

You might be onto something! I looked in the xml file and sure enough, they had used upload and review. But how do I get the pieces of the failed restored out of my database? I do not know what tables to look in. atw

Average of ratings: -

Re: How to clean up a failed restore?

by Andy Tagliani - Tuesday, August 21, 2007, 2:10 AM

Hi

Please give me one day, i must reload this course and copy the error warnings. I will come back with an answer 1-2 days, i hope thats ok for you. I need all our testserver today, i´m sorry! I will not forget you!

I make some weeks ago an entry to an existing topic in the issue tracker, see this link

Andy

Average of ratings: -

Re: How to clean up a failed restore?

by A. T. Wyatt - Tuesday, August 21, 2007, 2:25 AM

Voted for and comment added!

I am not in a hurry, so long as this partial restore doesn't bollux my database. I just hid the partial courses for now. I was able to get in to the course settings and rename the shortname, so I am in pretty good shape.

Thanks for the tip!
atw

Average of ratings: -

Re: How to clean up a failed restore?

by Andy Tagliani - Tuesday, August 21, 2007, 6:28 AM

So i hurry up

Ok, on a new moodle 1.8.2 installation i found the lines in the file /moodle/assignment/lib.php from line 1682 to 1686, but attention, the line 1682 is empty!

The lines shows me:
require_once("$CFG->dirroot/mod/assignment/type/$assignment->assignmenttype/assignment.class.php");
$assignmentclass = "assignment_$assignment->assignmenttype";
$ass = new $assignmentclass();
return $ass->delete_instance($assignment);
}

Now i modificate this file, after it looks like below: (line 1682, 1683 is empty and 1684)

$assignmentclass = "assignment_$assignment->assignmenttype";

}

We this modification i can delete the damage course. I will say, it was not a problem of moodle, it was a 3rd party extension who makes the problems!

After i play the original file back to the server, everything works fine! Now you can tell me the question, what should you do with your damage course. I reload the backup file on a moodle 1.6.x installation and restore the course. I´m gonna change the assignment type from "Upload & Review" to another assignment type. Backup the course and reload the backup file to moodle 1.8.2 and it gaves no more problems!

This was my solution, its a qucik and dirty solution, but it works for me! The line numbers can be different, in moodle 1.8.1 where i have the first time troubles, was the lines from 1667 to 1671!

Andy

Average of ratings: -

Re: How to clean up a failed restore?

by A. T. Wyatt - Sunday, August 26, 2007, 10:17 PM

Update:
Petr added some fault tolerance to mod/assignment/lib.php so that you can delete a course that failed during restore because of a third-party assignment type.

Details here: http://tracker.moodle.org/browse/MDL-10056

The fixes were added to mod/assignment/lib.php on Aug 22, 2007 12:42 pm.

Hurray! Thank you, Andy, for your help in the meantime.

atw

Average of ratings: -

Re: How to clean up a failed restore?

by Andy Tagliani - Sunday, August 26, 2007, 11:03 PM

Hi atw

For the future an information. I check the moodle.xml from the issue tracker. Sometimes atw can it be, that a problem can be comes up, when you as an example jump to new server or a server with a modified or new configuration, example:

Your old server allow max. file upload, let us say 8MB. Your new server or server with modified configuration allows, let us say 50MB. This information is stored too in the moodle.xml of the backup file. Sometimes, not in every case, can this different information (configuration) brings up a problem too. So i tell our customers everytime too, look at this points and look if u have any 3rd party plugins or extansions and tell your admin they should copy these information for the future!

Anyway, best message is, the fix from Petr works now for you.
Hi from germany
Andy

Average of ratings: -

Backup and restore

How to clean up a failed restore?