These steps are copied from MDL-69687.

You need to start with a Moodle 3.9.2 site, preferably one that contains some real data.

I think that it is sufficient to test this change on just one of the supproted branches. The change is identical on each branch.

Notes

• This issue must be tested against MySQL or MariaDB, and Postgres (i.e. MySQL and Postgres, or MariaDB and Postgres)

Setup

1. Have a look at your config.php and locate the $CFG->prefix. Make a note of it.
2. Run the following SQL in your database (replace 'mdl_' with the prefix in use), and make a note of the resulting number:

   SELECT COUNT(1) FROM mdl_course_modules_completion;

3. Make a note of the result.
   We will re-run this query a number of times and we'll need this

Before applying the patch

1. Enable completion tracking on your Moodle site:
   1. Login as admin
   2. Navigate to Site administration -> Advanced features
   3. Enable completion tracking
2. Create three new courses (with completion enabled).
3. Create a new assignment in each course
   1. Under "Activity completion" set "Completion tracking" to "Students can manually mark the activity as completed"
4. Duplicate the assignment twice in each course (Each course now has three assignments)
5. Enrol a student in each course
6. Log in as the test student account and mark each of the activities complete.
7. Run the following SQL, using the original result you had earlier:

   SELECT COUNT(1) - [resultfromsetup] FROM mdl_course_modules_completion;

   -- For example:

   SELECT COUNT(1) - 308 FROM mdl_course_modules_completion;

   1. Confirm that the result is 9
8. Log back in as admin
9. Delete one of the assignments in each course
10. Run the SQL again using the same value - i.e. in the example 308
    1. Confirm that the result is 6
11. Delete one of the courses
12. Run the SQL again using the same value - i.e. in the example 308
    1. Confirm that the result has not changed and is still 6

Apply the patch

1. Ensure that you're on the latest version of the code for your branch
2. Run the Moodle upgrade:

   php admin/cli/upgrade.php

3. Run the SQL again using the same value - i.e. in the example 308
   1. Confirm that the result has not changed and is now 4
4. Delete one of the remaining courses.
5. Run the SQL again using the same value - i.e. in the example 308
   1. Confirm that the result has not changed and is now 2