Unknown operation: DEFAULT CHARACTER SET #144
Comments
|
Link to recreate issue: https://playground.wordpress.net/?networking=yes&plugin=h5p The error comes from missing SQLite plugin features. Full error: |
bgrgicak
changed the title
|
Thank you for reporting this issue @eLearningTechie!
When I tested the plugin I wasn't able to install it because of the SQL error. How are you able to install the plugin? |
|
Dunno, with my browser (Chrome 126.0.6478.222) set to local storage and network access granted, I got this far:
I only run into problems at the point where full-fat WP loads the external H5P hub / editor interface: Playground throws a blank My regular self-hosted WP looks like this Something is preventing communications between the Playground WP and the H5P hubsite where the H5P editor lives. This is the entire console log from this morning's retry: [13-Aug-2024 08:59:17 UTC] WordPress database error MySQL query: ALTER TABLE `wp_h5p_contents` DEFAULT CHARACTER SET utf8mb4 Queries made or created this session were:
Error occurred at line 3939 in Function
handle_error. Error message was: Unknown operation: DEFAULT CHARACTER SET.
Backtrace: #0 /internal/shared/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(287): WP_SQLite_Translator->get_error_message()
#1 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(563): WP_SQLite_DB->query('ALTER TABLE `wp...')
#2 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(473): H5P_Plugin::upgrade_120()
#3 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(152): H5P_Plugin::check_for_updates()
#4 /wordpress/wp-includes/class-wp-hook.php(3): H5P_Plugin::activate(false)
#5 /wordpress/wp-includes/class-wp-hook.php(3): WP_Hook->apply_filters('', Array)
#6 /wordpress/wp-includes/plugin.php(2): WP_Hook->do_action(Array)
#7 /wordpress/wp-admin/includes/plugin.php(2): do_action('activate_h5p/h5...', false)
#8 /wordpress/wp-admin/plugins.php(2): activate_plugin('h5p/h5p.php', 'https://playgro...', false)
#9 {main}
for query ALTER TABLE `wp_h5p_contents` DEFAULT CHARACTER SET utf8mb4 made by activate_plugin, do_action('activate_h5p/h5p.php'), WP_Hook->do_action, WP_Hook->apply_filters, H5P_Plugin::activate, H5P_Plugin::check_for_updates, H5P_Plugin::upgrade_120, WP_SQLite_DB->query, WP_SQLite_DB->print_error
[13-Aug-2024 08:59:17 UTC] WordPress database error MySQL query: ALTER TABLE `wp_h5p_contents_libraries` DEFAULT CHARACTER SET utf8mb4 Queries made or created this session were:
Error occurred at line 3939 in Function
handle_error. Error message was: Unknown operation: DEFAULT CHARACTER SET.
Backtrace: #0 /internal/shared/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(287): WP_SQLite_Translator->get_error_message()
#1 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(564): WP_SQLite_DB->query('ALTER TABLE `wp...')
#2 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(473): H5P_Plugin::upgrade_120()
#3 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(152): H5P_Plugin::check_for_updates()
#4 /wordpress/wp-includes/class-wp-hook.php(3): H5P_Plugin::activate(false)
#5 /wordpress/wp-includes/class-wp-hook.php(3): WP_Hook->apply_filters('', Array)
#6 /wordpress/wp-includes/plugin.php(2): WP_Hook->do_action(Array)
#7 /wordpress/wp-admin/includes/plugin.php(2): do_action('activate_h5p/h5...', false)
#8 /wordpress/wp-admin/plugins.php(2): activate_plugin('h5p/h5p.php', 'https://playgro...', false)
#9 {main}
for query ALTER TABLE `wp_h5p_contents_libraries` DEFAULT CHARACTER SET utf8mb4 made by activate_plugin, do_action('activate_h5p/h5p.php'), WP_Hook->do_action, WP_Hook->apply_filters, H5P_Plugin::activate, H5P_Plugin::check_for_updates, H5P_Plugin::upgrade_120, WP_SQLite_DB->query, WP_SQLite_DB->print_error
[13-Aug-2024 08:59:17 UTC] WordPress database error MySQL query: ALTER TABLE `wp_h5p_results` DEFAULT CHARACTER SET utf8mb4 Queries made or created this session were:
Error occurred at line 3939 in Function
handle_error. Error message was: Unknown operation: DEFAULT CHARACTER SET.
Backtrace: #0 /internal/shared/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(287): WP_SQLite_Translator->get_error_message()
#1 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(565): WP_SQLite_DB->query('ALTER TABLE `wp...')
#2 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(473): H5P_Plugin::upgrade_120()
#3 /wordpress/wp-content/plugins/h5p/public/class-h5p-plugin.php(152): H5P_Plugin::check_for_updates()
#4 /wordpress/wp-includes/class-wp-hook.php(3): H5P_Plugin::a
2VM213 jquery-migrate.min.js:2 JQMIGRATE: Migrate is installed, version 3.4.1
config-40887e56.js:1 [13-Aug-2024 08:59:44 UTC] WordPress database error
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
WordPress Playground could be very useful for educators and their students.
One interactive content plugin we use a lot in our learning management systems (e.g. Moodle) is the H5P editor (https://h5p.org/wordpress). I have tried using it on Playground, but even though the plugin installs just fine, the editor then fails to load. I suspect it's unable to connect to the H5P hub for some reason and thus can't retrieve the activity types.
The education community would be super grateful if someone could look into this and get it to work.
The text was updated successfully, but these errors were encountered: