Lately, I had a database
corruption error that forced me to do a database restore of my Moodle site.
After restore we started to notice that there were missing enrollments in courses. For example, I have an account for a user enrolled to a course. After the restore, this user was not in the enrolled users list in the course, but after logging in to that account, (and seeing some flashing messages about enrolling!), this account was correctly shown in the course.
I'm not sure what is happenning, but it seems users need to login, to somehow "refresh" their enrollments in the different courses.
One last thing. Most of my users are enrolled using the external database (auth/db) plugin. And I wasn't able to verify if this problem is specific to these accounts, as I don't have many "regular" accounts to verify.
The problem I'm having is that assignment submissions for users are not showing, until they re-login, and I don't need to require all of my users (several thousands) to re-login, to enable teachers to view their submissions.
Any idea what's happenning, and what can I do to correct the issue?