Mediawiki.org had one filter, which I've marked as deleted: https://www.mediawiki.org/wiki/Special:AbuseFilter/50.

Commons has two: https://commons.wikimedia.org/wiki/Special:AbuseFilter/149 and https://commons.wikimedia.org/wiki/Special:AbuseFilter/150.

Could someone please run

SELECT * FROM abuse_filter WHERE af_pattern LIKE '%user_wpzero%'

The query is not so performant, but the abuse_filter table is small.

Disabling affected filters (or updating them if e.g. the wpzero part is ORed with something else) will be enough to fix.

Mentioned in SAL (#wikimedia-operations) [2019-07-18T04:31:36Z] <legoktm> running query for T227843 on mwmaint102

• https://ckb.wikipedia.org/wiki/%D8%AA%D8%A7%DB%8C%D8%A8%DB%95%D8%AA:AbuseFilter/12
• https://commons.wikimedia.org/wiki/Special:AbuseFilter/149
• https://commons.wikimedia.org/wiki/Special:AbuseFilter/150
• https://fi.wikipedia.org/wiki/Toiminnot:V%C3%A4%C3%A4rink%C3%A4ytt%C3%B6suodatin/150
• https://he.wikipedia.org/wiki/%D7%9E%D7%99%D7%95%D7%97%D7%93:%D7%9E%D7%A1%D7%A0%D7%9F_%D7%94%D7%94%D7%A9%D7%97%D7%AA%D7%95%D7%AA/80
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/49
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/53
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/54
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/55
• https://mai.wikipedia.org/wiki/%E0%A4%B5%E0%A4%BF%E0%A4%B6%E0%A5%87%E0%A4%B7:%E0%A4%A6%E0%A5%81%E0%A4%B0%E0%A5%81%E0%A4%AA%E0%A4%AF%E0%A5%8B%E0%A4%97_%E0%A4%AB%E0%A4%BC%E0%A4%BF%E0%A4%B2%E0%A5%8D%E0%A4%9F%E0%A4%B0/1
• https://www.mediawiki.org/wiki/Special:AbuseFilter/50
• https://ne.wikipedia.org/wiki/%E0%A4%B5%E0%A4%BF%E0%A4%B6%E0%A5%87%E0%A4%B7:AbuseFilter/7
• https://pt.wikipedia.org/wiki/Especial:Filtro_de_abusos/155
• https://wikisource.org/wiki/Special:AbuseFilter/8
• https://test2.wikipedia.org/wiki/Special:AbuseFilter/9
• https://test.wikipedia.org/wiki/Special:AbuseFilter/161

Gonna also email the full log file to Daimona in case that's more helpful.

Thanks @Legoktm I'm going to take a look at those. Although I have to say, this is more than I expected. And without a global abusefilter-manager group in place, it'll be even harder to fix all of those filters. That said, these filters won't be straightforward to fix (like it was e.g. in T209565). Every filter has its own fix, and sometimes the filter just has to be deleted. Actually, I don't even know if I'd do that with global AF-manager rights.

OK, so, first of all I'd like to announce it on Tech News. We should inform people that wpzero support will be removed, and thus update their filters accordingly. Then let's see how many of those are fixed, and decide how to move on.

Note that the query above includes disabled & deleted filters. Ideally, people should remove the user_wpzero part altogether (since it won't work anyway), but in order to get more precise results, we could re-run the query above including AND af_enabled = 1 AND af_deleted != 0. But that can be delayed until the T/N is released.

In T227843#5344879, @Daimona wrote:

OK, so, first of all I'd like to announce it on Tech News. We should inform people that wpzero support will be removed

Excellent idea! :D

When do you plan to have it happening?

@Trizek-WMF I'd say in the next T/N. It could take some time for people to fix affected filters, so the sooner the better.

I've disabled and marked ptwiki's filter 155 as deleted.

Filters 149 and 150 on Commons disabled and deleted.

Hungarian Wikipedia is done.

Current status, from what I can tell, based on confirmations in comments above from @Guilhermebm, @4nn1l2, and @Bencemac

• https://ckb.wikipedia.org/wiki/%D8%AA%D8%A7%DB%8C%D8%A8%DB%95%D8%AA:AbuseFilter/12
• https://commons.wikimedia.org/wiki/Special:AbuseFilter/149
• https://commons.wikimedia.org/wiki/Special:AbuseFilter/150
• https://fi.wikipedia.org/wiki/Toiminnot:V%C3%A4%C3%A4rink%C3%A4ytt%C3%B6suodatin/150
• https://he.wikipedia.org/wiki/%D7%9E%D7%99%D7%95%D7%97%D7%93:%D7%9E%D7%A1%D7%A0%D7%9F_%D7%94%D7%94%D7%A9%D7%97%D7%AA%D7%95%D7%AA/80
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/49
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/53
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/54
• https://hu.wikipedia.org/wiki/Speci%C3%A1lis:Vand%C3%A1lsz%C5%B1r%C5%91/55
• https://mai.wikipedia.org/wiki/%E0%A4%B5%E0%A4%BF%E0%A4%B6%E0%A5%87%E0%A4%B7:%E0%A4%A6%E0%A5%81%E0%A4%B0%E0%A5%81%E0%A4%AA%E0%A4%AF%E0%A5%8B%E0%A4%97_%E0%A4%AB%E0%A4%BC%E0%A4%BF%E0%A4%B2%E0%A5%8D%E0%A4%9F%E0%A4%B0/1
• https://www.mediawiki.org/wiki/Special:AbuseFilter/50
• https://ne.wikipedia.org/wiki/%E0%A4%B5%E0%A4%BF%E0%A4%B6%E0%A5%87%E0%A4%B7:AbuseFilter/7
• https://pt.wikipedia.org/wiki/Especial:Filtro_de_abusos/155
• https://wikisource.org/wiki/Special:AbuseFilter/8
• https://test2.wikipedia.org/wiki/Special:AbuseFilter/9
• https://test.wikipedia.org/wiki/Special:AbuseFilter/161

All filters not yet crossed off are either private (so I can't check if they are fixed) or are verified as having not yet been fixed. Maybe @Huji could take a look? ckbwiki, maiwiki, mediawikiwiki, newiki, and test2wiki are all in the global sysop wiki set.

@DannyS712 the MW.org filter was marked as deleted in July by @Mainframe98.

It would probably be a good idea to drop the list in the task description so people can keep it up to date more easily.

@Daimona I updated these:

• https://mai.wikipedia.org/wiki/%E0%A4%B5%E0%A4%BF%E0%A4%B6%E0%A5%87%E0%A4%B7:%E0%A4%A6%E0%A5%81%E0%A4%B0%E0%A5%81%E0%A4%AA%E0%A4%AF%E0%A5%8B%E0%A4%97_%E0%A4%AB%E0%A4%BC%E0%A4%BF%E0%A4%B2%E0%A5%8D%E0%A4%9F%E0%A4%B0/1
• https://ne.wikipedia.org/wiki/%E0%A4%B5%E0%A4%BF%E0%A4%B6%E0%A5%87%E0%A4%B7:AbuseFilter/7
• https://test2.wikipedia.org/wiki/Special:AbuseFilter/9
• https://test.wikipedia.org/wiki/Special:AbuseFilter/161

Note that all of these were deleted filters. Going forward, we should make sure we only query for active filters.

In T227843#5422012, @Huji wrote:

@Daimona I updated these: [...]

Thanks a lot! Only the filter on hewiki is left, now.

Note that all of these were deleted filters. Going forward, we should make sure we only query for active filters.

Yes, if disabled/deleted filters can be left unchanged (which sometimes could not be fine). To do that, just add AND af_enabled = 1 AND af_deleted = 0 to the query.

OK, so we can move on. There's nothing else we can do in AF itself, I believe. I'll keep an eye on logstash to see if we missed anything.

Change 533151 had a related patch set uploaded (by MaxSem; owner: MaxSem):
[mediawiki/extensions/WikimediaEvents@master] Remove user_wpzero AbuseFilter variable

https://gerrit.wikimedia.org/r/533151

Change 533151 merged by jenkins-bot:
[mediawiki/extensions/WikimediaEvents@master] Remove user_wpzero AbuseFilter variable

https://gerrit.wikimedia.org/r/533151