sumanah wrote:

Thanks for the report. I infer that this was just on English Wikipedia - am I right?

And do you know when he became unblocked? Was it recently?

What do you mean 'no longer shows up as blocked'? Where are you (not) seeing this?

(In reply to comment #1)

Thanks for the report. I infer that this was just on English Wikipedia - am I
right?

And do you know when he became unblocked? Was it recently?

Yes to your first question. For your second, I do not know; I was just browsing http://en.wikipedia.org/wiki/Wikipedia:List_of_banned_users for fun and I saw one entry that was not in light strikeout italics, and decided to investigate.

(In reply to comment #2)

What do you mean 'no longer shows up as blocked'? Where are you (not) seeing
this?

http://en.wikipedia.org/wiki/Special:Block/Zorro_redux does not indicate that he is blocked.

https://en.wikipedia.org/wiki/Special:Contributions/Zorro_redux

https://en.wikipedia.org/wiki/Special:Block/Zorro_redux

https://en.wikipedia.org/w/index.php?title=Special%3ALog&type=&user=&page=Zorro+redux&year=&month=-1&tagfilter=&hide_patrol_log=1&hide_review_log=1

https://en.wikipedia.org/wiki/Special:BlockList?wpTarget=Zorro+redux&limit=50

I just did a query:
mysql> select * from ipblocks where ipb_user = 'Zorro redux';
Empty set (39.27 sec)

select * from ipblocks where ipb_user=745793;

stdClass Object
(

[ipb_id] => 84639
[ipb_address] => Zorro_redux

...

Basically, looks like earlier blocks were made with ipb_address = dbkey while newer ones are made against pretty usernames.

(In reply to comment #5)

I just did a query:
mysql> select * from ipblocks where ipb_user = 'Zorro redux';
Empty set (39.27 sec)

mysql> select * from ipblocks where ipb_user = 745793\G

• 1. row ******* ipb_id: 84639 ipb_address: Zorro_redux ipb_user: 745793 ipb_by: 24 ipb_reason: Bad Editing ipb_timestamp: 20060120202734 ipb_auto: 0 ipb_anon_only: 0 ipb_create_account: 1 ipb_expiry: infinity ipb_range_start: ipb_range_end:

ipb_enable_autoblock: 1

       ipb_deleted: 0
   ipb_block_email: 0
       ipb_by_text: Jimbo Wales
ipb_allow_usertalk: 1

ipb_parent_block_id: NULL
1 row in set (0.00 sec)

(In reply to comment #6)

Basically, looks like earlier blocks were made with ipb_address = dbkey while
newer ones are made against pretty usernames.

Does anyone know when that change was made? We could probably backfill if needed, but I'm surprised we wouldn't have for that kind of a change.

(In reply to comment #8)

Does anyone know when that change was made? We could probably backfill if
needed, but I'm surprised we wouldn't have for that kind of a change.

The latest affected block is:

select * from ipblocks where ipb_address like '%\_%' order by ipb_timestamp desc limit 1;

stdClass Object
(

[ipb_id] => 206483
[ipb_address] => I_learned_poker_from_wikipedia
[ipb_user] => 1774933
[ipb_by] => 676502
[ipb_reason] => {{username}}
[ipb_timestamp] => 20060711184521

And the offending revision appears to be 1d9922db6442dec82e4be07c45c2e8a3a2035602 by Tim (not sure about SVN revision number).

(In reply to comment #10)

And the offending revision appears to be
1d9922db6442dec82e4be07c45c2e8a3a2035602 by Tim (not sure about SVN revision
number).

r15482