Database tables are not installed

Hi @umchal,

Try checking MySQL’s error log to see if something happened when WPP attempted to create its database tables. You may also want to have a look at WordPress’ Debug Log, although in my experience it rarely shows any info on table creation/modification errors.

Alternatively:

• Make sure your database user has enough permissions to create and alter tables (although if you were able to install -not import an existing database- WordPress locally I guess it does have said permissions but it won’t hurt to check), or
• Try running the queries manually (adjust where needed, read the code in detail), or
• Export both the _popularpostsdata and the _popularpostssummary tables from one of your sites, import them into your local database, and truncate them so they’re clean for your local site.

After enabling the debug mode, I get the following in the debug.log.

[04-Dec-2019 17:13:37 UTC] WordPress database error Unknown storage engine 'InnoDB' 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, WordPressPopularPosts\Activation\Activator::activate, WordPressPopularPosts\Activation\Activator::plugin_activate, WordPressPopularPosts\Activation\Activator::do_db_tables, dbDelta
[04-Dec-2019 17:13:37 UTC] WordPress database error Unknown storage engine 'InnoDB' 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, WordPressPopularPosts\Activation\Activator::activate, WordPressPopularPosts\Activation\Activator::plugin_activate, WordPressPopularPosts\Activation\Activator::do_db_tables, dbDelta

mysql_error.log does not show any log related to it.

OK, solved.

There was a line in the MySQL configuration file.

skip-innodb

Changed it to

#skip-innodb

And restarted the MySQL service. Then reinstalled the plugin. Now I see the two tables created.

Thank you.

This is the problem:

Unknown storage engine ‘InnoDB’

Your local database server may not be properly configured as the InnoDB engine is not available or it has been disabled. How to fix that is a bit out of my area of expertise but I’d start by checking MariaDB’s config files and debug from there.

Edit: ah, I see you were able to figure it out while I was typing this comment haha. Good work!

• This reply was modified 5 years, 3 months ago by Hector Cabrera.

Suggestions: maybe, in a future version, 1. add a check if the server supports InnoDB upon installation. 2. in the stats page, show a notification to tell the user that the necessary tables are do not exist for such cases.

I suggest these because this way, it prevents those who failed to installed the plugin properly like I did from spending too much time figuring out what’s going on. Currently, the user has too little clues.

I hope you consider it. Thank you.

Sure thing, thanks for the suggestions!