Much of this testing is a duplicate of MDL-37939 as we are just altering the SQL query in that upgrade step. Install a fresh 2.3 version just prior to 2012062504.08 1. Create a new course 2. Create 5-6 course modules in each of 3 sections. 3. Move course modules between sections. . 4. They will appear to move, but they will be broken sequence data Confirm that with SQL queries; SELECT id, section, sequence from mdl_course_sections where course = ? order by section asc; SELECT id, section from mdl_course_modules where course = ?; Refresh the page and make some more changes: Confirm that although the drag/drop appears to work, when you actually refresh the page it doesn't persist across a refresh 5. Now apply the patch and upgrade confirm that the CMs didn't appear to move from where they were before the upgrade confirm that the DB looks correct now (no duplicates in sequence data) move some CMs around sections refresh confirm that the section sequence data is correct confirm that the cm.section is correct On 2.4 and 2.5 1. Take a course with a fair few CMs 2. Apply the upgrade 3. Confirm that the CMs didn't appear to move from where they were before the upgrade 4. Run the SQL to confirm sequences are correct SELECT id, section, sequence from mdl_course_sections where course = ? order by section asc; SELECT id, section from mdl_course_modules where course = ?; Breaking&fixing test: By editing the DB directly create situations when fields course_modules.section and course_sections.sequence (inside the same course) do not match, for example: Module points to the wrong section Module points to the non-existing section (i.e. section 0) Module is present is several section sequences Module is present several times in its section sequence Module is not present in any section sequences Re-run the upgrade script and make sure it is fixed. Note that in 2.6 you will need to actually view the course to complete fixing. Hint, to re-run the upgrade script you can create a file testupgrade.php : <?php include "config.php"; require_once($CFG->libdir.'/db/upgradelib.php'); upgrade_course_modules_sequences(); purge_all_caches(); echo "Done.";