Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter archon810

    (@archon810)

    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.

    Thread Starter archon810

    (@archon810)

    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

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin: Popular Posts] Stuck at “None Found”’ is closed to new replies.