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?

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.

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.

I guess it comes from deleting members

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.





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.

thank you for looking in and fixing it so quick. Good work

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.

I would do it as the data error may come back to "byte" you in the arse later on.

Copied, pasted, closed eyes and pressed Execute.

Sorted!

Thanks for the push.

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.