Sonya* Posted March 1 Share Posted March 1 (edited) 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* Link to comment Share on other sites More sharing options...
Solution Marc Stridgen Posted March 1 Solution Share Posted March 1 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* 1 Link to comment Share on other sites More sharing options...
Sonya* Posted March 1 Author Share Posted March 1 10 minutes ago, Marc Stridgen said: Something I think this -> Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 1 Share Posted March 1 Yes, so the forum itself will have not had postcounts switched on before it was move I suspect Sonya* 1 Link to comment Share on other sites More sharing options...
Recommended Posts