User talk:RoySmith/Archive 39

Close some DRVs?
Hey Roy. I know you're focusing on other things these days, but there are a lot of DRVs that could use closing--too few regulars make hard closes hard. The only one where I think consensus is clear enough for a NAC and I didn't contribute is one I disagree with said consensus. Hobit (talk) 19:44, 27 April 2021 (UTC)
 * , No problem, I'll stop by and see what I can do. -- RoySmith (talk) 19:47, 27 April 2021 (UTC)
 * Thanks! Hobit (talk) 20:11, 28 April 2021 (UTC)
 * , No problem. It's a little frustrating that we're still arguing the same GNG vs SNG arguments that haven't been resolved after all these years. -- RoySmith (talk) 23:20, 28 April 2021 (UTC)
 * Went away for a while, but there has been a lot of pushing on some cricket bios and the closes have been all over the map because we don't have a resolution. Or at least not one we all agree on... Hobit (talk) 01:56, 29 April 2021 (UTC)
 * It's actually exceptionally frustrating because a consensus does exist regarding WP:NSPORT bios (2017 RfC) and WP:NSPORT is written in a way that requires WP:GNG. This particular argument should be resolved. If you can defeat an AfD by yelling loudly enough that a SNG is met, I don't know why I spend the time searching for sources to save the article... SportingFlyer  T · C  11:53, 29 April 2021 (UTC)

DYK for Rocking the Boat
Cwmhiraeth (talk) 12:02, 30 April 2021 (UTC)

Deleted article
Hello, could you check Draft:Isak Hansen-Aarøen and Draft talk:Isak Hansen-Aarøen. I added some reliable sources to the article. I think the draft needs to be restored to normal page. --Corwin of Amber (talk) 11:15, 30 April 2021 (UTC)
 * , Hi. My suggestion is submitting the draft for review and seeing what one of the AfC reviewers thinks.  My part in the process was strictly procedural, so I'll leave the judgement call to others.  I did happen to notice, however, that the draft cites WP:RSNP, which "is considered generally unreliable". -- RoySmith (talk) 14:09, 30 April 2021 (UTC)

Tech News: 2021-18
 Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Recent changes
 * Twinkle is a gadget on English Wikipedia. It can help with maintenance and patrolling. It can now be used on other wikis. You can get Twinkle on your wiki using the twinkle-starter GitHub repository.

Problems
 * The content translation tool did not work for many articles for a little while. This was because of a bug.
 * Some things will not work for about a minute on 5 May. This will happen around 06:00 UTC. This will affect the content translation tool and notifications among other things. This is because of an upgrade to avoid crashes.

Changes later this week
 * Reference Previews will become a default feature on a number of wikis on 5 May. This is later than planned because of some changes. You can use it without using Page Previews if you want to. The earlier plan was to have the preference to use both or none.
 * Octicons-sync.svg The new version of MediaWiki will be on test wikis and MediaWiki.org from . It will be on non-Wikipedia wikis and some Wikipedias from . It will be on all wikis from (calendar).

Future changes
 * Octicons-tools.svg The CSS classes,   and   do not work for mobile readers if they have not been specifically defined on your wiki. From June they will not work for desktop readers. This can affect gadgets and templates. The classes can be defined in MediaWiki:Common.css or template styles instead.

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. 

15:42, 3 May 2021 (UTC)

Sockpuppet investigations/Jenos450
Hi, You recently archived this Sockpuppet investigations/Jenos450/Archive. had closed it earlier and after closing, I reported them of an account in the SPI. The account very likely belongs to this master as the account was created after hours after the master was blocked and restored the sock edits in Vinayak Damodar Savarkar. Should I file another SPI about this account. Thanks SUN EYE 1 14:31, 4 May 2021 (UTC)
 * , Yes, please file another SPI under the same master name. Whoever looks as the case will know to also go back and check the archives for additional information.  Feel free to ping me if you have any additional questions. -- RoySmith (talk) 14:43, 4 May 2021 (UTC)
 * Thanks, I've filed the SPI (Sockpuppet investigations/Jenos450). Could you please take a look. SUN EYE 1 15:19, 4 May 2021 (UTC)

Evidence of sockpuppetry not on Wikipedia
What can I do to report evidence of sockpuppetry that is not on Wikipedia? --BananaYesterday (talk) 18:22, 4 May 2021 (UTC)
 * , You should contact a checkuser directly. See WP:CONTACTCU for how to do that; the tldr is to mail checkuser-en-wp@wikipedia.org. -- RoySmith (talk) 20:06, 4 May 2021 (UTC)

LTA and page protections
I'd have listed this at the SPI, but since it's already closed, I've left a request at RFPP for Romanian War of Independence. Do protect if you get there first. Cheers, RandomCanadian (talk / contribs) 23:18, 5 May 2021 (UTC)
 * , Which SPI are we talking about? -- RoySmith (talk) 23:26, 5 May 2021 (UTC)
 * Thought it was obvious from the page history, but in any case: Sockpuppet investigations/KızılBörü1071... RandomCanadian (talk / contribs) 23:31, 5 May 2021 (UTC)
 * , Got it, thanks. The first time I read this, I read it at Romulan War of Independence, which had me kind of confused :-) -- RoySmith (talk) 23:39, 5 May 2021 (UTC)
 * May the fourth be with you. Yes I know its the wrong one but the date is so close... You might have more luck with Romulans on other wikis :) RandomCanadian (talk / contribs)  23:49, 5 May 2021 (UTC)

Re-blocking sock IP
Hi Roy,

One of the sock IPs from Sockpuppet_investigations/Amfithea is active again and I'm...actually not sure how I'd go about getting them re-blocked. Do I need to re-open a case for an IP that was already judged to be the sockmaster, since the block has expired? Or is it sufficient to, you know, drop you a line since it's the same IP of the same banned user and the same behavior? –Roscelese (talk &sdot; contribs) 12:46, 7 May 2021 (UTC)
 * , The best thing to do is to open a new case. I'll take a look in the meantime, but please also open the case so it gets into the archives properly. -- RoySmith (talk) 12:55, 7 May 2021 (UTC)
 * Thanks, done. –Roscelese (talk &sdot; contribs) 13:10, 7 May 2021 (UTC)

Administrators' newsletter – May 2021
News and updates for administrators from the past month (April 2021). Administrator changes
 * Gnome-colors-list-remove.svg Enchanter • Carlossuarez46

Interface administrator changes
 * Gnome-colors-list-remove.svg Ragesoss

Guideline and policy news
 * Following an RfC, consensus was found that third party appeals are allowed but discouraged.
 * The 2021 Desysop Policy RfC was closed with no consensus. Consensus was found in a previous RfC for a community based desysop procedure, though the procedure proposed in the 2021 RfC did not gain consensus.

Technical news
 * The user group  will be renamed to  . This is for technical reasons. You can comment at  if you have objections.

Arbitration
 * The community consultation on the Arbitration Committee discretionary sanctions procedure was closed, and an initial draft based on feedback from the now closed consultation is expected to be released in early June to early July for community review.

Discuss this newsletter

Subscribe

Archive Sent by MediaWiki message delivery (talk) 15:52, 7 May 2021 (UTC)

Tech News: 2021-19
 Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Changes later this week
 * Octicons-sync.svg The new version of MediaWiki will be on test wikis and MediaWiki.org from . It will be on non-Wikipedia wikis and some Wikipedias from . It will be on all wikis from (calendar).

Future changes
 * You can see what participants plan to work on at the online Wikimedia hackathon 22–23 May.

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. 

15:09, 10 May 2021 (UTC)

SPI Case
In reference to the previous SPI Investigations against User &  who were into the PR work of Thiyya promotion a new SPI Case was opened which is still awaiting checkuser for more than 30 days. More sock accounts are being created also desisting their stale accounts one after the other, Seems to make it harder for a checkuser to retrieve the data and will force them to close the case as lack of evidence. As I was being alleged intentionally on the recent SPI case your assistance is much appreciated whether to start a new case by myself. R.C Outlander07@talk 07:47, 11 May 2021 (UTC)
 * , Hi, and thanks for your note. I do feel your pain; SPI is badly backed up and it's taking far longer to work on cases than anybody is happy with.  I wish I had something better to tell you. -- RoySmith (talk) 13:09, 11 May 2021 (UTC)
 * SPI is backed up, but checkuser specifically is not. The case in question did not have an active CU request, but I've put one in now. CMD (talk) 14:02, 11 May 2021 (UTC)

Another sock
Hi Roy. I'm afraid we have another DjdjPollard15 sock at User:DantheMad2021 at 2021 FA Cup Final (a high traffic article today).  The C of E God Save the Queen!  ( talk ) 15:26, 15 May 2021 (UTC)
 * , Could you open a SPI report please, so somebody can take a look at it? Thanks. -- RoySmith (talk) 16:45, 15 May 2021 (UTC)
 * Done.  The C of E God Save the Queen!  ( talk ) 16:18, 16 May 2021 (UTC)

Tech News: 2021-20
 Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Recent changes
 * There is a new toolbar in the Reply tool. It works in the wikitext source mode. You can enable it in your preferences.
 * Wikimedia mailing lists are being moved to Mailman 3. This is a newer version. For the character encoding to work it will change from  to.
 * Octicons-tools.svg An earlier issue of Tech News said that the citoid API would handle dates with a month but no days in a new way. This has been reverted for now. There needs to be more discussion of how it affects different wikis first.

Changes later this week
 * Octicons-tools.svg  will be renamed  . The list can be copied to the new name. It will happen on 19 May for some wikis and 20 May for some wikis. Most wikis don't use it. It lists images that should never be used as thumbnails for articles.
 * Octicons-sync.svg The new version of MediaWiki will be on test wikis and MediaWiki.org from . It will be on non-Wikipedia wikis and some Wikipedias from . It will be on all wikis from (calendar).

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. 

13:48, 17 May 2021 (UTC)

May 19: ONLINE WikiWednesday Salon NYC
(You can subscribe/unsubscribe from future notifications for NYC-area events by adding or removing your name from this list.)

--Wikimedia New York City Team 03:15, 18 May 2021 (UTC)

DS 2021 Review Update
Dear RoySmith,

Thank you for participating in the recent discretionary sanctions community consultation. We are truly appreciative of the range of feedback we received and the high quality discussion which occurred during the process. We have now posted a summary of the feedback we've received and also a preview of some of what we expect to happen next. We hope that the second phase, a presentation of draft recommendations, will proceed on time in June or early July. You will be notified when this phase begins, unless you choose to to opt-out of future mailings by removing your name here. --Barkeep49 & KevinL (aka L235) 21:05, 19 May 2021 (UTC)

Just asking one thing
So you know how you blocked Cyberfan195? I saw his contributions before he was blocked, but I don't see anything wrong with them. Can you please explain why you blocked him? Thanks,DinosaurTrexXX33 (talk) 13:04, 21 May 2021 (UTC)
 * , See Sockpuppet investigations/Cyberfan195/Archive -- RoySmith (talk) 13:18, 21 May 2021 (UTC)

Speedy deletion nomination of Category:18th-century Belgian sculptors


A tag has been placed on Category:18th-century Belgian sculptors indicating that it is currently empty, and is not a disambiguation category, a category redirect, a featured topics category, under discussion at Categories for discussion, or a project category that by its nature may become empty on occasion. If it remains empty for seven days or more, it may be deleted under section C1 of the criteria for speedy deletion.

If you think this page should not be deleted for this reason you may contest the nomination by visiting the page and clicking the button labelled "Contest this speedy deletion". This will give you the opportunity to explain why you believe the page should not be deleted. Please do not remove the speedy deletion tag from the page yourself. Liz Read! Talk! 13:36, 22 May 2021 (UTC)
 * , Hmmm, I see I created this cat a while ago, but if it's no longer in use, I certainly have no objection to it being deleted. Thanks for the ping. -- RoySmith (talk) 16:41, 22 May 2021 (UTC)

I removed a template you had posted
Hello, Roysmith! Wanted to inform you that I removed the photo-requested template you had added to Talk:Black Lives Matter last month. I removed it because, as you'd anticipated, the fence has been painted over by now. Still if you think someone may have taken a picture and might still upload it upon reading the request, I can restore it again. This template didn't inform me about what kind of photo was requested, however. Initially I thought it was an ancient request for any photograph at all. I had to go through the page's history (where I then also saw your post) in order to understand it. Take care. ---Sluzzelin talk  19:51, 19 May 2021 (UTC)
 * , Sadly, I didn't know of any better way to get the attention of potential photographers. Sad, really, in so many ways. -- RoySmith (talk) 13:24, 21 May 2021 (UTC)
 * Oh, but you did, and Myotus responded! Only now, had I spotted Wikipedia_talk:WikiProject_Minnesota. Thanks to both of you! ---Sluzzelin talk  14:43, 21 May 2021 (UTC)
 * Wow, I missed noticing that! Thanks Myotus!  RoySmith-Mobile (talk) 16:36, 21 May 2021 (UTC)
 * Your welcome. Thanks for bringing it to my attention. Myotus (talk) 21:37, 22 May 2021 (UTC)
 * , BTW, I derived File:Black Lives Matter Fence (crop).jpg from yours, and used that in Black Lives Matter -- RoySmith (talk) 21:51, 22 May 2021 (UTC)

DYK nomination of Walter Gladwin
Hello! Your submission of Walter Gladwin at the Did You Know nominations page has been reviewed, and some issues with it may need to be clarified. Please review the comment(s) at your nomination's entry and respond there as soon as possible. Thank you for contributing to Did You Know! Carbrera (talk) 01:31, 24 May 2021 (UTC)

Tech News: 2021-21
 Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Recent changes
 * The Wikimedia movement has been using IRC on a network called Freenode. There have been changes around who is in control of the network. The Wikimedia IRC Group Contacts have decided to move to the new Libera Chat network instead. This is not a formal decision for the movement to move all channels but most Wikimedia IRC channels will probably leave Freenode. There is a migration guide and ongoing Wikimedia discussions about this.

Changes later this week
 * Octicons-sync.svg The new version of MediaWiki will be on test wikis and MediaWiki.org from . It will be on non-Wikipedia wikis and some Wikipedias from . It will be on all wikis from (calendar).

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. 

17:05, 24 May 2021 (UTC)

Sandesh9822
Reminding here about Sockpuppet investigations/Sandesh9822. Maybe you didn't had my ping but nevertheless you seem really busy so you might have missed. Srijanx22 (talk) 23:04, 28 May 2021 (UTC)
 * , Unfortunately, the time I have available for SPI is quite limited these days. and this is a particularly complicated case so it'll require a substantial investment of time to look at. I'm afraid it'll need to wait for somebody else to get to it. -- RoySmith (talk) 23:12, 28 May 2021 (UTC)

Sockpuppet investigations/Danny794986432981
There's something wrong with the above case. Can you please fix it?--Bbb23 (talk) 01:41, 30 May 2021 (UTC)
 * I'm clearly very tired. Nothing for you to fix. It was the filer's fault. Sorry to have bothered you.--Bbb23 (talk) 01:47, 30 May 2021 (UTC)
 * , No problem. BTDT :-) -- RoySmith (talk) 02:00, 30 May 2021 (UTC)

Speedy deletion nomination of Category:18th-century Belgian artists


A tag has been placed on Category:18th-century Belgian artists indicating that it is currently empty, and is not a disambiguation category, a category redirect, a featured topics category, under discussion at Categories for discussion, or a project category that by its nature may become empty on occasion. If it remains empty for seven days or more, it may be deleted under section C1 of the criteria for speedy deletion.

If you think this page should not be deleted for this reason you may contest the nomination by visiting the page and clicking the button labelled "Contest this speedy deletion". This will give you the opportunity to explain why you believe the page should not be deleted. Please do not remove the speedy deletion tag from the page yourself. Liz Read! Talk! 15:07, 30 May 2021 (UTC)

Unspecified source/license for File:Screen shot showing tag-check and spi-tools running twice.png
Thanks for uploading File:Screen shot showing tag-check and spi-tools running twice.png. The image has been identified as not specifying the copyright status of the image, which is required by Wikipedia's policy on images. Even if you created the image yourself, you still need to release it so Wikipedia can use it. If you don't indicate the copyright status of the image on the image's description page, using an appropriate copyright tag, it may be deleted some time after the next seven days. If you made this image yourself, you can use copyright tags like (to release all rights),  (to require that you be credited), or any tag here - just go to the image, click edit, and add one of those. If you have uploaded other images, please verify that you have provided copyright information for them as well.

For more information on using images, see the following pages:
 * Image use policy
 * File copyright tags

This is an automated notice by MifterBot. For assistance on the image use policy, see Media copyright questions. NOTE: Once you correct this, please remove the tag from the image's page. --MifterBot (Talk • Contribs • Owner) 16:45, 31 May 2021 (UTC)

Tech News: 2021-22
 Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Problems
 * There was an issue on the Vector skin with the text size of categories and notices under the page title. It was fixed last Monday.

Changes later this week
 * There is no new MediaWiki version this week.

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. 

17:04, 31 May 2021 (UTC)

Sockpuppet investigations/Phoenix man
Hello admin, Have a look at this section. I am suspected as the sock of Pheonixman. The reason nominator produced is my name. Yes, my name is Sharath Abhivadyah, there are around 1000+ Sharath Abhivadyahs in India. Actually, I don't know what's going around! I nominated some schools which fails WP:NSCHOOL user:Beccaynr claimed that is the same behaviour as the sock. You can check out all those, I stated this project as powerful karma and later renamed to AgentCody. I've nominated and voted around 97 articles. The schools I nominated as very less compared to biographies. Please solve this issue ASAP if possible. Thank you. Regards, Agent</b><b style="color:#BBA">Cody</b></b> 01:53, 1 June 2021 (UTC)

User:RoySmith/test
Hello, Roy,

I was looking at a template deletion discussion and wanted to see what pages the template was used on and came across your user page. The article this page was based on was just deleted in a AFD deletion discussion. Not sure if this impacts whether or not you want it in your user space but thought I'd let you know. Liz <sup style="font-family: Times New Roman; color: #006400;">Read! Talk! 05:06, 4 June 2021 (UTC)
 * , That was for help in debugging, but no, it's not of any use anymore. I'll delete it. -- RoySmith (talk) 12:54, 4 June 2021 (UTC)

DYK for Walter Gladwin
Cwmhiraeth (talk) 12:03, 7 June 2021 (UTC)

Tech News: 2021-23
<section begin="tech-newsletter-content"/> Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Changes later this week
 * Octicons-sync.svg The new version of MediaWiki will be on test wikis and MediaWiki.org from . It will be on non-Wikipedia wikis and some Wikipedias from . It will be on all wikis from (calendar).

Future changes
 * The Wikimedia movement uses Phabricator for technical tasks. This is where we collect technical suggestions, bugs and what developers are working on. The company behind Phabricator will stop working on it. This will not change anything for the Wikimedia movement now. It could lead to changes in the future.
 * Searching on Wikipedia will find more results in some languages. This is mainly true for when those who search do not use the correct diacritics because they are not seen as necessary in that language. For example searching for  doesn't find   on German Wikipedia. The character   isn't used in German so many would write   instead. This will work better in the future in some languages.
 * Octicons-tools.svg The CSRF token parameters in the action API were changed in 2014. The old parameters from before 2014 will stop working soon. This can affect bots, gadgets and user scripts that still use the old parameters.

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. <section end="tech-newsletter-content"/>

20:01, 7 June 2021 (UTC)

ANI
Please undo your close at AN, I was in the process of a formal proposal and I hardly think that conversation is done. <span style="color: white; font-weight: bold; background: linear-gradient(red, orange, green, blue, indigo, violet)">PRAXIDICAE🌈 23:28, 8 June 2021 (UTC)
 * , The guy says he's retired. I don't honestly see how dragging this out will be useful. -- RoySmith (talk) 23:48, 8 June 2021 (UTC)
 * People often retire to escape sanctions and the conversation was far from over. <span style="color: white; font-weight: bold; background: linear-gradient(red, orange, green, blue, indigo, violet)">PRAXIDICAE🌈 01:45, 9 June 2021 (UTC)
 * , I really can't see how anything useful will come of reopening the thread. If he stays retired, the problem is solved.  If he comes back and starts being disruptive again, we can deal with it then. -- RoySmith (talk) 02:24, 9 June 2021 (UTC)

Administrators' newsletter – June 2021
News and updates for administrators from the past month (May 2021). Administrator changes
 * Gnome-colors-list-add.svg Ashleyyoursmile • Less Unless
 * Gnome-colors-list-remove.svg Husond • MattWade • MJCdetroit • Carioca • Vague Rant • Kingboyk • Thunderboltz • Gwen Gale • AniMate • SlimVirgin (deceased)

Guideline and policy news
 * Consensus was reached to deprecate Editor assistance.
 * Following a Request for Comment the Book namespace was deprecated.

Technical news
 * Wikimedia previously used the IRC network Freenode. However, due to changes over who controlled the network with reports of a forceful takeover by several ex-staff members, the Wikimedia IRC Group Contacts decided to move to the new Libera Chat network. It has been reported that Wikimedia related channels on Freenode have been forcibly taken over if they pointed members to Libera. There is a migration guide and Wikimedia discussions about this.

Arbitration
 * After a Clarification request, the Arbitration Committee modified Remedy 5 of the Antisemitism in Poland case. This means sourcing expectations are a discretionary sanction instead of being present on all articles. It also details using the talk page or the Reliable Sources Noticeboard to discuss disputed sources.

Discuss this newsletter

Subscribe

Archive Sent by MediaWiki message delivery (talk) 14:46, 9 June 2021 (UTC)

INTSF SPI
Hi RoySmith, regarding this SPI, some of the accounts reported earlier are now old enough that they are autoconfirmed and being reactivated to bypass semi. If you don't have time to deal with the more complicated cases, it would be appreciated if you could nonetheless block the obvious ones. Best, CMD (talk) 02:09, 7 June 2021 (UTC)
 * , Ugh. Yeah, I've been kind of busy lately, but I'll take a look.  Thanks for the ping. -- RoySmith (talk) 02:25, 7 June 2021 (UTC)
 * , Oh, yeah, ugh for sure. I'm probably not going to be able to make much headway there, but if you could compile a list of pages that would most benefit from WP:ECP, that I could probably do quickly. -- RoySmith (talk) 02:28, 7 June 2021 (UTC)
 * Yeah, it's a long report at the moment. If I might make a suggestion, it could help to start with the 09 May 2021 report and work backwards, as most of those are obvious attack or one-off accounts (added to since 9 May, but all obvious ones, and some are already blocked).On protection, semi would be useful on Asbestos, Singapore Airlines, City-state, Singapore model. The two currently semied articles are Politics of the Philippines (purely for harassment against me) and Singapore passport (standard area of focus), and I suspect blocks would work fine, but both are also reasonably low traffic with not many editors or IPs so ECP probably wouldn't affect them too much if you prefer. (edit: Also my talkpage, but please don't ECP that.) CMD (talk) 03:30, 7 June 2021 (UTC)
 * , I put ECP on those first four. I'll try to find some time to work through some of the SPI (but can't promise anything there). -- RoySmith (talk) 11:58, 7 June 2021 (UTC)

Regarding the 08 May 2021 case close (Commenting here since it was marked closed), I disagree with not blocking the "burner" accounts. There's a long history of sleepers here, and some "burner" accounts have been reactivated literally within the past couple of days to avoid semi, so they are clearly being kept track of. Not blocking makes the aggressive protection idea much less useful. CMD (talk) 10:04, 8 June 2021 (UTC)
 * , I understand your frustration here, but SPI is badly backed up and we just don't have the time to give every case the attention it deserves. We're doing the best we can.
 * When we ask filers to give us more information or diffs, it's not that we're pushing back, it's that you know stuff that we don't and we're just trying to discover what it is. For example, when you wrote, Even if there wasn't an IP, there's some clear aspects of those edits which catch my attention, that really doesn't advance the case because you haven't told us what those aspects are.  If it's something you'd rather not disclose in public, just note that and offer to mail the details to whoever is investigating the case. -- RoySmith (talk) 11:57, 8 June 2021 (UTC)
 * I was referring above to the 08 May 2021 section, not the 02 April 2021 one. Happy to provide more 08 May 2021 diffs, or further explain the aspects relating to 02 April 2021 if that would help. CMD (talk) 12:14, 8 June 2021 (UTC)
 * , The more information you can provide, the easier it is to make progress. And the best information is pairs of specific diffs.  As another example, in 13 April, you wrote, Mindandaeno's only edit is to restore previous LTA.  Look at that from the point of view of a clerk working the case.  You haven't identified the specific edit that was being restored.  You haven't even identified which sock made the edit.  So, the clerk needs to go hunting to find it.  You already have that information.  You obviously have found some previous edit which was restored.  So just put the link to the diff in the SPI report.  That makes the clerk's job trivial.  If the clerk has to go hunting to rediscover the information that you've already found but haven't shared, well, that's how SPI gets backed up so badly. -- RoySmith (talk) 12:45, 8 June 2021 (UTC)
 * Noted, I'll take another look through the various reports in a bit. I think that at the time I was trying to keep a record of the sudden proliferation of socks, so the per-sock report quality dropped. CMD (talk) 13:12, 8 June 2021 (UTC)
 * Now done, including for 08 May 2021, which I hope you will be able to take another look at even though it was technically closed. I tried to make it very clear what the relationship of each account was to previous ones, and/or mention various behavioural details. (I even uncovered a previously missed account, although I didn't detail it.) I hope I am not sounding ungrateful for the work you have done, or sounding too frustrated. I appreciate very much the backlog, and only brought it up here because some of the accounts had gotten autoconfirmed and re-activated. I hope that what I've written now can make the remaining assessments very easy, and I expanded on a report by another user too which should make that one even clearer. Let me know again if there is more i could help with. CMD (talk) 11:29, 9 June 2021 (UTC)
 * , I've worked my way through the INTSF backlog. Thank you for providing the specific diffs, that made it easy.  If any of the accounts left unblocked start being disruptive again, please open a new report, and as always, it's going to be specific diff pairs that will make it possible for a clerk to make any progress.
 * Given the extensive use of proxies and volume of new accounts, page protection will almost certainly be a better tool than blocking in this case, not to mention that WP:RFPP is always faster to respond than SPI. Given the history here, my recommendation would be to ask for ECP of at least 6 months right off the bat, and refer to the SPI and/or this note if the RFPP folks are hesitant to do that. -- RoySmith (talk) 16:48, 9 June 2021 (UTC)
 * Thanks, this is noted. I'll try it now. How do I provide diffs for harassment accounts though? Diff my edit and their revert or something? I find it a bit odd they were the ones left unblocked, it feels they'd be the most obvious to determine. CMD (talk) 00:42, 10 June 2021 (UTC)
 * , I remember looking at those and not being clear on why it was harrassment. So, basically you need to walk the clerk through it.  "I did this edit, then the sock reverted it here, and then I did..., and the sock did...".  Keep in mind that by the time you file an SPI report, you're much more familiar with the case than the processing clerk is.  The clerk knows the procedures, and is authorized to perform certain actions, but you're the one who knows the history.   And given how badly backed up SPI is, when a clerk is faced with a difficult or complex case, they're likely to just move onto a simpler case.  So it's in your best interest to make it as simple for them as possible. -- RoySmith (talk) 00:55, 10 June 2021 (UTC)
 * Thanks, this is noted. I'll try it now. How do I provide diffs for harassment accounts though? Diff my edit and their revert or something? I find it a bit odd they were the ones left unblocked, it feels they'd be the most obvious to determine. CMD (talk) 00:42, 10 June 2021 (UTC)
 * , I remember looking at those and not being clear on why it was harrassment. So, basically you need to walk the clerk through it.  "I did this edit, then the sock reverted it here, and then I did..., and the sock did...".  Keep in mind that by the time you file an SPI report, you're much more familiar with the case than the processing clerk is.  The clerk knows the procedures, and is authorized to perform certain actions, but you're the one who knows the history.   And given how badly backed up SPI is, when a clerk is faced with a difficult or complex case, they're likely to just move onto a simpler case.  So it's in your best interest to make it as simple for them as possible. -- RoySmith (talk) 00:55, 10 June 2021 (UTC)

An IP you range blocked recently
Greetings RoySmith. An IP you range blocked recently, 183.90.36.0/23, is actually not a proxy. It's a dynamic range of one of the main telecommunications providers of Singapore. That would mean there's potentially up to ten of thousands of unique users on that IP range within any given time, and some might be enthusiastic users of Wikipedia unrelated as being a sockpuppet. As we can see, the last time this IP was blocked for only a month, there were three occasions (1, 2 and 3) where innocent individuals were caught by the block, and couldn't edit as a result. I also don't think ineedotstopforgetting would even use this IP range as they are probably smarter than that, especially considering that they are not a new investigation and that this would cause instant detection.

My point is that we shouldn't be quick to assume and associate every edit related to Singapore as being the doing of ineedtostopforgetting, as this could negatively affect many other potential users from Singapore or the region from editing its WikiProject. For starters, when the IP was re-blocked again just days after the end of its month-long block due to Chipmunkdavis' reporting its possibility of it being a sock for one of the IP's editing on Singapore Airlines, it shouldn't be far fetched that it was probably just the work of a local aviation enthusiast editing the airline from their country, and not a malicious sockpuppet of ineedtostopforgetting. There's probably many more examples but I'm pointing this recent one out as it was the cause of it getting blocked once more. Cheers.

Also no before anyone asks, I'm not a sockpuppet of anyone, just an observer that desires anonymity who was previously affected by a similar but unrelated situation. SantiniXER (talk) 05:20, 10 June 2021 (UTC)

IP user and the current sockpuppet block
Hello !, This IP user 49.149.72.236 has been currently adding some pictures again and the same edits of the current blocked sockpuppet account, Philippine 1812, of Cathay Pacific and Cathay Pacific fleet. I don't know what to say but I kinda stress with that IP user or anyone that adds more airline pictures. I mean, it's really not important to add more, but WP:EW it is. What's your opinion about this IP user? Cornerstone2.0 (talk) 15:19, 11 June 2021 (UTC)
 * , Could you please open a new SPI report, that'll make it easier to process. Thanks. -- RoySmith (talk) 16:01, 11 June 2021 (UTC)
 * PS. the correct case is Mark Maglasang -- RoySmith (talk) 16:02, 11 June 2021 (UTC)

sure thing. Thanks! Cornerstone2.0 (talk) 16:03, 11 June 2021 (UTC)

Hello there, It says "An automated filter has identified this edit as potentially unconstructive, so it has been disallowed. If this edit is constructive, please report this error. Disruptive editing may result in a block from editing." What should I do? Cornerstone2.0 (talk) 16:25, 11 June 2021 (UTC)
 * , Hmmm, not sure what you did to get that, but don't sweat it. I can generate the report myself, in a few minutes. -- RoySmith (talk) 16:27, 11 June 2021 (UTC)

okay, thank you very much! Cornerstone2.0 (talk) 16:28, 11 June 2021 (UTC)

This is my first time of reporting a user, so please bear with me. I commented in below (comment by others) with the links of his/her edit. Cornerstone2.0 (talk) 17:27, 11 June 2021 (UTC)

SQL
I saw your at WP:ANI & had a go at adding wiki links. My effort is not pretty, and could do with some workaround to avoid using UNIONs. Just pointing you there in the hope you're up for further improving it. No worries if not. Cabayi (talk) 12:47, 12 June 2021 (UTC)
 * , Thanks, but SQL is really not my strong suit. I putter around with simple queries, but that's about it.  I guess what you're doing here is looking up the namespace names, but I'm not following the details and why you need the unions.
 * I'm still trying to figure out why times out.  If I leave off the join with change_tag_def, it's fine.  Something about that join obviously makes it unable to use an index, but beats me why. -- RoySmith (talk) 13:25, 12 June 2021 (UTC)
 * I'm still trying to figure out why times out.  If I leave off the join with change_tag_def, it's fine.  Something about that join obviously makes it unable to use an index, but beats me why. -- RoySmith (talk) 13:25, 12 June 2021 (UTC)


 * Looking for answers I just stumbled across this :-)
 * The query needs UNIONs (unless there's a better way) because the links need handling in different ways.
 * A previous way I was formatting the query (with a leading :w:en:) meant articles were coming out with a leading ::, without that, and looking at it again, articles are OK with a single leading colon. For categories, category:page would attempt to categorise the page rather than link to the category. It needs a distinct way of presenting the pages as wikilinks. Down to two queries, one UNION, hooray!


 * For, (from my ever-more-distant memory of how Oracle used to handle queries)
 * it needs to retrieve all the rows for ordering, then it'll discard all but the 10 rows you want, the 10 with the highest rev_id. The ORDER ensures that the LIMIT is meaningless in terms of restricting the processing needed. Cabayi (talk) 14:15, 12 June 2021 (UTC)
 * it needs to retrieve all the rows for ordering, then it'll discard all but the 10 rows you want, the 10 with the highest rev_id. The ORDER ensures that the LIMIT is meaningless in terms of restricting the processing needed. Cabayi (talk) 14:15, 12 June 2021 (UTC)

If you restrict the query to the latest 1000 rows of change_tag (assuming ct_rev_id is sequential) rather than its full complement of 145 million rows it works... -- Cabayi (talk) 14:59, 12 June 2021 (UTC)
 * , Ah, yeah, I've run into that before, thanks. See, I told you SQL isn't my strong suit :-) -- RoySmith (talk) 15:00, 12 June 2021 (UTC)
 * And I've got down to a single query :-) Oh happy days! Cabayi (talk) 15:28, 12 June 2021 (UTC)
 * , It's really annoying that there's no namespace table in the database. If only there was some way of embedding the number:name mapping in enwiki_p.in a way you could parse out the information you needed with string functions... . -- RoySmith (talk) 16:19, 12 June 2021 (UTC)
 * Even better, -- RoySmith (talk) 16:34, 12 June 2021 (UTC)
 * A not-clever, brute force version -.
 * However, the  magic word method has the merit of not being tied to any specific language wiki, and (plus point or minus point, depending on your need) has the wiki software do the work. Cabayi (talk) 20:36, 12 June 2021 (UTC)
 * , See also Village_pump_(technical). -- RoySmith (talk) 21:14, 12 June 2021 (UTC)
 * Not sure if it helps - but revision_userindex (and logging_userindex) are indexed tables - and will be likely to go much faster than using revision or logging. See: wikitech:Help:Toolforge/Database. I've also always found MusikAnimal's SQL Optimizer super helpful. <sup style="font-size: 5pt;color:#999">!ɘM γɿɘυϘ ⅃ϘƧ  23:03, 12 June 2021 (UTC)

June 16: ONLINE WikiWednesday Salon NYC
(You can subscribe/unsubscribe from future notifications for NYC-area events by adding or removing your name from this list.)

--Wikimedia New York City Team 16:20, 14 June 2021 (UTC)

Tech News: 2021-24
<section begin="tech-newsletter-content"/> Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Recent changes
 * Logged-in users on the mobile web can choose to use the advanced mobile mode. They now see categories in a similar way as users on desktop do. This means that some gadgets that have just been for desktop users could work for users of the mobile site too. If your wiki has such gadgets you could decide to turn them on for the mobile site too. Some gadgets probably need to be fixed to look good on mobile.
 * Language links on Wikidata now works for multilingual Wikisource.

Changes later this week
 * There is no new MediaWiki version this week.

Future changes
 * In the future we can't show the IP of unregistered editors to everyone. This is because privacy regulations and norms have changed. There is now a rough draft of how showing the IP to those who need to see it could work.
 * German Wikipedia, English Wikivoyage and 29 smaller wikis will be read-only for a few minutes on 22 June. This is planned between 5:00 and 5:30 UTC.
 * All wikis will be read-only for a few minutes in the week of 28 June. More information will be published in Tech News later. It will also be posted on individual wikis in the coming weeks.

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe. <section end="tech-newsletter-content"/>

20:25, 14 June 2021 (UTC)

Moved to archive
Hello ! Maybe we can moved to archive of the previous sockpuppet investigation last week of Sockpuppet investigations/Mark Maglasang..? Hope someone can moved it. Cornerstone2.0 (talk) 13:35, 15 June 2021 (UTC)
 * , It's in the queue to get archived. Somebody will get to it when they have time. -- RoySmith (talk) 13:43, 15 June 2021 (UTC)

RoySmith, oh.. well okay then.. I understand that.. thanks for your response! :)) Cornerstone2.0 (talk) 13:47, 15 June 2021 (UTC)