vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Post count does not line up? (https://vborg.vbsupport.ru/showthread.php?t=280121)

Kaitlyn2004 03-15-2012 08:00 PM

Post count does not line up?
 
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.


All times are GMT. The time now is 03:28 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00878 seconds
  • Memory Usage 1,700KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete