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.