Posts in clubs do not increase post count

[Sonya*]

I have clubs on the website and have noticed that posts in clubs forums do not always increase the number of posts in members' profile. I have investigated in database and have found out that old clubs, created over 10 years ago, have inc_postcount set to 0.

SELECT * FROM `ips_forums_forums` WHERE `inc_postcount` = 0 AND `club_id` IS NOT NULL

Probably there was an issue 10 years ago. 😄 Or there was an “Improved Clubs Enhancements” app, I have used before the upgrade to the latest IPS version. Anyway, I would like to recalculate all posts from all users, and I suspect that posts from these clubs are not counted.

There is no way to set this value for club forums in ACP.

SQL? Is it safe just to update the column with 1 for all clubs? 😬

Edited March 1 by Sonya*

[Marc]

You could update that (ensure you backup first). Once you do, you would need to recount though. Bearing in mind it will  only count what is currently present 

EDIT: Thinking about it, you mention topics over 10 years ago. Something must have moved that forum to clubs. The reason I say this is that clubs didnt exist at that point in time.

[Sonya*]

10 minutes ago, Marc Stridgen said:

Something

I think this -> 

 

[Marc]

Yes, so the forum itself will have not had postcounts switched on before it was move I suspect