Page MenuHomePhabricator

Remove all users from the 'autopatrolled' user group on Wikidata and Test Wikidata
Closed, ResolvedPublic

Description

Apparently the request in bug 56203 to remove all users in the now abolished 'autopatrolled' user group on Wikidata/Test Wikidata was ignored. That https://www.wikidata.org/w/index.php?title=Special:ListUsers&group=autopatrolled and https://test.wikidata.org/w/index.php?title=Special:ListUsers&group=autopatrolled still contain users already caused some confusion within the community and thus I open a new bug to get that resolved. Thank you.


Version: wmf-deployment
Severity: minor

Details

Reference
bz56945

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 2:32 AM
bzimport set Reference to bz56945.
bzimport added a subscriber: Unknown Object (MLST).

Not really an enhancement: these users were supposed to have been removed but weren't.

Just needs a couple of simple database queries to be run.

delete from user_groups where ug_group = 'autopatrolled'; commit;

mysql:wikiadmin@db1058 [wikidatawiki]> delete from user_groups where ug_group = 'autopatrolled'; commit;
Query OK, 1855 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

mysql:wikiadmin@db1038 [testwikidatawiki]> delete from user_groups where ug_group = 'autopatrolled'; commit;
Query OK, 7 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql:wikiadmin@db1038 [testwikidatawiki]>

It seems like something was forgotten as the 'autopatrolled' group still shows up in for example https://www.wikidata.org/w/index.php?title=Special%3AListUsers&username=1971markus&group=&limit=1.

Cached user objects

mysql:wikiadmin@db1058 [wikidatawiki]> select * from user_groups where ug_group = 'autopatrolled';
Empty set (0.01 sec)

mysql:wikiadmin@db1058 [wikidatawiki]> select user_id from user where user_name = '1971markus';
+---------+

user_id

+---------+

94516

+---------+
1 row in set (0.00 sec)

mysql:wikiadmin@db1058 [wikidatawiki]> select * from user_groups where ug_user = 94516;
Empty set (0.00 sec)

mysql:wikiadmin@db1058 [wikidatawiki]>

Then:

reedy@tin:~$ mwscript eval.php wikidatawiki

$user = User::newFromName('1971markus');

$user->invalidateCache();

Now
1971markus (talk | contribs | block) (Created on 21 January 2013 at 17:19)

It will clear itself up in a while as user objects expire and/or updated