# Incorrect number of users in the groups overview

**URL:** <https://meta.discourse.org/t/incorrect-number-of-users-in-the-groups-overview/169968>\
**Category:** Product Support\
**Created:** [November 12, 2020, 7:20pm UTC](https://meta.discourse.org/t/incorrect-number-of-users-in-the-groups-overview/169968 "2020-11-12T19:20:54Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![GuidoD](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/guidod/32/292621_2.png) [@GuidoD](https://meta.discourse.org/u/GuidoD)\
**Post date:** [November 13, 2020, 2:30pm UTC](https://meta.discourse.org/t/incorrect-number-of-users-in-the-groups-overview/169968/3 "2020-11-13T14:30:01Z")

</div>

well even after 12 hours they are still incorrect, all values from trust level 0 to trust level 4 were only reduced by 2 (for whatever reason). All other group counters seem to be correct.

 ![grafik](https://global.discourse-cdn.com/meta/original/3X/b/0/b09d41014bcf9d9c138f3fab1401b8a6d6a7105c.png)

no the last user delete had been already two days ago.  
In the last 14 days I did only delete 7 users.  
I did delete in the last 1,5 years more than 2000 users. We do have the plugin [autosupend](https://github.com/davidtaylorhq/discourse-auto-suspend) in place and are auto supending users that are more than 365 days without activity.These autosuspended users and all their data I do then delete at least once a week, so that we remain EU-GDPR compliant.

Sidekick is working fine, no dead jobs.  
As far as I remember the number of jobs that did error out has also not changed in the last couple of days.  
What is the queue 0f13eb003564dea87a7cc8f25560ba0e for?  
Is that queue needed or should I delete it?

 ![grafik](https://global.discourse-cdn.com/meta/original/3X/3/c/3cfccf3b70b145a604a175a34ff3524ba6dc4436.png)

I think I found the problem, the table **group\_users** does still have entries for user\_id which do no longer exist and which are no longer in the table **users**. (in total 182 entries for 117 user\_id which do not have a corresponding entry in users)  
So somehow the database has some inconsistencies. I do not know how this has happened.  
And now the question is, how I can solve it now?  
Just manually delete with a sql statement the entries from **group\_users** for which no entry does exist in **users**?

---

_[View the full topic](https://meta.discourse.org/t/incorrect-number-of-users-in-the-groups-overview/169968)._
