Hi,
Since the above emergency release is a critical one, and involves possible data loss across versions which have been "in the wild" for quite some time, is there any fix included or in development to "regenerate" the data? I'm a little unclear if the activity completion data is affected or not, and therefore whether the course completion data could be recreated from those records.
Regards
Dan
Hi Dan,
We wanted to get a fix out as a first priority - but we still have a bit more work to do to understand exactly which data is affected and if the data can be recalculated.
Below is my current understanding but I'll follow up tomorrow to confirm the exact details. I'm also going to see if the log table provides a way to confirm if a site was affected or not.
Here is some additional information on the effects of this issue:
To determine if your site has been affected.
Your site is affected if you meet ALL three criteria below:
1. Your site was live with any of the following versions:
2.4.18
2.4.19
2.5.10
2.5.11
2.5.12
2.6.0
Note: These versions were all released on or after 15th April 2014 11th March 2014 so if you haven't upgraded since then you will be unaffected.
2. You make use of the "Course completion" feature.
3. Any of the following actions were performed while you were running one of the affected version (e.g. since upgrading):
| Action | Log record |
| Edited the course completion settings on any course in your site, unless you just pressed "Unlock criteria without deleting". | 'course completion updated' (unless immediately preceeded by 'course completion unlocked without reset'). |
| Clicking "Unlock criteria and delete existing completion data" button on any course completion settings page. | 'course completion data reset' |
| Deleted any course in your site. | 'course delete' |
| Deleted a category on your site, if the category contained courses and you chose the "delete all contents" option. | 'category delete'. No way to tell if it contained courses or if 'delete all contents' was chosen. |
| Reset any course in your site with the "delete completion data" option checked. | None |
| Restore a course into current or another existing course with "delete the contents of the existing course and then restore" option selected | None |
The log records column indicates if this action is recorded in the site logs. You should be able to search your recent logs and look for the 'action' mentioned to see if each event occurred.
What will be lost if you are affected:
The data that is lost indicates which individual course completion criteria have been met. The bug does not affect the overall course completion data so if users have already completed a course that will still be shown. However if they are part way through a course their progress may have gone, and if they have completed a course the course completion report won't show which criteria they met.
To recover lost data if you are affected:
Some criteria can be regenerated based off other data within the site. This is dependent on the course completion criteria type you are using:
The following criteria will automatically be regenerated the next time your site's cron is run:
The following criteria is recoverable, and we will provide an upgrade script in the next release of 2.4 and 2.5 to recalculate this data when you upgrade:
The following criteria are unfortunately not recoverable without database backups:
Simon
