Interactive Content – H5P

Hi Cristian, this is an international board, so please post in English. For your question, httpswwwroot should always be the same as wwwroot, is there any reason why they are different on your setup ? Also, please post any further questions on the H5P.org forum ( https://h5p.org/forum/10 ), which is better suited for support tickets. Thanks.

Hi Kaspar, what version of H5P are you using ? Make sure you're using the 1.2 version or higher as it introduced great performance enhancements to the "import" logic of H5P, which I believe is what sharing cart is using. You say that putting an H5P activity in your cart takes 5 minutes, I believe sharing cart could improve their logic here by only doing the "importing" when all items are chosen, which would increase the performance greatly. H5P is also inherently quite slow at importing courses because content types has to be copied with all connected libraries in order to work as a standalone package. If you have any further questions please post them at the h5p.org forums ( https://h5p.org/forum ) which is a better suited medium for support tickets. Thanks.

We have a problem with h5p and another plugin - Sharing cart. When we use sharing cart with h5p then the sharing functionality is extremely slow (like 5 minutes to put a H5P activity in your cart. All other activities are imported and shared without problem, so it's the combination between sharing cart and H5P that causes trouble.
I don't know if the issue is with H5P or Sharing cart ...

Hi, your previously installed H5P plugin has not been cleaned up properly, so there are still tables with H5P data left in your database.
H5P expects these tables to not be defined so you need to backup any old data you have in these tables if you want to keep the data, then remove the tables specified in the error message (mdl_hvp, mdl_hvp_content, mdl_hvp_libraries, mdl_hvp_libraries_languages, mdl_hvp_libraries_cachedassets, etc.) and then try to install H5P again.
​Best regards, Thomas

Hello. I am getting an error when installing.
Debug info: Table 'mdl_hvp' already exists
CREATE TABLE mdl_hvp (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
intro LONGTEXT COLLATE utf8mb4_general_ci,
introformat SMALLINT(4) NOT NULL DEFAULT 0,
json_content LONGTEXT COLLATE utf8mb4_general_ci NOT NULL,
embed_type VARCHAR(127) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
disable BIGINT(10) NOT NULL DEFAULT 0,
main_library_id BIGINT(10) NOT NULL,
content_type VARCHAR(127) COLLATE utf8mb4_general_ci,
author VARCHAR(127) COLLATE utf8mb4_general_ci,
license VARCHAR(7) COLLATE utf8mb4_general_ci,
meta_keywords LONGTEXT COLLATE utf8mb4_general_ci,
meta_description LONGTEXT COLLATE utf8mb4_general_ci,
filtered LONGTEXT COLLATE utf8mb4_general_ci,
slug VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Activity data'
;
CREATE TABLE mdl_hvp_content_user_data (
id BIGINT(10) NOT NULL auto_increment,
user_id BIGINT(10) NOT NULL,
hvp_id BIGINT(10) NOT NULL,
sub_content_id BIGINT(10) NOT NULL,
data_id VARCHAR(127) COLLATE utf8mb4_general_ci,
data LONGTEXT COLLATE utf8mb4_general_ci,
preloaded TINYINT(1) NOT NULL,
delete_on_content_change TINYINT(1) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Stores user data about the content'
;
CREATE TABLE mdl_hvp_libraries (
id BIGINT(10) NOT NULL auto_increment,
machine_name VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
title VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
major_version SMALLINT(4) NOT NULL,
minor_version SMALLINT(4) NOT NULL,
patch_version SMALLINT(4) NOT NULL,
runnable TINYINT(1) NOT NULL,
fullscreen TINYINT(1) NOT NULL DEFAULT 0,
embed_types VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
preloaded_js LONGTEXT COLLATE utf8mb4_general_ci,
preloaded_css LONGTEXT COLLATE utf8mb4_general_ci,
drop_library_css LONGTEXT COLLATE utf8mb4_general_ci,
semantics LONGTEXT COLLATE utf8mb4_general_ci NOT NULL,
restricted TINYINT(1) NOT NULL DEFAULT 0,
tutorial_url VARCHAR(1000) COLLATE utf8mb4_general_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_hvplibr_macmajminpatrun_ix (machine_name, major_version, minor_version, patch_version, runnable)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Stores information about libraries.'
;
CREATE TABLE mdl_hvp_libraries_libraries (
id BIGINT(10) NOT NULL auto_increment,
library_id BIGINT(10) NOT NULL,
required_library_id BIGINT(10) NOT NULL,
dependency_type VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Library dependencies'
;
CREATE TABLE mdl_hvp_libraries_languages (
id BIGINT(10) NOT NULL auto_increment,
library_id BIGINT(10) NOT NULL,
language_code VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
language_json LONGTEXT COLLATE utf8mb4_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Translations for libraries'
;
CREATE TABLE mdl_hvp_libraries_cachedassets (
id BIGINT(10) NOT NULL auto_increment,
library_id BIGINT(10) NOT NULL,
hash VARCHAR(64) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_hvplibrcach_libhas_uix (library_id, hash)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Use to know which caches to clear when a library is updated'
;
CREATE TABLE mdl_hvp_contents_libraries (
id BIGINT(10) NOT NULL auto_increment,
hvp_id BIGINT(10) NOT NULL,
library_id BIGINT(10) NOT NULL,
dependency_type VARCHAR(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
drop_css TINYINT(1) NOT NULL,
weight BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_hvpcontlibr_dro_ix (drop_css)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Store which library is used in which content.'
;
CREATE TABLE mdl_hvp_events (
id BIGINT(10) NOT NULL auto_increment,
user_id BIGINT(10) NOT NULL,
created_at BIGINT(10) NOT NULL,
type VARCHAR(63) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
sub_type VARCHAR(63) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
content_id BIGINT(10) NOT NULL,
content_title VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
library_name VARCHAR(127) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
library_version VARCHAR(31) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Keep track of logged H5P events'
;
CREATE TABLE mdl_hvp_tmpfiles (
id BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='Keep track of files uploaded before content is saved'
;
CREATE TABLE mdl_hvp_counters (
id BIGINT(10) NOT NULL auto_increment,
type VARCHAR(63) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
library_name VARCHAR(127) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
library_version VARCHAR(31) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
num BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_hvpcoun_typliblib_ix (type, library_name, library_version)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='A set of global counters to keep track of H5P usage'
Error code: ddlexecuteerror

Thank you very much Frode.
Your feedback has been decisive.

Hi @Alberto Berarducci,
How did you update the plugin? It looks like not all of your files have been updated successfully.
I double checked the version you get from the 'Download' button and it's running 1.14 of the core component. You can check this manually in the mod/hvp/library/h5p.classes.php file around line 1731.
If you are using Git to update, make sure that you update the submodules as well.

Hi, I've installed last H5P module (v1.5) in a moodle 3.1.6 site, but when I try to update some Content Types (ie. Multiple choice) or add a new one (ie. Course Presentation) I get many error like this:
The system was unable to install the H5P Editor Range List component from the package, it requires a newer version of the H5P plugin. This site is currently running version 1.13, whereas the required version is 1.14 or higher. You should consider upgrading and then try again.
The system was unable to install the H5P Editor Table List component from the package, it requires a newer version of the H5P plugin. This site is currently running version 1.13, whereas the required version is 1.14 or higher. You should consider upgrading and then try again.
I've purged all caches and I've verified to have last version of h5p module, but the errors are still there.
Can you help me?
Thank you very much.
Alberto

Hi @Annick F,
This sounds like a strange bug. You should check the web server/PHP error log to determine the exact cause of this issue.

Hi There,
Thanks for this great plugin. We have an issue where we cannot delete an H5P activity in a moodle course. It looks like it is deleted but when refreshing the page it is still there. Has anybody come accross this before? Many thanks

Hi @Ben Haensel,
Thank you for sharing.
I do agree that this is an issue that should be solved. I've created a ticket for it here: https://h5ptechnology.atlassian.net/browse/HFP-1702

It appears that all gradebook URL point to where a student can see the results of attempting an activity in the case that they have started an attempt. In the case of a quiz activity, the gradebook URL first points to where a student can see their quiz attempt results if they took a quiz. In the case that a student hasn't take a quiz, the student is redirected to where they can begin an attempt on the quiz.
In the case of H5P, I see that there is no redirect from the gradebook link setup to point a student to begin the activity in the case when they haven't attempted that H5P activity. Is this intentional, or a design flaw? Please watch this YouTube walkthrough the issue:
Thanks for any insight! -Ben

Hi Pål
Many thanks. My problem did stem from getting the first ZIP file from GitHub.
All OK now.
Best regards
Peter

Hi Peter,
When I download the plugin from this page, I see no problem when inspecting code. I.e, getLocalization is defined in hvp/library/h5p.classes.php. If you pulled the repo from github, you would also need to checkout the submodules, but I wouldn't recommend fetching the plugin from github.
Please retry with the module found here on moodle.org
Best,
Pål

Hi Thomas
Having upgraded to version 1.5 of the plugin on Moodle 3.2 I now get the error that the function H5PCore::getLocalization() doesn't exist. This is in various places.
I've tried using the ZIP downloads from both this site and GitHub with the same results. An 'fgrep' of the codebase appears to show only one occurrence of the string 'getLocalization' - where the function is called in 'locallib.php'.