Error Unknown storage engine ‘InnoDB’ database

Hi @b_dark,

Error Unknown storage engine ‘InnoDB’ database

This means that the InnoDB storage engine is either not available in your server or that your hosting has disabled it. WPP requires having InnoDB available in order to function correctly.

Please get in touch with your hosting and ask them if it’s possible to enable the InnoDB engine. If the answer is no, you may want to consider migrating your site to another hosting (and not just because you can’t use my plugin on your site but also because InnoDB is pretty much standard nowadays).

If there’s anything else I could help with, don’t hesitate to ask.

i don’t have any skip-innodb on /etc/my.cnf

i disbled, delete and enable again and i get this:
<pr>text/x-generic php_error_log ( ASCII text, with very long lines, with CRLF, LF line terminators )
[21-Feb-2018 15:22:39 UTC] WordPress database error Tablespace for table ‘xxxx_dbsp.wp_popularpostsdata‘ exists. Please DISCARD the tablespace before IMPORT. for query
CREATE TABLE wp_popularpostsdata (
postid bigint(20) NOT NULL,
day datetime NOT NULL,
last_viewed datetime NOT NULL,
pageviews bigint(20) DEFAULT 1,
PRIMARY KEY (postid)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE=InnoDB made by activate_plugin, do_action(‘activate_wordpress-popular-posts/wordpress-popular-posts.php’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPP_Activator::activate, WPP_Activator::plugin_activate, WPP_Activator::do_db_tables, dbDelta
[21-Feb-2018 15:22:39 UTC] WordPress database error Tablespace for table ‘xxxx_dbsp.wp_popularpostssummary‘ exists. Please DISCARD the tablespace before IMPORT. for query
CREATE TABLE wp_popularpostssummary (
ID bigint(20) NOT NULL AUTO_INCREMENT,
postid bigint(20) NOT NULL,
pageviews bigint(20) NOT NULL DEFAULT 1,
view_date date NOT NULL,
view_datetime datetime NOT NULL,
PRIMARY KEY (ID),
KEY postid (postid),
KEY view_date (view_date),
KEY view_datetime (view_datetime)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE=InnoDB made by activate_plugin, do_action(‘activate_wordpress-popular-posts/wordpress-popular-posts.php’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPP_Activator::activate, WPP_Activator::plugin_activate, WPP_Activator::do_db_tables, dbDelta
[21-Feb-2018 15:22:52 UTC] WordPress database error Table ‘xxxx_dbsp.wp_popularpostssummary’ doesn’t exist for query SELECT p.ID AS id, p.post_title AS title, p.post_author AS uid FROM wp_popularpostssummary v LEFT JOIN wp_posts p ON v.postid = p.ID WHERE 1 = 1 AND p.post_type IN(‘post’, ”) AND v.view_datetime > DATE_SUB(‘2018-02-21 17:22:52’, INTERVAL 24 HOUR) AND p.post_password = ” AND p.post_status = ‘publish’ GROUP BY v.postid ORDER BY SUM(v.pageviews) DESC LIMIT 5 OFFSET 0; made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/child/single.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/child/sidebar.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WPP_Widget->widget, WPP_Widget->get_popular, WPP_Query->__construct, WPP_Query->run_query</pr>

• This reply was modified 6 years, 9 months ago by Be Dark.
• This reply was modified 6 years, 9 months ago by Be Dark.

Hey @b_dark,

Regarding this:

Tablespace for table xxxx_dbsp.wp_popularpostsdata exists. Please DISCARD the tablespace before IMPORT.

You might want to read this.

Update:

You’ll also want to check this.

• This reply was modified 6 years, 9 months ago by Hector Cabrera.