From chat with Eloy:

1) SELECT contextid FROM mdl_repository_instances
WHERE NOT EXISTS (SELECT 'x' FROM mdl_context WHERE id = contextid);

2) That's the list of orphaned repositories in the site

3) DELETE FROM mdl_repository_instances WHERE contextid = xxxxx

note that the 1037 should appear in the list produced by 1).

Upgrade test

This upgrade test has to be done on all supported DB engines

1. Enable Flickr Public repository
2. Create a User instance of that repository in a new user account
3. Create a Course instance of that repository in a new course
4. Delete the user
5. Delete the course
6. Visit Home / Site administration / Plugins / Repositories / Manage repositories
   • Make sure you SEE errors
7. Upgrade to the latest
8. Visit Home / Site administration / Plugins / Repositories / Manage repositories
   • Make sure you DO NOT see any errors

Test pre-requisites

• Enable the File System repository with Course/User instances allowed
• Create the folders
  • $dataroot/repository/course
  • $dataroot/repository/user
• Place a different picture in each folder
• Create a new course (C1)
• Create a new course (C2)
• Create a new user (U1)
• Make U1 an admin so it has all the capabilities

Test preparation

1. Login as U1
2. Go to C1
3. Navigate to Home / Courses / Miscellaneous / C1 / Repositories / Course repositories
4. Create a File System instance using the folder course (call it FS Course)
5. Add a file module to the course (call it 'Please pick me')
   • As content, place a alias/shortcut of the image in FS Course

1. Navigate to Home / My profile / Repositories / U1 / Repositories
2. Create a File System instance using the folder user (call it FS User)

1. Navigate to C2
2. Create a file activity called 'Reference to User repo'
   • As a content, place a alias/shortcut of the image in FS User
3. Create another file activity called 'Reference to Course repo'
   • As a content, browse 'Server files' up to the course C1
   • Pick an alias/shortcut of the image in 'Please pick me' file module.

Test steps

1. Login as admin
2. Go to C2 and confirm that both file resources contain alias/shortcuts
   • One to FS User
   • Another one to FS Course
3. Delete the user U1
   • Make sure the FS User entry in mdl_repository_instances is deleted
   • Make sure the file in module 'Reference to a User repo' in C2 is now a real copy
4. Delete the course C1
   • Make sure the FS Course entry in mdl_repository_instances is deleted
   • Make sure the file in module 'Reference to a Course repo' in C2 is now a real copy
5. Visit Home / Site administration / Plugins / Repositories / Manage repositories
   • Make sure you don't see any errors