Register Log In

UBB.threads PHP Forum Software Community Forums General Suggestions and Feedback forum stats issue

Print Thread

Hop To

forum stats issue #2463 08/09/2006 2:31 PM
Joined: Jul 2006 Posts: 51 Germany, Mainz Mtier journeyman
Mtier journeyman Joined: Jul 2006 Posts: 51 Germany, Mainz	Hmm, don´t know if is a bug or a local issue. Orginal Forumstats: When i run this sql: Quote SELECT count( * ) , sum( POST_IS_TOPIC ) FROM ubbt_POSTS WHERE POST_IS_APPROVED I get this result: Or: Quote SELECT COUNT() As Anzahl FROM ubbt_USERS where USER_IS_APPROVED = 'yes' UNION SELECT COUNT() As Anzahl FROM ubbt_FORUMS where FORUM_IS_ACTIVE = '1' UNION SELECT COUNT() As Anzahl FROM ubbt_TOPICS where TOPIC_IS_APPROVED = '1' UNION SELECT COUNT() As Anzahl FROM ubbt_POSTS where POST_IS_APPROVED = '1' These results are correct but do not match with the forum statistics (posts/topics). Running beta2 rv.344 Firstone Last edited by Firstone; 08/09/2006 2:50 PM.

Re: forum stats issue Mtier #2464 08/09/2006 3:23 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	When beta3 is released it will fix this. When I was working with you on your site to figure out the slowdown, I made some changes to the cache_builders script for the forum stats. However I had a variable mixed up which leads to the incorrect data.

Re: forum stats issue Rick #2465 08/09/2006 4:52 PM
Joined: Jul 2006 Posts: 51 Germany, Mainz Mtier journeyman
Mtier journeyman Joined: Jul 2006 Posts: 51 Germany, Mainz	Can´t wait, thanks Rick

Re: forum stats issue Mtier #2475 08/10/2006 2:02 AM
Joined: Jun 2006 Posts: 464 Likes: 1 So. California M Mors Addict
Mors Addict M Joined: Jun 2006 Posts: 464 Likes: 1 So. California	Check my site.. stats are all screwed up Just upgraded to B3 Last edited by Mors; 08/10/2006 2:03 AM. Happy Customer !!!

Re: forum stats issue Mors #2520 08/11/2006 11:54 AM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	Yeah, apparently I didn't actually fix it in B3. I must have just dreamed of fixing it. Really fixing it now as I type this.

Re: forum stats issue Rick #2561 08/11/2006 6:05 PM
Joined: Jun 2006 Posts: 464 Likes: 1 So. California M Mors Addict
Mors Addict M Joined: Jun 2006 Posts: 464 Likes: 1 So. California	haha Happy Customer !!!

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Bots
by Outdoorking - 04/13/2024 5:08 PM

Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM

Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM

This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM

Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM

Who's Online Now

2 members (Ruben, Nightcrawler), 549 guests, and 171 robots.

Key: Admin, Global Mod, Mod

Random Gallery Image

Latest Gallery Images

Los Angeles

Los Angeles
by isaac, August 6

3D Creations

3D Creations
by JAISP, December 30

Artistic structures

Artistic structures
by isaac, August 29

Stones

Stones
by isaac, August 19

Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)