Dear all,
after consultation with the product manager I would like to inform you about the following problem, in order to prevent you from loosing data.
In ILIAS 9.15, a bug was fixed that corrects the online status in learning sequences, as these were stored ambiguously: https://mantis.ilias.de/view.php?id=45670 Unfortunately, the deletion of the “lso_activation” table resulted in the loss of some online statuses (NO LEARNING DATA IS AFFECTED, only whether objects are online or not). This affects all learning sequences that were copied with a container (course, category, folder, etc.) and were not opened before the update.
To restore the data, a DB backup must be used in which the affected table is still available. From this, you can restore the lso_activation table (temporarily) and use SQL to transfer the data to the new location, namely to object_data. My colleague Ingmar wrote a SQL statement, which you are able to restore the online-status and which worked for our clients. Of course, use is without guarantee - the statement should be used as a template and checked for each individual case.
UPDATE object_data INNER JOIN object_reference ON object_data.obj_id = object_reference.obj_id INNER JOIN lso_activation ON lso_activation.ref_id = object_reference.ref_id SET object_data.offline = 0, lso_activation.effective_online = 1 WHERE object_data.offline = 1 AND lso_activation.online = 1 AND lso_activation.activation_start_ts IS NULL AND lso_activation.activation_end_ts IS NULL;
Important notice: The affected Learning Sequences can also be set online manually, so this especially relevant if your platform contains a high number of those objects.
Many thanks to Ingmar for investigating this.
Best regards Simon
