[WordPress Popular Posts plug-in] 0 views stats in any date range

Hi @bahns,

Please read this FAQ: I’m getting “Sorry. No data so far”. What’s up with that?

If you’re still having issues getting WPP to work on your site after following those suggestions/recommendations please share your site’s URL so I can have a look.

I’ve tried clear all caches then turn off the cache plug-in and wp optimize plugin, but Popular Posts plugin not worked either.
And there is no minification in my site.
I think REST works in my site.

# Data Settings #
Data Log views: Everyone
Log limit: Disabled
Ajaxify widget: Enabled
Data Caching: Never cache
Data Sampling: Disabled

my site address is bahns.net

I’ve removed Jetpack for some reasons(realted post thumbnail url error) just before installing Popular Posts.

Hmm..
I checked the database and found that there is no popularpostsdata, popularpostssummary table in my DB.
Please let me know what should I do next.
Thanks.

• This reply was modified 4 years, 1 month ago by bahns.
• This reply was modified 4 years, 1 month ago by bahns.
• This reply was modified 4 years, 1 month ago by bahns.

I’m getting a 403 forbidden error message when I check your website so I can’t see what’s going on there ??

However, your mention of the WP Optimize plugin helps. Have a look at this FAQ, pay special attention to the first bullet: Is WordPress Popular Posts compatible with plugins that minify/bundle JavaScript code?

Hello,
I’ve checked the database and found that there is no popularpostsdata, popularpostssummary table in my DB.
Please let me know what should I do next.

BTW, What is your IP Address(range)?
I think my host-provider blocked foreign IPs for security reason.

I checked the database and found that there is no popularpostsdata, popularpostssummary table in my DB.

Oh, that’s not good @bahns. The plugin should have created these tables on activation.

You can try creating them manually via phpmyadmin for example.

To create the popularpostsdata table:

CREATE TABLE IF NOT EXISTS wp_popularpostsdata (
   postid bigint(20) NOT NULL,
   day datetime NOT NULL,
   last_viewed datetime NOT NULL,
   pageviews bigint(20) DEFAULT '1',
   PRIMARY KEY (postid),
   UNIQUE KEY id (postid)
) ENGINE=InnoDB;

To create the popularpostssummary table:

CREATE TABLE IF NOT EXISTS 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)
) ENGINE=InnoDB;

You may need to replace the wp_ prefix with the one your site uses so make sure to double check before running these queries. If your site uses the default wp_ prefix then you can run these queries as is.

Thanks.
I’ve created 2 tables by manual as your guide, then it works!
But I am not sure why this plugin could not create 2 tables, since I had no problem with other plugins.

No idea either. It’s a rare issue that has been reported by a few people (you’d be like the 4th or 5th person person to report this in over 12 years of development) but so far I haven’t been able to reproduce the problem since the plugin installs just fine on every setup I have tried.