Error in database when trying to download any activity
We have a Moodle platform in version 3.1.1 (Build: 20160711). The 2017031300 version of the H5P plugin has been installed. It is a very powerful plugin to which you can draw a lot of performance to the activities within the courses of the platform. We have detected an error that occurs over any type of content that has been created. The problem is when you want to download that activity created in the Moodle platform to take it to other courses, it gives the following error in Moodle debug mode:
Debug info: ERROR: invalid input syntax for integer: "4.h5p" SELECT hc.id , Hc.name , Hc.intro , Hc.introformat , Hc.json_content , Hc.filtered , Hc.slug , Hc.embed_type , Hc.disable , Hl.id AS library_id , Hl.machine_name , Hl.major_version , Hl.minor_version , Hl.embed_types , Hl.fullscreen FROM mdl_hvp hc JOIN mdl_hvp_libraries hl ON hl.id = hc.main_library_id WHERE hc.id = $ 1 [Array ( 0 => '4.h5p', )] Error code: dmlreadexception × Stack trace: Line 474 of /lib/dml/moodle_database.php dml_read_exception thrown Line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database-> query_end () Line 794 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database-> query_end () Line 1527 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database-> get_records_sql () Line 912 of /mod/hvp/classes/framework.php: call to moodle_database-> get_record_sql () Line 288 of /mod/hvp/lib.php: call to mod_hvp \ framework-> loadContent () Line 4609 of /lib/filelib.php: call to hvp_pluginfile () Line 37 of /pluginfile.php: call to file_pluginfile ()
I attached screen shots so that they know exactly where the error occurs.
Thank you very much first of all and congratulations for this wonderful module.