Page MenuHomePhabricator

Admin Stats doesn't show former admins in stats
Closed, ResolvedPublic

Description

The Hungarian bureaucrats got a report about that Admin Stats doesn't show those admins, whom status were removed before 2015. The user says that too, changing the period doesn't help. For example, User:Dorgan was admin between 2007. 10. 9. – 2008. 08. 31. and 2008. 10. 8. – 2014. 03. 9., but it doesn't appear on the statistics. The user suggest that we should add admin bit for these missing twenty-six users to update the statistics, but I hardly oppose it, beacuse it is a bug and this wouldn't be a good solution. For me, it looks like a little bit similar to T171278.

Event Timeline

MusikAnimal moved this task from Backlog to Working on the XTools board.
MusikAnimal subscribed.

The user suggest that we should add admin bit for these missing twenty-six users to update the statistics

Don't do that!

This indeed appears to be a bug. I will look into this today.

Looks like some data is missing in the replicas. I believe user_former_groups should list everyone with their former rights.

Yet:

SELECT * FROM huwiki_p.user_former_groups
WHERE ufg_user = (
  SELECT user_id
  FROM huwiki_p.user
  WHERE user_name = 'Dorgan'
);

only returns:

+----------+-----------+
| ufg_user | ufg_group |
+----------+-----------+
|     1813 | trusted   |
+----------+-----------+
1 row in set (0.01 sec)

The user suggest that we should add admin bit for these missing twenty-six users to update the statistics

Don't do that!

This indeed appears to be a bug. I will look into this today.

Thanks for your fast answer! I know that is a bad idea, so I won't do that.

MusikAnimal moved this task from Pending deployment to Complete on the XTools board.

Should be fixed!

The downside is we're no longer listing admins who made zero actions in the time period. I think this is okay, though.