To be honest, I find the whole workflow very chaotic and redundant so I've spent a couple of weeks working at its refactoring. Now my instance is much more logical regarding status changes, and what happens when the status changes to completed. Not only competences are involved, but also ...

Thanks, looks like that is now fixed. It'll need updating in V3.0

You must be missing something. I've tried and it works. Unfortunately not. There is still the current time value being assigned to the learning_coursesuer:date_completed field in the database. competencies will make no difference to this, as it's the subscribe library that is controlling the date ...

Unfortunately no success. Marking a student as attended, and setting their course status to complete adds Now() to the learning_courseuser -> date_completed field.

I'm looking at lib.subscribe.php now for the bug.

Just implemented the above code in the competencies files, no change to behaviour unfortunately. After dinner this evening I will trace through lib.subscribe.php and find the error.

:lol: alfa24, you may be my twin, I'm just looking through SubscriptionsAlms.php and it appears to call updateUserStatusInCourse, just after setDateFinished has been called. updateUserStatusInCourse takes a variable $new_date_complete, which if empty, inserts Now() into the query... The rabbit hole ...

Thanks alfa24, suffice to say the code you posted previously updates the DB correctly, but somewhere else in the system is resetting the date automatically straight after the update. This can be watched with a trace on the DB field when running the code. I'll continue debugging the code and find out ...

Please provide detailed steps to reproduce the issue WITH my proposed function. alfa24, tracked the problem down, and it was with the DB, not the code. However, I've now found another problem :lol: https://forum.formalms.org/forum/download/file.php?mode=view&id=1051 The date of completion in the ...

Tried to implement the code above Alfa24, but unfortunately unsuccessful as there is another piece of code that is taking a value from php Now() and inserting it into learning_courseuser table in the field date_complete. I dug around in the lib.subscribe.php file and found the function ...

The table core_setting contains a field called param_value.

Set this to 0 via phpmyadmin or such and you'll not have the problem if you are locked out again.