Hi,
I'm actually facing the issue of the plugin never initializing and always saying "None Found" here: http://www.androidpolice.com - I've been working on the site for the last few months and just launched yesterday but the popular post data never got populated.
The wp_popularpostsdata table is empty in the database. Is there any troubleshooting I can do?
Thank you.
I debugged and saw this main SQL statement:
SELECT *, meta_value + 0 AS viewcount FROM wp_posts LEFT JOIN wp_postmeta ON post_id = ID WHERE meta_key = 'pvc_views' AND post_status IN ('publish') AND post_type='post' AND post_password ='' AND (post_date >= DATE_SUB(CURDATE(), INTERVAL 2 year) OR post_type='page') ORDER BY viewcount DESC LIMIT 0, 5;
The problem is, wp_postmeta has no meta_key with the value pvc_views, or pvcANYTHING. This is why it's failing. I reactivated the plugin but the value didn't appear.
Note that I never added any calls to popular_posts_views() anywhere as instructions don't say to do so. Looking into this further.
In short, the problem was a permission on the plugin dir wasn't allowing writes. pvctracker.php and pvctracker.js were generated with something like dev.SERVER.com during development and apache was never able to modify them when I went live.
Maybe a check on the dir permission is due as I spent quite a bit of time on this.
Thanks.
Artem
http://AndroidPolice.com
http://beerpla.net
http://twitter.com/ArtemR
This topic has been closed to new replies.
