All are running the same code (2.7.2+)
We build courses on the pre-production, then run through a process of checking, then back up the course on pre-production and restore it on production before going live.
When a course is set up to allow Manual completion by others and a specific role, when the restore happens, it removes the role, but still has the requirement set. As a result, if you try to check the course completion page, it comes up with a php error.
In the database, within the mdl_course_completion_criteria table, it lists the role as being 0, whereas in all our instances it should be 4.
Note - the role id's are the same on the prepoduction site as the production site, so it is not a role id mismatch issue.
The fix is fairly easy, either modify the table and change any 0's to 4's, or go back in and tick the appropriate role to allow for course completion. However the solution would be to rectify the backup in the first place.
Has any one else come across this issue?