Page MenuHomePhabricator

List users by group bug
Closed, InvalidPublic

Description

Author: sr.ribeiro

Description:


Version: 1.5.x
Severity: normal
URL: http://pt.wikipedia.org/w/index.php?title=Especial%3AListusers&group=bureaucrat&username=

Details

Reference
bz2690

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:39 PM
bzimport set Reference to bz2690.
bzimport added a subscriber: Unknown Object (MLST).

sr.ribeiro wrote:

On the special page Listusers, when browsing by the group of bureaucrat at WP:PT
there are 2 users that are shown but that aren't really bureaucrats.

Mediawiki output seems correct. The pt.wikipedia database
got 4 users belonging to group "bureaucrat":

mysql> select user_name from user
> left join user_groups on ug_user=user_id
> where ug_group="bureaucrat";
+-----------------+

user_name

+-----------------+

Jorge
Jurema Oliveira
Muriel Gottrop
Mschlindwein

+-----------------+
4 rows in set (0.02 sec)
mysql>

sr.ribeiro wrote:

(In reply to comment #2)

Mediawiki output seems correct. The pt.wikipedia database
got 4 users belonging to group "bureaucrat":

mysql> select user_name from user
> left join user_groups on ug_user=user_id
> where ug_group="bureaucrat";
+-----------------+

user_name

+-----------------+

Jorge
Jurema Oliveira
Muriel Gottrop
Mschlindwein

+-----------------+
4 rows in set (0.02 sec)
mysql>

First of all, the list shows like when I reported the bug:

  1. Jorge (Burocrata, sysop)
  2. Jurema Oliveira (Burocrata, sysop)
  3. Mschlindwein (Burocrata, sysop)
  4. Muriel Gottrop (Burocrata, sysop)

After I reported this bug, here, I went to #wikimedia and asked a steward to
check Jorge and Jurema Oliveira rights for me, and then while talking to him, we
noticed that at the [http://pt.wikipedia.org/wiki/Especial:Log/rights rights
log], Manuel Anastácio, a ex-bureaucrat, gave user Leslie sysop and bureaucrat
rights since Leslie was only elected for admin, this was by mistake.

So note that Leslie had(1) bureaucrat rights, and that he didn't appear on the
list. And by last that the steward checked, and both Jorge(2) and Jurema
Oliveira(3) only have(4) sysop rights.

And one more thing, notice that some system messages that the page uses have
been translated to portuguese, but the page doesn't update them.

(1) Since Leslie have only been elected for sysop, the bureaucrat rights have
been removed by the steward.
(2) Jorge was a bureaucrat until last January (2005).
(3) Jurema Oliveira, like Leslie, had been given by mistake bureaucrat rights,
but they have been removed in January.
(4) No changes requested for this users rights.

Well, the list does reflect what's in the database -- that's not a bug.

As for the steward stuff: I see at http://meta.wikimedia.org/wiki/Special:Log/rights

23:34, 3 Jul 2005 Danny Rights for user "User:Jurema Oliveira@ptwiki" set "" (=sysop)
23:33, 3 Jul 2005 Danny Rights for user "User:Jorge@ptwiki" set "" (=sysop)
23:30, 3 Jul 2005 Danny Rights for user "User:Leslie@ptwiki" set "" (=sysop)

If I understand correctly, at the moment a steward action on meta will apply only to the
old databases and thus won't be reflected in the new software running at
pt.wikipedia.org right now.

I took a peek at the database backup from June 23; user_rights table then contained
'sysop,bureaucrat' entries for the following users:

  • Jorge
  • Jurema Oliveira
  • Muriel Gottrop
  • Mschlindwein

That's exactly the state that's been included in the upgraded user_groups table in the
new software.

Now they're present in the no-longer-used user_rights table for:

  • Muriel Gottrop
  • Mschlindwein

As near as I can see, the problem is that a steward tried to make changes recently on
the old interface, which don't have any affect on the new database.

sr.ribeiro wrote:

Marked bug as resolved (invalid), since like the devs say, this is not mediawiki
software bug.

Best regards and sorry for the reopening of the bug.