PDA

View Full Version : Post count does not line up?


Kaitlyn2004
03-15-2012, 08:00 PM
At the bottom of the forum home it shows a # for posts. I just re-ran update counters -> update form information

I then go into the DB and SELECT COUNT(*) FROM vb3post WHERE visible = 1;

The difference is about 8k. Any ideas for the difference?

kh99
03-16-2012, 02:29 PM
I'm not sure offhand why there'd be a difference, but when you rebuild forum information it calls function build_forum_counters() (in includes/functions_databuild.php) for each forum. That function adds up the replycount fields for each thread where visible = 1 and open <> 10 (I can't remember what an open of 10 means). It also looks like it doesn't count posts by "global ignore" users. So it could be that for some reaosn you have "orphaned" posts that aren't counted in any thread, or threads that aren't in any forum. If you have the CMS, I think comments are posts, but I'm, not sure if they're in threads or forums.