You suggested making a couple of edits to get the most popular posts by page view/hit to show in the recent global posts widget:
(1) changing the 0 to 1 in post-indexer plugin here: $post_indexer_enable_hit_tracking = '0'; //Either '1' or '0' - resource heavy
and (2) changing the query in the recent global posts widget to ORDER BY post_hits DESC
I've done both but the widget isn't displaying the results. I clicked on a bunch of posts myself to test this. Have there been any changes in either plugin since you posted those instructions last June? Or can you think of any reason or anything else I need to enable/check?
I know you guys are working on a plugin to do this right now and I'm eagerly anticipating it's release.
You suggested making a couple of edits to get the most popular posts by page view/hit to show in the recent global posts widget:
(1) changing the 0 to 1 in post-indexer plugin here: $post_indexer_enable_hit_tracking = '0'; //Either '1' or '0' - resource heavy
and (2) changing the query in the recent global posts widget to ORDER BY post_hits DESC
I've done both but the widget isn't displaying the results. I clicked on a bunch of posts myself to test this. Have there been any changes in either plugin since you posted those instructions last June? Or can you think of any reason or anything else I need to enable/check?
I know you guys are working on a plugin to do this right now and I'm eagerly anticipating it's release.
@aaron, well that's a great question (one I should've figured out b4 I asked my question) :). There's no post_hits column in wp_site_posts table. It's been a while since I've done any db work, would you be able to help me with the SQL to create that column?
The whole "hit tracking" thing has never really been tested and there are no plans to use it for anything. At one point I was just going to remove it but a few people claimed to be using it so it was left in. It's most definitely a "use at your own risk" type thing.
Responses (5)
Lead Developer — 21st May 2010 (2 years ago) #
Are stats being added to the post_hits column of site_posts db table?
Member — 21st May 2010 (2 years ago) #
@aaron, well that's a great question (one I should've figured out b4 I asked my question) :). There's no post_hits column in wp_site_posts table. It's been a while since I've done any db work, would you be able to help me with the SQL to create that column?
Thanks,
Ricky
Erstwhile founder — 21st May 2010 (2 years ago) #
Hiya,
The whole "hit tracking" thing has never really been tested and there are no plans to use it for anything. At one point I was just going to remove it but a few people claimed to be using it so it was left in. It's most definitely a "use at your own risk" type thing.
Thanks,
Andrew
Lead Developer — 21st May 2010 (2 years ago) #
And it's an extra query or 2 on every page load, as well as being incompatible with the more popular caching plugins out there.
Member — 21st May 2010 (2 years ago) #
drats! oh well i will patiently await your upcoming plugin then.
cheers
Become a member