Dear ILIAS-Admins,
on Nov 4th a new release for ILIAS 8 (8.25) was published. The ILIAS 8 branch
is a security-fixes only branch as announced in:
https://github.com/ILIAS-eLearning/ILIAS/blob/trunk/docs/development/suppor…
In this ILIAS 8 release, however, a security bug introduced a severe new
usability bug in the SCORM component. Thus, a fix for this bug
(https://mantis.ilias.de/view.php?id=46165) was also introduced today in this
branch after the release 8.25 tag in order to solve the regression. You can
find the release_8 branch here:
https://github.com/ILIAS-eLearning/ILIAS/tree/release_8. Please make sure to
checkout the latest commit of the release_8 branch in order to have a secure
and stable ILIAS 8 release.
Best regards
Rob Falkenstein
For the Technical Board of the ILIAS society
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
--
Databay AG Logo
*Simon Lowe
*
fon: +49 2405 40837-0
mail: slowe(a)databay.de
web: www.databay.de <https://www.databay.de>
Databay AG
Jens-Otto-Krag-Str. 11
52146 Würselen
Sitz/Amtsgericht Aachen • HRB: 8437 • USt-IdNr.: DE 210844202
Vorstand: Dipl.-Ing. Jens Conze, Aresch Yavari, Dipl.-Kfm. Philipp Hermanns
Aufsichtsratsvorsitzender: Dr. Jan Scholzen
Datenschutzhinweise für Kunden: Hier nachlesen
<https://www.databay.de/datenschutzhinweise-fuer-kunden>