Not sorting by views correctly

Hi there!

So the plugin is functioning fine, it counts the views correctly, but for some reason it sometime sorts my popular post list incorrectly such that posts with fewer views are above everything ells. It keeps that way no matter how much I visit the other posts, like the sorting function is frozen. It works fine for some time when I reset the cache, but after a while it gets frozen again.

A screenshot of this would help. Also, are you using a caching plugin (eg. W3TC)?

A side question; is it possible for the plugin to not count views for the same visitor multiple times?

Unfortunately, no. The plugin will register every pageview – even from the same visitor.

Can’t provide you with a screenshot atm since I just cleared my cache to make the plugin run smooth again. WIll keep this thread alive to keep you informed if the bug(?) persist.

Unfortunately, no. The plugin will register every pageview – even from the same visitor.

Is this something you will look to in the future? – Without the great knowledge of scripting/writing plugins it seems like your feature “WP popular rating” has this kind of option(only members can vote).

Can’t provide you with a screenshot atm since I just cleared my cache to make the plugin run smooth again. WIll keep this thread alive to keep you informed if the bug(?) persist.

Alright then, please keep me posted.

Is this something you will look to in the future? – Without the great knowledge of scripting/writing plugins it seems like your feature “WP popular rating” has this kind of option(only members can vote).

Just to clarify, the rating feature is handled entirely by Lester Chan’s WP-PostRatings plugin – including user verification. WPP only adds the functionality to the listing.

Back on topic, yes I have been looking into it. Excluding views from the same visitor is doable – thing is that then it’d also require WPP to track this statistic as well: unique visitors vs total visits (ala Google Analytics), because people will wonder “hey, why are my statistics going down?”

Developing such feature would -probably- also need to reestructure the database tables as well. All that can be done, but it requires a lot of testing and of course time. I’m pretty sure it’ll end up happening sometime in the future, though.

Okay so the thing we talked about happened, just now. Views are all over the place.

https://tinypic.com/r/2vw730h/8

It happened approximately 24 hours after my last reset of the cache.
I would like to say that I am still editing a lot on my site and are installing/deleting plugins regularly, maybe there’s a conflict there?

Did you, by any chance, install a different “popular posts” plugin before installing WPP?

That might very well have been the case. When I began my site-creation I experimented with different popular posts plugins, however yours are currently the only active PP-plugin. Don’t know if “Special Recent Posts”-plugin might inflict here?

When I sort by all time the plugin seems to function fine.

https://tinypic.com?ref=o609sm

Do you want me to delete traces of the other PP-plugins from my database?

Can you please check your database and see if there’s a table called wp_PopularPostsdata?

Yes I have that.

FROM wp_popularpostsdata
LIMIT 0 , 30

is this limit supposed to be there?

Also have a wp_popularpostssummary

When expecting the wp_popularpostsdata it seems like it keeps track of posts with id’s my current posts don’t have. I looked up the post id’s and it leads me to pages. One of the pages are a front-end “create post”-page, so wp_popularpostsdata keeps track of my pages as well. Is this intended?

Yep, WPP also keeps track of pages. That’s intended. They only page WPP doesn’t track is the home page for performance reasons.

So, there’s just one wp_popularpostsdata table? Other people with similar issues have reported having two of them: wp_PopularPostsdata and wp_popularpostsdata, and I suspect there’s another plugin out there that’s responsible from creating the first one (the latter is from WPP).

Strange… yes, there is only one wp_popularpostsdata.

I have cleaned my database as good as possible(deleted two old “top 10”-plugin tables no longer in use), disable some site-stats plugins, and cleared my WPP cache again. Hope this time I won’t run into problems. Will report back to you in here if it persists.

Hi,

I’m having the same problem here. In fact I have another one that maybe it’s related.

For testing purposes I’m using the deafult widget set to sort posts by “total views” and the time range is “last 7 days”

I’m also selecting a comma separated list fo categories to include.

The two issues I’m having:
1 – Sort doesn’t seem to be working as described by sponker
2 – Sort seems to be done inside each category. So if my category with the lowest ID has enough posts to fill the 10 positions, none od the other categories will show up. Suppose I have category with ID 100, with 10 posts with 2 views each and category with ID 120 with 5 posts with 5 views each… only the 10 posts from category 100 will show up.

This is kind of weird, because when I check the counts in the backoffice they look fine and the counter goes up when i view a specific post. So, just an issue sorting output.

cheers,
miguel

Since I’m unable to reproduce the sorting issue -everything works fine for me, even while using the category filter- I’m gonna need your help, guys.

In order to try to replicate the issue locally, please send a fresh backup of the following DB tables to hcabrerab at gmail:

• wp_commentsmeta
• wp_comments
• wp_popularpostsdata
• wp_popularpostssummary
• wp_postmeta
• wp_posts
• wp_terms
• wp_term_relationships
• wp_term_taxonomy

After deleting some of the tables that could have an impact on the plugin, such as “top 10 popular posts”-plugin tables, I haven’t encountered any problems for two days now.

You want us to send the tables when the bug is current, right?

And now I jinxed it.
I have send you the tables on your mail as requested, I figure it’s dot com lastly.

Does editing in my theme’s functions.php have anything to do with this? I recently did that and the bug kinda appeared after that.