frederic3

As I think there will be no other solution, I decided to migrate my database to the new format. Here’s a short rundown of what I did.

Beware this is a dangerous operation where you could loose your website content! Only do what you understand!

1. I upgraded my server to Debian 11.0 Bullseye. This means, I am now on MariaDB 10.5.11.

2. I made a Backup of the H5P plugin version 1.15 (path needs to be adapted):
tar cvf h5p.tar /var/my-website/cms/wp-content/plugins/h5p

3. Just to be safe and able to quickly recover, I made an image copy of all database files (path is standard location in Debian):

systemctl stop mariadb
tar cvf mysql.tar /var/lib/mysql
systemctl start mariadb

4. Create a SQL script dump of the WordPress database, which includes H5P (the database name needs to be adapted):
mysqldump --add-drop-database wordpress >wordpress.sql

5. Completely erase the WordPress database and recreate it from scratch using the dump file (database name and database user needs to be adapted):

mysql -u root 
drop database wordpress;
create database wordpress;
grant all privileges on wordpress.* to wordpress@localhost;
flush privileges;
use wordpress;
source wordpress.sql;
exit

6. Upgrade H5P Plugin to Version 1.15.3. This worked without a problem now. In my case, the Row Format of the WordPress tables in MariaDB has changed from “Compact” to “Dynamic” (can be verified with select * from information_schema.INNODB_SYS_TABLES;)

@icc0rz I think it’s the same issue. The content is not showing on the web page and can’t be opened on the backend. In the web server log file I get the following:

AH01071: Got error 'PHP message: WordPress-Datenbank-Fehler Unknown column 'hc.a11y_title' in 'field list' f\xc3\xbcr Abfrage SELECT hc.id
              , hc.title
              , hc.parameters AS params
              , hc.filtered
              , hc.slug AS slug
              , hc.user_id
              , hc.embed_type AS embedType
              , hc.disable
              , hl.id AS libraryId
              , hl.name AS libraryName
              , hl.major_version AS libraryMajorVersion
              , hl.minor_version AS libraryMinorVersion
              , hl.embed_types AS libraryEmbedTypes
              , hl.fullscreen AS libraryFullscreen
              , hc.authors AS authors
              , hc.source AS source
              , hc.year_from AS yearFrom
              , hc.year_to AS yearTo
              , hc.license AS license
              , hc.license_version AS licenseVersion
              , hc.license_extras AS licenseExtras
              , hc.author_comments AS authorComments
              , hc.changes AS changes
   ...'