lokety

@ebiven:

I observed the same upgrade plugin issue as these guys above, but I managed to get it activated and behaving OK.

I noticed that I do have records in wp_recently_popular table but WP Tuner showed the following sql error:

SELECT rp.hits AS hits, rp.post_id AS post_id, p.post_title AS post_title, p.post_date AS post_date, u.display_name AS display_name, u.user_url AS user_url, t.name AS category FROM ( SELECT COUNT(post_id) AS hits, MIN(ts) AS ts, MIN(user_type) AS user_type, MIN(post_id) AS post_id FROM wp_recently_popular WHERE ts > (CURRENT_TIMESTAMP() – INTERVAL 7 DAY) GROUP BY post_id ORDER BY hits DESC ) AS rp LEFT JOIN wp_posts AS p ON rp.post_id = p.ID LEFT JOIN wp_users AS u ON p.post_author = u.ID LEFT JOIN wp_term_relationships AS tr ON p.ID = tr.object_id LEFT JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN wp_terms AS t ON tt.term_id = t.term_id WHERE 1 AND rp.user_type = 1 AND p.post_type = ‘post’ GROUP BY rp.post_id ORDER BY rp.hits DESC, rp.ts DESC LIMIT 10

Error in query:
Can’t group on ‘post_id’

My guess the ‘group by’ and ‘order by’ don’t match, so records are returned anyway.

Hope this helps you fix our “stats reset” problem.