Hi, thanks for reading this question. We are running 2.5.30.
In the mdl_course_completions table, we found that we have quite a few records that timeenrolled > timecompleted, in the mdl_course_completions table. Just wondering what scenario would cause this to happen?
Here is the query that we used (with ad-hoc database queries plugin):
select cc.userid, u.firstname, u.lastname, u.username, cc.course, co.fullname, from_unixtime(cc.timeenrolled), from_unixtime(cc.timecompleted)
from prefix_course_completions cc, prefix_user u, prefix_course co
where cc.userid = u.id and cc.course = co.id and
timeenrolled > timecompleted
order by userid, course
What's even more interesting is that when we "login as" some of these users, under their "Record of Learning => Programs", we are seeing another different "Start date" (which is not the same with the timeenrolled):
In the above case, with the same user, this is what the report looks like:
Any idea how/why this would happen? By the way, which table does Totara 2.5 pull the "Start date" from? Thanks!
