Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
actual I running 7.4b2 but this bug is a long term problem in my board, starting several versions ago. My board is an imported from 6.5

The problem:

on my admin panel under statistics I have Members: 599
in /admin/groupmanage.php I have the following values:
1 Administrators 6
2 GlobalModerators 1
3 Moderators 21
4 Users 1004
5 Guests 1

The usercount is to high. Clicking on 1004 I get:
Result 1-25 von 598

there is a difference of 1 user to the statistics on the entry page.

I also wonder about the 1 guest in the guest group. Clicking on the 1 bring up:
no members found

The statistic content island on my portal also count 599 members.

What can be done to correct the values?


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You might have duplicate entries in group 4 in the USER_GROUPS table. If I can get the admin info to your site I can take a peek and see what we can do to fix. You can PM me or open a support ticket if you'd like.

Joined: Dec 2006
Posts: 1,235
veteran
veteran
Joined: Dec 2006
Posts: 1,235
Mine has been like that since 7.3

I did mention it at the time but searching through my earlier posts it seems to have (ahem) disappeared. whistle

Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
I guess it comes from deleting members


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Some upgrader wonkiness I guess. I've fixed Zarzal's. If you're brave you can do it too smile

Close your forums, cross your fingers, do a database backup if you're really scared laugh

These two queries will remove everyone from group 4, and then add everyone back in. I'll need to automate this cleanup at some point. Zarzal's looks like they came from deleted users, but not sure.

SQL Query
delete from ubbt_USER_GROUPS where GROUP_ID='4'

SQL Query
insert into ubbt_USER_GROUPS (GROUP_ID,USER_ID) select '4', USER_ID from ubbt_USERS where USER_ID <> 1

Clicking on the Guest group it's normal for it to come up with zero results, since you can't edit user 1, the only person in that group.

Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
thank you for looking in and fixing it so quick. Good work


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Dec 2006
Posts: 1,235
veteran
veteran
Joined: Dec 2006
Posts: 1,235
Well, after serious consideration ( and reading the terms "Brave, Scared, Backup, Remove, Cross you fingers" and the fact that to me personally it isn't that big an issue ) I have decided to decline your offer of a DIY fix and leave well alone. grin

Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
I would do it as the data error may come back to "byte" you in the arse later on.

Joined: Dec 2006
Posts: 1,235
veteran
veteran
Joined: Dec 2006
Posts: 1,235
Copied, pasted, closed eyes and pressed Execute. eek

Sorted! smile

Thanks for the push. wink

Joined: Dec 2006
Posts: 1,235
veteran
veteran
Joined: Dec 2006
Posts: 1,235
I've just noticed that in Group Management, Users now has an option to enter a Post Count. I'm sure that wasn't there before. confused

Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
this is a feature that works like this:

If the member made so much post as you entered by the group the member will become member automaticly member of the group. This Feature comes with 7.3.x


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Dec 2006
Posts: 1,235
veteran
veteran
Joined: Dec 2006
Posts: 1,235
Yes, I know that it is a feature for groups that you have added but I don't remember seeing it for default groups before.

New registrations are by default added to the Users group so why would you need a Post Count option for it?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
If you decided to have new users to be added to a different group, and then used the Users group for a special group. wink

I just worked on a site that created a New Users group with limited permissions, and that was where new users were added to. Then they were auto added to the Users group upon posting 25 posts.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
2 members (Nightcrawler, Ruben), 322 guests, and 160 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)