View previous topic :: View next topic |
Author |
Message |
amittp Tux's lil' helper
Joined: 02 Jul 2002 Posts: 123 Location: USA
|
Posted: Fri Aug 29, 2003 9:08 pm Post subject: Counting error while deleting duplicates |
|
|
If a duplicate post is submitted (pressing submit multiple times), then that is not counted. Although while deleting the multiple post, the number of posts is reduced. Unfair, isn't it?
I saw the problem when my same thread was posted for 6 times (during net problem), (number of post was not affected -- good). So I deleted 4 posts and my post count depleted. Is this bug or purposeful policy ? _________________ Believe in yourself |
|
Back to top |
|
|
masseya Bodhisattva
Joined: 17 Apr 2002 Posts: 2602 Location: Baltimore, MD
|
Posted: Sat Aug 30, 2003 1:55 am Post subject: |
|
|
This is caused by the fact that an update to your user information is a separate database transation from an update to thread information. I actually have about ten more posts than what I have listed as my actual post count because of similar issues. I'm not too worried about this. So to answer your question, no, this isn't intentional. Yes, we are aware of it. No, there is no quick fix for this. _________________ if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
Back to top |
|
|
supernovus Apprentice
Joined: 13 Jul 2003 Posts: 150 Location: inside my head
|
Posted: Fri Sep 05, 2003 4:41 am Post subject: Ah |
|
|
Glad I found this message, I was wondering about that.
I had a freezeup problem and ended up posting about five or six copies
of a message, so I went and deleted all of the duplicates, and POOF. My post count was down to "3"... I knew I was a n00b, but I thought I'd had 7 or 8 posts... now I'm back up to 8 again. Oh well, gotta rebuild my credit rating I guess.
PS
Oh, and when I say newbie, I don't mean in terms of GNU/Linux usage.
I've used many different distributions (started with Slackware 3.1) and most recently switched from a heavily customized LFS to Gentoo, and am loving it |
|
Back to top |
|
|
masseya Bodhisattva
Joined: 17 Apr 2002 Posts: 2602 Location: Baltimore, MD
|
Posted: Fri Sep 05, 2003 4:38 pm Post subject: Re: Ah |
|
|
supernovus wrote: | I knew I was a n00b, but I thought I'd had 7 or 8 posts... now I'm back up to 8 again. Oh well, gotta rebuild my credit rating I guess. | I wish people didn't look at post count as a credit rating. It's really not all that accurate. Most of the really obscure questions are answered by someone who only has 10 posts or so.
Quote: | Oh, and when I say newbie, I don't mean in terms of GNU/Linux usage.
I've used many different distributions (started with Slackware 3.1) and most recently switched from a heavily customized LFS to Gentoo, and am loving it | Yeah, you probably have more actual Linux experience than I do in that case. _________________ if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
Back to top |
|
|
amittp Tux's lil' helper
Joined: 02 Jul 2002 Posts: 123 Location: USA
|
Posted: Fri Sep 05, 2003 5:56 pm Post subject: |
|
|
Yeah, as a Tux' Lil helper, I have taken more support than given it. But well I am so happy to find this forum filled with level headed people, and makes so much fun to interact, that I wonder if anyone really worries about these ratings. I hope this remains forever and no one tries to change this scheme. _________________ Believe in yourself |
|
Back to top |
|
|
ian! Bodhisattva
Joined: 25 Feb 2003 Posts: 3829 Location: Essen, Germany
|
Posted: Wed Sep 17, 2003 10:52 am Post subject: |
|
|
masseya wrote: | This is caused by the fact that an update to your user information is a separate database transation from an update to thread information. I actually have about ten more posts than what I have listed as my actual post count because of similar issues. I'm not too worried about this. So to answer your question, no, this isn't intentional. Yes, we are aware of it. No, there is no quick fix for this. |
I think that it shouldn't be a problem to rebuild the "post-count-table" by counting all posts for each single user.
Should look very similar to this:
Code: |
($1) = select count(*) from <POSTTABLE> where <USERID>='<USERS_USERID>';
update <POSTCOUNTTABLE> set <POSTCOUNT>='$1' where <USERID>='<USERS_USERID>';
|
I don't know how the phpBB database structure looks like. But it must be very similar to the given example. You could easily keep the post count up to date by setting up a cronjob that executes a script that does this job for you.
I got aware of this problem when I browsed my own postings. I was pretty surprized that there is a difference about 37 posts in my post count statistics.
Compare this two:
https://forums.gentoo.org/search.php?search_author=ian%21
https://forums.gentoo.org/profile.php?mode=viewprofile&u=15031
masseya wrote: | I wish people didn't look at post count as a credit rating. |
I don't. But it is a problem that could be fixed easily, I think. Many users seem to be upset about this bug.
Regards,
ian! _________________ "To have a successful open source project, you need to be at least somewhat successful at getting along with people." -- Daniel Robbins |
|
Back to top |
|
|
kallamej Administrator
Joined: 27 Jun 2003 Posts: 4975 Location: Gothenburg, Sweden
|
Posted: Wed Sep 17, 2003 2:17 pm Post subject: |
|
|
I agree that this isn't the biggest of problems concerning the forums, but it does itch a bit. See this thread where a post has been tenfolded. Still the user's post count is 1, and that's only because (s)he posted an apology for the multiple post. _________________ Please read our FAQ Forum, it answers many of your questions.
irc: #gentoo-forums on irc.libera.chat |
|
Back to top |
|
|
ian! Bodhisattva
Joined: 25 Feb 2003 Posts: 3829 Location: Essen, Germany
|
Posted: Wed Sep 17, 2003 4:55 pm Post subject: |
|
|
phpBB did it again.
Posted _once_. phpBB made two posts out of it and did not touch the post-count. I deleted the duplicate and phpBB decreased my post-count by one.
What a life...
ian! _________________ "To have a successful open source project, you need to be at least somewhat successful at getting along with people." -- Daniel Robbins |
|
Back to top |
|
|
ian! Bodhisattva
Joined: 25 Feb 2003 Posts: 3829 Location: Essen, Germany
|
Posted: Thu Sep 18, 2003 12:08 pm Post subject: |
|
|
Ok, me once again. I found a addon that resyncs users post counts.
Take a look at: http://www.phpbb.com/phpBB/viewtopic.php?t=133360
It should work on 2.0.4 too, I think. _________________ "To have a successful open source project, you need to be at least somewhat successful at getting along with people." -- Daniel Robbins |
|
Back to top |
|
|
masseya Bodhisattva
Joined: 17 Apr 2002 Posts: 2602 Location: Baltimore, MD
|
Posted: Thu Sep 18, 2003 3:02 pm Post subject: |
|
|
ian! wrote: | Ok, me once again. I found a addon that resyncs users post counts. | Cool. I'll take a look-see. Thanks for staying on top of this issue. _________________ if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
Back to top |
|
|
pjp Administrator
Joined: 16 Apr 2002 Posts: 20067
|
Posted: Fri Sep 19, 2003 1:41 am Post subject: Re: Counting error while deleting duplicates |
|
|
amittp wrote: | Unfair, isn't it? | If it were a problem with you bank account, it would be unfair. Post counts are hardly important. _________________ Quis separabit? Quo animo? |
|
Back to top |
|
|
|