Old data not displaying, but is in database cache.

Hi Violet,

The plugin should have migrated the data for you. I posted here a way to migrate the data manually, but you might need to update the queries to set tables names to what you have there.

I only added the query code below, as I already had the wp_popularpostssummary table. That updated the wp_popularpostssummary table which shows as updated in the WordPress Popular Posts stats under “settings” (Oddly under “Stats”, views for the last 24 hours, 7 and 30 days look about right, but All-time shows only today’s stats).

WP_PopularPostsData still only has 5 views from today and only 3 show on the sidebar (I have it set to 30 days/10 views max). Should I run the same query for WP_PopularPostsData as I did for wp_popularpostssummary below?

`INSERT INTO wp_popularpostssummary (postid, pageviews, view_date, last_viewed)
SELECT id, pageviews, day_no_time, day
FROM wp_popularpostsdatacache
GROUP BY day_no_time, id
ORDER BY day_no_time DESC;

RENAME TABLE wp_popularpostsdatacache TO wp_popularpostsdatacache_backup;

… (Oddly under “Stats”, views for the last 24 hours, 7 and 30 days look about right, but All-time shows only today’s stats).

This doesn’t sound right. The All-time table is (as you probably have already figured out by now) wp_popularpostsdata. This table hasn’t been touched in a while, so the statistics should remain the same as in previous versions of the plugin. The only data migrated was from wp_popularpostsdatacache to wp_popularpostssummary, which represents last 24 hours / 7 days / 30 days data.

The wp_popularpostsdata table was empty when you checked it? There was had no data on it?

wp_popularpostsdata only has the data from today, which was the same as wp_popularpostssummary until I ran the query. It sounds like a good idea to do the same sort of query to wp_popularpostsdata as I did with wp_popularpostssummary, but I’m not experienced so I want to procede with caution.

Nope, that query is only to copy data from datacache to summary. It won’t work for data.

The migration process only moved data from wp_popularpostsdatacache to wp_popularpostssummary, and from what you’re saying I understand that the wp_popularpostsdata table only holds entries generated today. That doesn’t make sense.

Do you have a recent backup of your database (you might want to ask your hosting as well)?