"not content types available" ->no tables created on plugin install

[dankon7goo]

I just use

• H5P actual version on wordpress 4.92, Php 7 CGI/FPM
• necessary libraries in php 7 included

tried to install plugin via gui in Wordpress backend , tried plugin install via ftp

Not able to install new content., here what gui says

No content types are available

Your site is having difficulties connecting to H5P.org and listing the available content type

I already spent hours for this, ist there any possiblity to send a few links , explanations. ....suppose Database was not generated, i don´t know for what reason? i just set up a php logfile which is filled with the Lines beneath:

[22-Mar-2018 21:19:12 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_contents' doesn't exist für Abfrage SELECT hc.title AS title, hl.title AS content_type, u.display_name AS user_name, GROUP_CONCAT(DISTINCT CONCAT(t.id,',',t.name) ORDER BY t.id SEPARATOR ';') AS tags, hc.updated_at AS updated_at, hc.id AS id, u.ID AS user_id, hl.name AS content_type_id FROM wp_h5p_contents hc LEFT JOIN wp_h5p_libraries hl ON hl.id = hc.library_id LEFT JOIN wp_users u ON hc.user_id = u.ID LEFT JOIN wp_h5p_contents_tags ct ON ct.content_id = hc.id LEFT JOIN wp_h5p_tags t ON ct.tag_id = t.id LEFT JOIN wp_h5p_contents_tags ct2 ON ct2.content_id = hc.id

  GROUP BY hc.id
   ORDER BY hc.updated_at DESC
   LIMIT 0, 20 von do_action('wp_ajax_h5p_contents'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_contents, H5PContentQuery->get_rows

[22-Mar-2018 21:19:12 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_contents' doesn't exist für Abfrage SELECT COUNT(DISTINCT hc.id) FROM wp_h5p_contents hc LEFT JOIN wp_h5p_libraries hl ON hl.id = hc.library_id LEFT JOIN wp_users u ON hc.user_id = u.ID LEFT JOIN wp_h5p_contents_tags ct ON ct.content_id = hc.id LEFT JOIN wp_h5p_tags t ON ct.tag_id = t.id LEFT JOIN wp_h5p_contents_tags ct2 ON ct2.content_id = hc.id von do_action('wp_ajax_h5p_contents'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_contents, H5PContentQuery->get_total [22-Mar-2018 21:19:17 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_libraries' doesn't exist für Abfrage SELECT hl4.id, hl4.name AS machine_name, hl4.title, hl4.major_version, hl4.minor_version, hl4.patch_version, hl4.restricted, hl4.has_icon FROM (SELECT hl2.name, hl2.major_version, MAX(hl2.minor_version) AS minor_version FROM (SELECT hl.name, MAX(hl.major_version) AS major_version FROM wp_h5p_libraries hl WHERE hl.runnable = 1 GROUP BY hl.name) hl1 JOIN wp_h5p_libraries hl2 ON hl1.name = hl2.name AND hl1.major_version = hl2.major_version GROUP BY hl2.name, hl2.major_version) hl3 JOIN wp_h5p_libraries hl4 ON hl3.name = hl4.name AND hl3.major_version = hl4.major_version AND hl3.minor_version = hl4.minor_version von do_action('wp_ajax_h5p_content-type-cache'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_type_cache, H5PEditorAjax->action, H5PEditorAjax->getContentTypeCache, H5peditor->getLatestGlobalLibrariesData, H5PEditorWordPressAjax->getLatestLibraryVersions [22-Mar-2018 21:19:17 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist für Abfrage SELECT FROM wp_h5p_libraries_hub_cache von do_action('wp_ajax_h5p_content-type-cache'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_type_cache, H5PEditorAjax->action, H5PEditorAjax->getContentTypeCache, H5peditor->getLatestGlobalLibrariesData, H5peditor->getUserSpecificContentTypeCache, H5PEditorWordPressAjax->getContentTypeCache [22-Mar-2018 21:19:17 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_events' doesn't exist für Abfrage SELECT library_name, max(created_at) AS max_created_at FROM wp_h5p_events WHERE type='content' AND sub_type = 'create' AND user_id = 4 GROUP BY library_name ORDER BY max_created_at DESC von do_action('wp_ajax_h5p_content-type-cache'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_type_cache, H5PEditorAjax->action, H5PEditorAjax->getContentTypeCache, H5PEditorWordPressAjax->getAuthorsRecentlyUsedLibraries [22-Mar-2018 21:19:20 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_libraries' doesn't exist für Abfrage SELECT hl4.id, hl4.name AS machine_name, hl4.title, hl4.major_version, hl4.minor_version, hl4.patch_version, hl4.restricted, hl4.has_icon FROM (SELECT hl2.name, hl2.major_version, MAX(hl2.minor_version) AS minor_version FROM (SELECT hl.name, MAX(hl.major_version) AS major_version FROM wp_h5p_libraries hl WHERE hl.runnable = 1 GROUP BY hl.name) hl1 JOIN wp_h5p_libraries hl2 ON hl1.name = hl2.name AND hl1.major_version = hl2.major_version GROUP BY hl2.name, hl2.major_version) hl3 JOIN wp_h5p_libraries hl4 ON hl3.name = hl4.name AND hl3.major_version = hl4.major_version AND hl3.minor_version = hl4.minor_version von do_action('wp_ajax_h5p_content-type-cache'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_type_cache, H5PEditorAjax->action, H5PEditorAjax->getContentTypeCache, H5peditor->getLatestGlobalLibrariesData, H5PEditorWordPressAjax->getLatestLibraryVersions [22-Mar-2018 21:19:20 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist für Abfrage SELECT FROM wp_h5p_libraries_hub_cache von do_action('wp_ajax_h5p_content-type-cache'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_type_cache, H5PEditorAjax->action, H5PEditorAjax->getContentTypeCache, H5peditor->getLatestGlobalLibrariesData, H5peditor->getUserSpecificContentTypeCache, H5PEditorWordPressAjax->getContentTypeCache [22-Mar-2018 21:19:20 UTC] WordPress-Datenbank-Fehler Table 'd009bfe3.wp_h5p_events' doesn't exist für Abfrage SELECT library_name, max(created_at) AS max_created_at FROM wp_h5p_events WHERE type='content' AND sub_type = 'create' AND user_id = 4 GROUP BY library_name ORDER BY max_created_at DESC von do_action('wp_ajax_h5p_content-type-cache'), WP_Hook->do_action, WP_Hook->apply_filters, H5PContentAdmin->ajax_content_type_cache, H5PEditorAjax->action, H5PEditorAjax->getContentTypeCache, H5PEditorWordPressAjax->getAuthorsRecentlyUsedLibraries

[icc]

Have you tried to deactivate and activate it again, and completely delete it? If that doesn't work the problem can be some special setup on your WordPress site or a conflict between plugins. If you are using a vanilla WordPress the problem is most likely with the web server setup. The error messages above doesn't really tell what's wrong.

Be sure that the following line is enabled(true) in your wp-config.php file before you try to reinstall:

define('WP_DEBUG', true);

Also, after that line add the following to filter away any garbage:

error_reporting(E_ERROR | E_WARNING | E_PARSE);

This should ensure that any errors during the install process is printed. You should also check your web server's error_log file after the reinstall in case something ended up there.

Let me know how it goes, hopefully, you'll catch the error message that can tell us what's wrong.

[dankon7goo]

Okay thank you for the advise. What i did now:

• deactivated & deinstalled h5p Plugin via GUI of Wordpress
• added the lines above to wp-config.php

Now plugin activated: not working,

• after activation , message on activation screen

  "plugin genreated 21581 unexpected Character (!) on activation" GROSS!!! -> i guess it´s similar to this related search ** but i already have set up a log which logs these characters, but won´t post them here as inlay for better reading So at this point i realize i have problems. Hopefully not big ones.. But unfortunetly i try to use h5p buttons

• on click "new H5P Content": nothing happens
• on clicl "new" -> "loading :type , please wait.
• on click "library"/ german language verison located "bibliothek ->

WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_contents' doesn't exist] SELECT COUNT(id) FROM wp_h5p_contents WHERE filtered = ''

WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries' doesn't exist] SELECT id, name, title, major_version, minor_version, patch_version, runnable, restricted FROM wp_h5p_libraries ORDER BY title ASC, major_version ASC, minor_version ASC

... So to sum up : nothing works. But i guess it´s related to my some more systemic variables , or as you say "special setup" - i just tried with php 7 to get your really nice h5p to work... Same problems with php 5.6... So i uninstall again the H5P Plugin via Wordpress GUI:

• after trying deinstallng H5P Plugin via Wordpress "plugin uninstall" / GUI: no success in deletin plugin:

Löschen fehlgeschlagen: WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_contents' doesn't exist] SELECT COUNT(DISTINCT user_id) FROM wp_h5p_contents WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries' doesn't exist]SELECT id, name, title, major_version, minor_version, patch_version, runnable, restricted FROM wp_h5p_libraries ORDER BY title ASC, major_version ASC, minor_version ASCWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_contents' doesn't exist] SELECT l.name, l.major_version, l.minor_version, COUNT(*) AS count FROM wp_h5p_contents c, wp_h5p_libraries l WHERE c.library_id = l.id GROUP BY l.name, l.major_version, l.minor_version WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_counters' doesn't exist] SELECT library_name AS name, library_version AS version, num FROM wp_h5p_counters WHERE type = 'library' WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_counters' doesn't exist] SELECT library_name AS name, library_version AS version, num FROM wp_h5p_counters WHERE type = 'content create' WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_counters' doesn't exist] SELECT library_name AS name, library_version AS version, num FROM wp_h5p_counters WHERE type = 'content create upload' WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_counters' doesn't exist] SELECT library_name AS name, library_version AS version, num FROM wp_h5p_counters WHERE type = 'content delete' WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_counters' doesn't exist] SELECT library_name AS name, library_version AS version, num FROM wp_h5p_counters WHERE type = 'results content' WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_counters' doesn't exist] SELECT library_name AS name, library_version AS version, num FROM wp_h5p_counters WHERE type = 'content shortcode insert' WordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]TRUNCATE TABLE wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Table 'd009bfe3.wp_h5p_libraries_hub_cache' doesn't exist]SHOW FULL COLUMNS FROM wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_libraries_hub_cache']DROP TABLE wp_h5p_libraries_hub_cacheWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_contents']DROP TABLE wp_h5p_contentsWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_contents_libraries']DROP TABLE wp_h5p_contents_librariesWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_contents_user_data']DROP TABLE wp_h5p_contents_user_dataWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_contents_tags']DROP TABLE wp_h5p_contents_tagsWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_tags']DROP TABLE wp_h5p_tagsWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_results']DROP TABLE wp_h5p_resultsWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_libraries']DROP TABLE wp_h5p_librariesWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_libraries_libraries']DROP TABLE wp_h5p_libraries_librariesWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_libraries_languages']DROP TABLE wp_h5p_libraries_languagesWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_libraries_cachedassets']DROP TABLE wp_h5p_libraries_cachedassetsWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_counters']DROP TABLE wp_h5p_countersWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_events']DROP TABLE wp_h5p_eventsWordPress-Datenbank-Fehler: [Unknown table 'd009bfe3.wp_h5p_tmpfiles']DROP TABLE wp_h5p_tmpfiles{"success":true,"data":{"delete":"plugin","slug":"h5p","plugin":"h5p\/h5p.php","pluginName":"H5P"}}7

Im Sorry , i suppose it a problem with my permanent wordpress installation / Database as you just said. Perhaps anyone has any generic suggestions or internet ressources for troubleshooting?

[icc]

If you get the "plugin generated unexpected characters" message it's safe to assume that something is broken and that content creation and uninstall won't work. You need to get a hold of the "unexpected characters" message that is generated when activating.