upgrade from 3.8 to 3.9(.1) failing from CLI and TTW

Re: upgrade from 3.8 to 3.9(.1) failing from CLI and TTW

by Carl Brewer -
Number of replies: 3
MariaDB [moodle]> show tables like '%h5p%';
+----------------------------------+
| Tables_in_moodle (%h5p%) |
+----------------------------------+
| mdl_h5p |
| mdl_h5p_contents_libraries |
| mdl_h5p_libraries |
| mdl_h5p_libraries_cachedassets |
| mdl_h5p_library_dependencies |
| mdl_h5pactivity |
| mdl_h5pactivity_attempts |
| mdl_h5pactivity_attempts_results |
+----------------------------------+
8 rows in set (0.000 sec)

database created :
MariaDB [moodle]> CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

the moodle DB user's perms set by :
MariaDB [moodle]> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodleuser@localhost;
In reply to Carl Brewer

Re: upgrade from 3.8 to 3.9(.1) failing from CLI and TTW

by Carl Brewer -
I just tried to bump this instance to 3.10, same problem. I'm at a loss. Any more suggestions?
In reply to Carl Brewer

Re: upgrade from 3.8 to 3.9(.1) failing from CLI and TTW

by Leon Stringer -
Picture of Core developers Picture of Particularly helpful Moodlers

H5P functionality was added in 3.8 but the actual H5P activity wasn't added until 3.9 so the tables mdl_h5pactivity, mdl_h5pactivity_attempts and mdl_h5pactivity_attempts_results shouldn't be there.

This problem can occur when an upgrade attempt has been rolled back to the previous version by restoring the database and the restore didn't remove the new tables, which is the default behaviour with mysqldump/mysql < XXX.sql.

So hopefully the fix is to drop the above three tables and also mdl_quizaccess_seb_quizsettings and mdl_quizaccess_seb_template if present, then attempt the upgrade.


Average of ratings: Useful (1)
In reply to Leon Stringer

Re: upgrade from 3.8 to 3.9(.1) failing from CLI and TTW

by Carl Brewer -

Command line upgrade from 3.8.4+ (Build: 20200807) (2019111804.05) to 3.10+ (Build: 20201211) (2020110900.05) completed successfully.


Bingo!

Thank you!!


Carl