Posts made by Visvanath Ratnaweera

Moodle in English -> SCORM -> Upgrade from 4.1 LTS to 4.5 LTS: Which mod/scorm, if at all?

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators

During the upgrade from 4.1 LTS to 4.5 LTS mod/scorm started throwing an error. (Sorry, haven't documented.) I moved mod/scorm aside and the upgrade was successful - except that the plugin page shows mod/scorm as Missing from disk.

Question: Am I expected to put it back? When I do that, I get: 

Ein Downgrade des Plugins 'mod_scorm' von 2024100700 nach 2022112800 ist nicht möglich.

Pointing to http://docs.moodle.org/405/en/error/debug/cannotdowngrade.

Average of ratings: -

Moodle in English -> General help -> Can I flag a site to bypass registration?

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators

Is it possible to bypass registration through an entry in config.php?

The case at hand: An upgrade, 4.1 LTS > 4.5 LTS, hangs at "hub/errorconnect". It is pretty much Issue with hub/errorconnect after restoring site and changing domain, except in my case the domain remains. I applied the solution posted there, https://moodle.org/mod/forum/discuss.php?d=468882#p1882383, but it takes me in circles.

In case the HQ could cut open the circle by deleting the site from the registration database, I have posted the URL in the Report to moderator down here.

P.S. It occurred to me that the site is HTTP (no 'S'). Could there be a connection? (Don't ask me to change to HTTPS, the owner of the site does not want that.)

Average of ratings: -

Moodle in English -> SCORM -> Upgrade from 4.1 to 4.5 cycle around "SCORM track records that need to be migrated to the new table structure" -> Upgrade from 4.1 to 4.5 cycle around "SCORM track records that need to be migrated to the new table structure" [RESOLVED]

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators

RESOLVED

Yes, that was it! Trimming mdl_scorm_scoes_track as explained in https://moodle.org/mod/forum/discuss.php?d=398448#p1607266 solved the problem. Many thanks!

Yes, I was in the Moodle front-end. But I don't think CLI would have helped. Even the mysql client couldn't delete the whole 15 M records in one transaction. That "Lock wait time out" error kept on coming. I trimmed the table by starting unixtimes 5 years ago, 1 year ago,..

For the others, MDL-46279 was fixed in Moodle 4.3. So this would not have happened if the source Moodle was 4.3 or newer. Mein was 4.1 LTS.

Average of ratings: Useful (1)

Moodle in English -> SCORM -> Upgrade from 4.1 to 4.5 cycle around "SCORM track records that need to be migrated to the new table structure"

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators

During a site upgrade from 4.1.19 to 4.5.5 I keep on getting the error, "This next upgrade step may take some time to complete, your site has 15649211 SCORM track records that need to be migrated to the new table structure, please be patient as a progress bar is not able to be displayed." After a long delay it throws the error quoted below. Once I click on "Continue" it repeats. 

The question is whether the script will keep on converting the records and will finish or it always start from the beginning and will never finish. The serer, a beefy dedicated server, doesn't lack in power. 

mod_scorm

This next upgrade step may take some time to complete, your site has 15649211 SCORM track records that need to be migrated to the new table structure, please be patient as a progress bar is not able to be displayed.

Fehler beim Schreiben der Datenbank

Weitere Informationen über diesen Fehler

Debug-Info:  Lock wait timeout exceeded; try restarting transaction
INSERT INTO mdl_scorm_scoes_value (attemptid, scoid, elementid, value, timemodified)
SELECT a.id as attemptid, t.scoid as scoid, e.id as elementid, t.value as value, t.timemodified
FROM mdl_scorm_scoes_track t
JOIN mdl_scorm_element e ON e.element = t.element
JOIN mdl_scorm_attempt a ON (t.userid = a.userid AND t.scormid = a.scormid AND a.attempt = t.attempt)
[array (
)]
Error code: dmlwriteexception

Stack trace: 

  • line 500 of /lib/dml/moodle_database.php: dml_write_exception thrown
  • line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
  • line 1258 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
  • line 141 of /mod/scorm/db/upgrade.php: call to mysqli_native_moodle_database->execute()
  • line 908 of /lib/upgradelib.php: call to xmldb_scorm_upgrade()
  • line 651 of /lib/upgradelib.php: call to upgrade_plugins_modules()
  • line 1937 of /lib/upgradelib.php: call to upgrade_plugins()
  • line 719 of /admin/index.php: call to upgrade_noncore()
Average of ratings: -