Post count problem

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Chrizathens
Registered User
Posts: 12
Joined: Sun Oct 29, 2006 2:24 am

Post count problem

Post by Chrizathens »

Hi, guys... I have a small problem
Some of my users appear with zero posts, but in fact they have a few... :?
One user for example appears in viewtopic to have 0 posts but has 7, another user appears to have 9 but has 20 etc..
My phpbb version is 3.0.4 (upgraded from 3.0.2-->3.0.3, converted from phpbb2)
The actual problem I believe started after the upgrade to 3.0.3.
I have checked whether those members are allowed to increase post count, run resync post count... but nothing...
Any ideas???
User avatar
Kevin Clark
Support Team
Support Team
Posts: 751
Joined: Thu Feb 10, 2005 5:34 pm
Location: UK
Contact:

Re: Post count problem

Post by Kevin Clark »

It's a forum permission, not a user one.

Check
groups forum permissions
registered users
each forum
advanced
misc
Increment post counter
Image
Chrizathens
Registered User
Posts: 12
Joined: Sun Oct 29, 2006 2:24 am

Re: Post count problem

Post by Chrizathens »

Yes, sorry if my post confused you.. I was not describing how to get there, I was actually stating that
this guy is in registered users group and that group has Increment post counter set to Yes for all forums in my board (I don't actually use this feature)
So, to sum up, I checked for this case.

What do you think could solve the problem? I just cloned my today's live forum on localhost, so any test I can do is welcome.
TIA, Kevin!
User avatar
Kevin Clark
Support Team
Support Team
Posts: 751
Joined: Thu Feb 10, 2005 5:34 pm
Location: UK
Contact:

Re: Post count problem

Post by Kevin Clark »

I'd make a test account and do one post in every forum and see which one(s) are not increasing the post count. That would be a sensible starting point I think.
Image
Chrizathens
Registered User
Posts: 12
Joined: Sun Oct 29, 2006 2:24 am

Re: Post count problem

Post by Chrizathens »

Darn... I can't believe this.... I cannot understand how to see what permissions are there using group's forums permissions, so I just checked with view forum-based permissions and I realized that for one particular subforum, increment post count was set to never...
OMG... :evil:

Thanks a million Kevin, I figured this out by using your proposal and create a new test account..
Chrizathens
Registered User
Posts: 12
Joined: Sun Oct 29, 2006 2:24 am

Re: Post count problem

Post by Chrizathens »

Ok, I have set the permissions -properly - and now my testuser increases his post count...
But users who have already posted in the previously "problematic" forum have made posts that now have not counted.. Is there a way I can make it to recount posts and show the real number of those users posts?
Resynchronize post counts does not seem to make any difference in this case...
Thanks again guys!! :D
User avatar
Brf
Support Team
Support Team
Posts: 332
Joined: Sun Mar 11, 2007 1:06 pm

Re: Post count problem

Post by Brf »

That is because each post has a count flag that you would have to set manually by running some sort of SQL query.
Chrizathens
Registered User
Posts: 12
Joined: Sun Oct 29, 2006 2:24 am

Re: Post count problem

Post by Chrizathens »

Could you offer an example?

EDIT : Or, alternatively, if I copy those posts to another section and copy them back to the original one, will this make the posts recount???
EDIT2 : Nevermind copy does not do the job...
If you can elaborate with an example of the appropriate sql query it would be great, if not nevermind, it is not really important... ;)
User avatar
Brf
Support Team
Support Team
Posts: 332
Joined: Sun Mar 11, 2007 1:06 pm

Re: Post count problem

Post by Brf »

In phpmyadmin run:

Code: Select all

update phpbb_posts set post_postcount=1
where phpbb_ is your database perfix.
Chrizathens
Registered User
Posts: 12
Joined: Sun Oct 29, 2006 2:24 am

Re: Post count problem

Post by Chrizathens »

And I guess that after that I run the resynchronize post count?
Locked