Post count problem

[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???

[Kevin Clark]

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

Check
groups forum permissions
registered users
each forum
advanced
misc
Increment post counter

[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!

[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.

[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...

Thanks a million Kevin, I figured this out by using your proposal and create a new test account..

[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!!

[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]

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...

[Brf]

In phpmyadmin run:

Code: Select all

update phpbb_posts set post_postcount=1

where phpbb_ is your database perfix.

[Chrizathens]

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