Hi,
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?
In reply to Fadi Mansour
Re: Problem with enrolled users after database restore, auth/db
by Fadi Mansour -
UPDATE
First of all, there's an error in my previous message, most of my users were enrolled by enrol/database not auth/db.
Second: The problem seem to have been caused by a problem in the restoration of the mdl_enrolments table.
I reviews the output from the SQL restore command and there seem to have been an error while restoring that table, hence the missing enrollments.
The solution for me was to re-run the command line command to sync enrollments with the external database.