Posts made by Joseph Rézeau

Picture of Core developers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Sara,

Thanks for your answer, which works perfectly. It's OK if one only has a handful of contents to upgrade, but a bulk upgrade would be nice to have, of course! I will create an "new feature" issue for this.

Also, when all contents have been upgraded to the most current library version, it would be nice to be able to delete the now obsolete library from the Moodle interface.

Best,

Joseph

Average of ratings: Useful (3)
Picture of Core developers Picture of Plugin developers Picture of Testers Picture of Translators
Thanks, Gemma, but I think you misunderstood my problem.
My problem is not with updating the H5P content types libraries. My problem is: when a new version of a library is available on a moodle site where H5P instances were created with an older version, the hvp plugin provides a way to upgrade those older instances to use the new library version.
This very useful feature is missing from the Moodle (core) h5pactivity, as clearly shown on my 2 screenshots.
Note.- This seems related to MDL-68922 (H5P doesn't upgrade content when there is a newer H5P library). But the tracker reports this bug as fixed and closed. Maybe the "automatic" upgrading of contents only works for the "official" H5P activities, not for non-official ones, such as my own.
I will investigate further and report in this thread.
Average of ratings: Useful (1)
Picture of Développeurs Picture of Développeurs de plugins Picture of Testeurs Picture of Traducteurs

Et voilou la requête à utiliser (on suppose que le préfixe des tables est "mdl" comme recommandé à l'installation de Moodle).

SELECT c.format 'Format', c.fullname
FROM mdl_course AS c
GROUP BY c.format

ce qui donne sur mon petit site de test:

ou plus précisément pour le seul format 'topcoll':

SELECT c.format 'Format', c.fullname
FROM mdl_course AS c
WHERE c.format = 'topcoll'
GROUP BY c.format

CQFD smile

Average of ratings: Utile (3)