|
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?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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. 
|
|
|
|
Joined: Jun 2006
Posts: 956
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 956 |
I guess it comes from deleting members
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
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  Close your forums, cross your fingers, do a database backup if you're really scared  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.
delete from ubbt_USER_GROUPS where GROUP_ID='4'
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
|
|
|
|
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. 
|
|
|
|
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.  Sorted!  Thanks for the push. 
|
|
|
|
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. 
|
|
|
|
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
|
|
|
|
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
Former Developer
|
Former Developer
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.  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.
|
|
|
1 members (Gizmo),
103
guests, and
103
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|