Can’t Find H5P-Content

  • martijnvanwesten

    (@martijnvanwesten)


    2 years, 11 months ago

    Since the last update, the h5p-content is not displaying anymore. It’s also not working in the backend of WordPress. Can someone help me?

    WordPress databasefout Unknown column ‘hc.a11y_title’ in ‘field list’ bij query 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
    , hc.default_language AS defaultLanguage
    , hc.a11y_title AS a11yTitle
    FROM wp_h5p_contents hc
    JOIN wp_h5p_libraries hl ON hl.id = hc.library_id
    WHERE hc.id = 116 gemaakt door require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Leerplein-1/single.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, H5P_Plugin->shortcode, H5P_Plugin->get_content, H5PCore->loadContent, H5PWordPress->loadContent

Viewing 15 replies - 1 through 15 (of 27 total)
1 2
  • Plugin Author icc0rz

    (@icc0rz)

    2 years, 11 months ago

    Strange, it looks like the database update hasn’t run. Could you try commenting out or removing line 440 of wp-content/plugins/h5p/public/class-h5p-plugin.php and reload your /wp-admin/ page? After the reload put it back. This should force the upgrade.

    I will have to try and reproduce this on a local site.

    Thread Starter martijnvanwesten

    (@martijnvanwesten)

    2 years, 11 months ago

    Thanks for your reply.

    Unfortunately, this isn’t working.

    lgbu

    (@lgbu)

    2 years, 11 months ago

    I am running WordPress 5.7.1 on Ubuntu. After the 1.15.2 plugin update (around April 22, 2021), I kept getting

    “Cannot find H5P content with id: ##”.

    When I rolled it back to 1.41.1, most worked. Some ran into version issues.

    • This reply was modified 2 years, 11 months ago by lgbu.
    • This reply was modified 2 years, 11 months ago by lgbu.
    lgbu

    (@lgbu)

    2 years, 11 months ago

    Some further information.

    I am running the same wordpress 5.7.1 and h5p 1.15.2 on another machine (locally) with no problem. The PhP version is 7.2.24 .

    The one with “missing h5p id” is running php 7.4. Wondering that might be the problem.

    Thanks to all.

    zazumaster

    (@zazumaster)

    2 years, 11 months ago

    Hi. I rolled back to version 1.14.1 because of the same problem when I updated. Now the content works, but it’s not possible to edit nor create anything. For example, If I try to edit a memory, the backoffice only shows the title and the rest of the builder is missing.

    Wordpress 5.5.4, PHP 7.3.27

    Please help.

    Thank you.

    Thread Starter martijnvanwesten

    (@martijnvanwesten)

    2 years, 11 months ago

    Hi, I rolled back to version 1.15 and that works for me.

    I hope that we can update in the future and still can use our H5P-content.

    zazumaster

    (@zazumaster)

    2 years, 11 months ago

    How can I roll back to 1.15? The rollback plugin I have only offers from 14.2 to lower.

    Thread Starter martijnvanwesten

    (@martijnvanwesten)

    2 years, 11 months ago

    I used a backup of last week. Do you have that?

    zazumaster

    (@zazumaster)

    2 years, 11 months ago

    Yes, I think I have a backup. I’ll try that.

    lgbu

    (@lgbu)

    2 years, 11 months ago

    Greetings, I also wanted to go back to 1.15 instead of 1.41 because of the incompatible content types. Is there a way to download Ver. 1.15 of H5P for WP? I think the H5P team might include a 1.15 as previous version so we could roll back to. Hope the problems will be resolved soon. Thanks.

    lgbu

    (@lgbu)

    2 years, 11 months ago

    Hello, I believe I found a potential reason– database incompatibility. On a local site, I run MySQL 5.7 and PHP 7.2 with NO problems with the plugin (1.15.2). On the site where I had problems, I was running MariaDB 10.3. After I backed up the databases, then removed MariaDB, and installed MySQL server 5.7.33. Everything went well. Hope this might be helpful for those who had problems with the WordPress h5p plugin 1.15.2.

    System: Ubuntu 18.04; MySQL 5.7.33; PHP 7.4.16 (back to normal).
    All the best, lgbu

    • This reply was modified 2 years, 11 months ago by lgbu.
    Plugin Author icc0rz

    (@icc0rz)

    2 years, 11 months ago

    Ok, I have checked the plugin with MariaDB 10.5.9 and PHP 8.0.3 without any issues.

    lgbu

    (@lgbu)

    2 years, 11 months ago

    @icc0rz. Thank you for your great work. That is interesting. The 1.15.2 plugin is working very well on my site now (MySQL 5.7 & PHP 7.2 or 7.4). I wonder if those who came across issues with 1.15.2 have MySQL or MariaDB and the versions. Just curious.

    frederic3

    (@frederic3)

    2 years, 11 months ago

    @icc0rz and everybody else, the same problem happend to me. Fortunately, I could roll back to a backup of 1.15, which solved the problem for now.

    My system is Debian 10 with the distribution’s current PHP and MariaDB versions. Those are PHP 7.3.27-1~deb10u1 and MariaDB Ver 15.1 Distrib 10.3.27-MariaDB.

    Of course, I’d prefer to stay current with H5P! If I can help to fix this problem, I’m happy to do so.

    Plugin Author icc0rz

    (@icc0rz)

    2 years, 11 months ago

    @frederic3 Are you seeing the same query issue as the top post here, or is the content just not showing?
    If there are no message could you try setting the https://codex.wordpress.org/WP_DEBUG in your config?
    If we can find some more details I might be able to reproduce it.

Viewing 15 replies - 1 through 15 (of 27 total)
1 2
  • The topic ‘Can’t Find H5P-Content’ is closed to new replies.