By turning off AJAX I can delete the activities from the course, but they appear in the Journal Overview still. Though there is no resource id for the orphan activities.

Deleted Resources DO NOT appear in the summary list, nor Quizzes, but forums DO APPEAR as blank "ghosts" in the summary.

When my nightly backup was run, it returned ERROR in the email alerting me to completion. When I ran cron after deleting the blank activities, it seemed to run without returning an error.

Hope this helps.

I have checked, optimized and repaired the database with no luck.

Fiddling around the database I found this warning in a lot of the tables:

"The following indexes appear to be equal and one of them should be removed: PRIMARY, id".

So, should I simply remove one of the indexes? Which one?

Turning on error logs told me, that there was a duplicate entry in 'mdl_backup_ids'. How do I delete this?

Besides trying to browse 'mdl_backup_ids' and 'mdl_backup_files' I get the message "Table seems to be empty".

Is my database just corrupted?

Is it safe to install a fresh version of Moodle and restore everything from the backups?

The following indexes appear to be equal and one of them should be removed: PRIMARY, id

what should I do about this? ..best..janet

btw... I tried to use your screenshot attachment device, but it didn't work... (mac OSX 10.4.x/Safari)

Log in as admin, create a blank course, and assign a teacher.
Log in as a teacher, enter the course, and import activities from another course.
Repeat the import process with the same course.

The result is a bunch of icons with no text. Clicking on these icons gives the message "Course Module ID was incorrect".

Note that in many cases on our production 1.8.4 environment, the orphaned icons do appear after the first import. We also have faculty that have run into this when restoring a backup into a new course.

Once there are 'orphaned' icons in the course, they cannot be removed if AJAX is enabled. If the user turns off AJAX, the blank activities/resources can be removed. However, removing them does not trigger rebuild_course_cache, so these empty items still show up in certain places. For instance, if you remove non-existent quizzes, clicking on 'Quizzes' in the course Activities block will bring up a table with blank lines for the removed quizzes. Also, the course backup page will show check boxes for any removed items. These empty items can cause a subsequent course backup to fail.

So, I still haven't figured out why import/restore sometimes creates these duplicate/empty icons, but when it does, there is a 2-step workaround to get rid of them -

1. Turn off AJAX and delete the items.
2. Toggle the visibility of any section to trigger rebuild_course_cache.

It's strange that it's happening in successfully restored courses because rebuild_course_cache() is executed as one of the final steps of restore. Uhm. I'll try to comment here about how the other bug evolves.

Ciao

the fix of MDL-14326 actually works but it just removes the empty icons and leaves the target course empty after the failed import. I have followed Ann's step-by-steps and got some PHP Notices. I am going to check and will let you know.

?au

"Turn off AJAX and delete the items." worked fine. But I still wonder if there's any problem with database as you mention above, and if yes what is the procedure to correct it.

Just before the restore part of the import starts, after the export from the "from" course is complete, there is a page titled "Import Course Data" with just a "(continue)" link. If the link isn't clicked within a few seconds, the page redirects and the restore launches. If the user happens to click this "(continue)" link twice, with maybe a half-second or so between clicks, duplicate icons will almost always occur. If the user clicks the link just before the page redirects, the problem will sometimes occur, depending on the timing. If the link is clicked just once when it first appears, or if the page is left to redirect on its own, the import works as expected.

It looks like there is some logic in backup/restore.php to prevent multiple restore executions, but it doesn't seem to be working quite right.

I do not know how to solve this

1. In our theme's stylesheet, I added the following so that the continue link doesn't display -

/* Don't display the continue link on imports */
#backup-restore #redirect #continue { display: none; } 2. I then added a message (should be a lang string) and a shorter timeout to the redirect - Index: restorelib.php =================================================================== RCS file: /cvsroot/moodle/moodle/backup/restorelib.php,v retrieving revision 1.283.2.56 diff -u -r1.283.2.56 restorelib.php --- restorelib.php 18 Dec 2008 00:18:44 -0000 1.283.2.56 +++ restorelib.php 15 Jan 2009 15:40:52 -0000 @@ -7405,7 +7405,7 @@ }
else {
if (empty($noredirect)) { - redirect($CFG->wwwroot.'/backup/restore.php?backup_unique_code='.$backup_unique_code.'&launch=form&file='.$file.'&id='.$id); + redirect($CFG->wwwroot.'/backup/restore.php?backup_unique_code='.$backup_unique_code.'&launch=form&file='.$file.'&id='.$id, "Please wait...", 1); } else { return $backup_unique_code; }