Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
forum stats issue
#2463 08/09/2006 2:31 PM
Joined: Jul 2006
Posts: 51
Germany, Mainz
Mtier
Offline
journeyman
Mtier
journeyman
Offline
Joined: Jul 2006
Posts: 51
Germany, Mainz
Hmm, don´t know if is a bug or a local issue.

Orginal Forumstats:
[Linked Image from hungrig-online.de]

When i run this sql:

Quote
SELECT count( * ) , sum( POST_IS_TOPIC )
FROM ubbt_POSTS
WHERE POST_IS_APPROVED

I get this result:
[Linked Image from hungrig-online.de]

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'
[Linked Image from hungrig-online.de]

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 Offline
Former Developer
Rick
Former Developer
R Offline
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
Offline
journeyman
Mtier
journeyman
Offline
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: 465
Likes: 1
So. California
M
Mors Offline
Addict
Mors
Addict
M Offline
Joined: Jun 2006
Posts: 465
Likes: 1
So. California
Check my site.. stats are all screwed up laugh 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 Offline
Former Developer
Rick
Former Developer
R Offline
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: 465
Likes: 1
So. California
M
Mors Offline
Addict
Mors
Addict
M Offline
Joined: Jun 2006
Posts: 465
Likes: 1
So. California
haha laugh

Happy Customer !!!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Selling a Forum?
by ECNet - 10/10/2026 10:54 AM
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Who's Online Now
0 members (), 298 guests, and 124 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)