Error During Database reading Moodle
Submitted by r.consalvo on Tue, 12/08/2020 - 12:16
Hi everyone,
i am not able to run h5p plugin. I am on moodle 3.9 and when i try to add a new resource to my course, an error on database appears.
If i try to add a h5p file manually, the server response me that there is NO h5p table in DB.
If i try to add by deposit of contents, there are several error linked to DB.
How can i solve this? Thanks for the support.
Informazioni di debug: Table 'ckgLCjmda5s0.mdl_h5p_libraries' doesn't existSELECT hl2.id, hl2.machinename as machine_name, hl2.title, hl2.majorversion as major_version,
hl2.minorversion AS minor_version, hl2.patchversion as patch_version, '' as has_icon, 0 as restricted
FROM mdl_h5p_libraries hl2
LEFT JOIN mdl_h5p_libraries hl1
ON hl1.machinename = hl2.machinename
AND (hl2.majorversion < hl1.majorversion
OR (hl2.majorversion = hl1.majorversion
AND hl2.minorversion < hl1.minorversion)
)
WHERE hl2.runnable = 1
AND hl1.majorversion is null
ORDER BY hl2.title
[array (
)]
Error code: dmlreadexceptionStack trace:
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1273 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 66 of /h5p/classes/editor_ajax.php: call to mysqli_native_moodle_database->get_records_sql()
- line 146 of /contentbank/contenttype/h5p/classes/contenttype.php: call to core_h5p\editor_ajax->getLatestLibraryVersions()
- line 132 of /contentbank/classes/output/bankcontent.php: call to contenttype_h5p\contenttype->get_contenttype_types()
- line 107 of /contentbank/classes/output/bankcontent.php: call to core_contentbank\output\bankcontent->export_tool_add()
- line 238 of /lib/outputrenderers.php: call to core_contentbank\output\bankcontent->export_for_template()
- line 115 of /contentbank/index.php: call to renderer_base->render()