Statistics Filter Module bloats read statistics

What?

Do you always get this bug?
How can we reproduce on a fresh Drupal install?

It always happens on each edit with my update to 4.72 from 4.71. I have only one installation.

*I could try updating another site.
*Perhaps there is a conflict with another module: If that is so, could you suggest which are likely and I switch them off?
*If you wish to open an account at www.mightyzero.com and tell me your name, i could give you editing privilidges for you to try and see the bug in action yourself.

I just posted a new quote and got nine 'reads' upon submittal (published).

go to this page: http://www.mightyzero.com/popular/alltime and you will see the number of reads for newly created but once edited posts. They show millons of reads. EAch edit does this.

1)WHat table is responsible for logging reads?
2) with what module could a conflict be happening?

When I submit an edit I get this error message:

query: DELETE FROM page_title WHERE nid = 20
error:

You mention that this may be a conflict with a module, which is the most likely.
Can you turn off all contrib module and see if you can still replicate the bug with only core modules.
If not, turn on each contrib module on one at a time and see the one that causes the problem.

Update: I removed the module 'page_title' and things have improved. The statistics are no longer bloated.
Now when I submit an edit the read statistics actually drop, e.g from 10 reads to 7!

How do I clear the bloated numbers?

Apparently, there is a serious bug with the Page Title module.
I don't know this module at all.
I have reassigned the bug: maybe the module maintainer can help you, now.

I'll take a look but have a real hard time seeing how this issue could be related to page_title. All the module does, after all, is set one variable for the page.tpl.php file.

Thanks.

I took the time to remove modules one at a time. Page_Title gives the query: DELETE FROM page_title WHERE nid = 20
error. It does not bloat the reads statistics. Premium module does.

Issues remian: When I removed this module and edited a post with 21 reads, it dropped three reads, as observed before with other posts. (Bizarre, I know).

PLease advise: how to clear number of reads, or reset to desired number?

not sure what version to set this too, but sending it on to the Premium module issue queue

I got it fro the 4.7.2 repository. I'm running Drupal 4.7.2.

Any ideas , please Robert, on resetting my read numbers...i.e which tables am I loking for?

I think truncating your accesslog table will do the trick but try it on a backup first.

Just like page_title, I have a hard time believing that premium has anything to do with this. Premium does not mess with data in any way; it simply replaces the node's body with its teaser content during a view operation.

Can someone provide a clear picture of how to reproduce this problem?

take a look at my site, given above which was only recently launched and the number of reads. As I said
I also doubted Premium's role for just the same reasons.

But twice I carefully switched off one module at a time and tested the problem, after switching off the two problematic modules together. I can give you the WHOLE list of active modules, if in case it is a compounded problem. Otherwise, simply install 4.7.2 and the excellent Premium module, and post then edit your posts.
Use your drupal ID to authenticate and post a page or blog. Edit it. Then inform me via feedback, and I will switch on just Premium for you to edit again and view the result.

Does anyone know how I can reset mypost numbers. If not how can you be certain the module cannot affect post numbers? If so I would like to do justy that as it is a live site.

Thanks,

John Plumridge

following on, if you wish to use my problematic installation in the wya described above, instead of creating your own installation, I meant log in with your drupal ID to www.mightyzero.com

I have duplicated the problem on two installations now, one on my home computer with a fresh Drupal installation. Premium Module was isolated by switching on and off. It happpens on blogs and pages. It doesn't matter wether the post is pretocted by Premium or not, so long as themodule is active.

I don't use Premium.module, so I won't be able to help you with this bug. Provide clear step by step instructions to reproduce the bug and hopefully, the module maintainer will be able to help you.

If you want to reset your count pages, look in phpmyadmin at the {node_counter} table of your installation: there you have stored the node ID, the day and total counter (page views) and the timestamp of the last access date. Once the bug is sorted, you can reset everything to 0 in that table.

Thanks Beginner. I beleive the production of the bug is clear as written and repeated:
simply editing a post with the module installed and activated under modules causes the bloated 'read' counts.

Caching may have led me astray. Also some weird behavour. Anyway, appears to be the browscap module

I have tracked it down for sure now to the statistics filter module

This is probably because the statistics filter module runs db_query('UPDATE {node_counter} SET daycount = daycount - 1, totalcount = totalcount - 1 WHERE nid = %d', arg(1)); without checking if totalcount or daycount is greater than zero, since those fields are unsigned.