h5p / h5p-wordpress-plugin

Adds support for H5P Content in WordPress.
https://wordpress.org/plugins/h5p/
71 stars 74 forks source link

Error Populating Logs #67

Closed mrjarbenne closed 6 years ago

mrjarbenne commented 6 years ago

This error is filling up our logs recently. Any ideas what might be the cause?

[04-Mar-2018 23:58:45 UTC] WordPress database error Table 'databasename.wp_h5p_libraries_hub_cache' doesn't exist for query SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cache made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, H5P_Plugin->get_library_updates, H5PCore->fetchLibrariesMetadata, H5PCore->updateContentTypeCache, H5PWordPress->replaceContentTypeCache

icc commented 6 years ago

Have you checked in your database to see if the table exists? The table should have been created automatically when you upgraded or installed the plugin.

mrjarbenne commented 6 years ago

Very strange. The table exists, but according to the mySQL command line it didn’t.

We fixed this by running "DROP TABLE wp_h5p_libraries_hub_cache" and then re-running H5P's update database routine.

Seems to be good now. I’ll monitor.