User talk:Xaosflux/Archive4

Too curious

I am often curious about why an edit/article got deleted/suppressed, but I usually don’t ask as I see as just a waste of time. But, recently an edit appeared on my talk page on en.wq that the username oversighted. Since I assume it was probably TOS violation and not sensitive information, I was wondering if I could possibly know what the username was (assuming non-sensitive). Thanks. (sorry for the unusual question) {link to edit} – Ilovemydoodle (talk) 03:03, 20 August 2022 (UTC)

@Ilovemydoodle enwq doesn't have local oversighters, so that must have been handled by a Steward, if you want to follow up with them you may use this form: Special:Contact/Stewards. The oversight removal criteria are here: Oversight policy#Policy; there are a wide range of cases that it could be, for example User:For a good time call Bob at +6518716181 would be suppressible. — xaosflux ^Talk 09:03, 20 August 2022 (UTC)

Done directly – Ilovemydoodle (talk) 09:21, 20 August 2022 (UTC)

 This section is resolved and can be archived. If you disagree, replace this template with your comment. Ilovemydoodle (talk) 09:32, 20 August 2022 (UTC)

Query

Hello, Xaosflux,

You were kind enough to create a Quarry query for me here to locate orphaned talk pages. It's been very useful and several editors use it or a similar query to find otherwise orphaned talk pages which are almost invisible. They are often article drafts by new editors or IP accounts that don't know they can create a draft. But what I've found after using this query daily is that it doesn't scan User talk pages because it would pick up tens of thousands of archived talk pages. And, unfortunately, Twinkle deletes redirects to deleted pages but doesn't delete redirect talk pages (despite my requests on the Twinkle talk page) so I think there are quite a lot of orphaned user talk pages leftover after stale drafts are deleted. AnomieBOT III picks up user talk pages that are broken redirects but many of these user talk pages aren't redirects, they have project banners on them instead.

Can you see any way where you could write for me a Quarry query for orphaned user talk pages that are just orphaned talk pages for sandboxes? I guess the format would be User talk:Liz/sandbox or User talk:Liz/sandbox/draft name. There are potentially quite a lot of these pages out there since Twinkle doesn't delete them and I've found that some admins never look to see if there is a talk page when they delete a draft or article. Thanks, in advance, if you can solve this problem! Liz (talk) 00:52, 17 September 2022 (UTC)

Hi Liz; just making sure I have an idea of the parameters you want, is it:

1. Pages in user_talk that include "/[S|s]andbox" in the title
2. Where a corresponding page in user namespace does not exist

• So For example, find User talk:Xaosflux/Sandbox6 (because User:Xaosflux/Sandbox6 does not exist); but don't find User talk:Xaosflux/Sandbox2 (because User:Xaosflux/Sandbox2 does exist).

Is that what you had in mind? — xaosflux ^Talk 08:57, 17 September 2022 (UTC)

Hello, Xaosflux,

That sounds right. I'm including "sandbox" in there, even though many editors just use the subject name of the article for their drafts, not sandbox, but I don't know how to allow for all those different subject names. And we are trying to avoid "archive" pages because User talk page archives never have accompanying User pages so they are all orphaned. This is why we can't include the User talk namespace in the original Quarry query you wrote for me. I stuck it in there as a trial once and the result was thousands of User talk page archives!

I suppose, if you could just adapt the original query to NOT select any pages that are user talk page archives (and marked "archives"), then we could just add the User talk page namespace to the original query. But whatever seems more likely to discover orphaned talk pages in User space that aren't talk page archives is what I'm aiming for.

Thanks for checking this talk page and for helping me with my quest! I'll be really interested in seeing how many of these pages are out there that aren't picked up by bot or database reports. Could be a dozen pages, could be hundreds! Liz (talk) 23:18, 17 September 2022 (UTC)

@Liz see if quarry:query/67448 outputs what you like? — xaosflux ^Talk 10:42, 18 September 2022 (UTC)

I'm heading out in the next few minutes but I'll try it out soon. Thanks, Xaosflux! Liz (talk) 22:31, 18 September 2022 (UTC)

Okay, I see the list, it will need to be more carefully gone through than the orphaned talk page list as it includes some odd content, like issues of the Signpost on a user tak page. And some of the pages are redirects to archived talk pages that don't use the word "archive".

My one specific suggestion to the code you wrote is could you also make sure that the results DON'T include the words/phases "TWA", "tutorial", "Signpost" or "newsletters"? Those tools seem to create User talk pages and should not be deleted. I moved a few of the TWA pages to regular User pages (none of the editors was active) but that is a page move I probably shouldn't repeat. Otherwise, it's exactly what I asked for. Thanks again! Liz (talk) 19:55, 19 September 2022 (UTC)

@Liz are you wanting to avoid pages with those other phrases in the page title or in the page text? I'm not sure how to do the later from a db query. — xaosflux ^Talk 20:50, 19 September 2022 (UTC)

I was just thinking of those words in the page title. That's what I'm scanning. I also changed "talk page tutorial" to just "tutorial". I didn't notice that you had already responded to the message. Liz (talk) 21:04, 19 September 2022 (UTC)

@Liz click on FORK at the top, then you can add more lines in between: AND

(talkpage.page_title NOT LIKE '%archive%')

Just add another set of those for each word you do not want in the page title. (There are more efficient ways to do this, but for a few words this should be fine). — xaosflux ^Talk 21:15, 19 September 2022 (UTC)

Brilliant, Xaosflux...it's better to learn what to do myself so I can adapt these queries. I'll let you know if I have any questions. Thanks for all of your help! Liz (talk) 23:55, 23 September 2022 (UTC)

Original query

Hello, Xaosflux,

I'm still working on the query and advice you posted above but now I'm haing a problem with the original one you wrote for me. After working fine for probably over a year, it is now failing when I try to run it and offering this error message:

Unknown column 'tl_title' in 'where clause'

I don't know what has changed in the past few days that this would no longer be working correctly. I haven't edited it. Looking at recently run queries, I am noticing others that have failed, too. Liz (talk) 17:46, 28 September 2022 (UTC)

Hmm, saw tasks like phab:T314041 suggest this is being changed - I wonder if @Ladsgroup: has a second to give advice on that query. — xaosflux ^Talk 18:15, 28 September 2022 (UTC)

@Xaosflux @Liz you need to change the tl_title to tl_target_id = 418257 would fix the query.

See:

select * from linktarget where lt_title = 'G8-exempt' and lt_namespace = 10;

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

| lt_id  | lt_namespace | lt_title  |

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

| 418257 |           10 | G8-exempt |

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

1 row in set (0,003 sec) Amir (talk) 18:39, 28 September 2022 (UTC)

https://quarry.wmcloud.org/query/67764 Amir (talk) 18:46, 28 September 2022 (UTC)

Thanks so much, Amir. I really appreciate your help...some day, I'll figure out coding. ;-) Liz (talk) 06:37, 2 October 2022 (UTC)

Talkback

You have new messages

Hello, Xaosflux. You have new messages at TheresNoTime's talk page.
You can remove this notice at any time by removing the {{Talkback}} or {{Tb}} template.

— TheresNoTime (talk • they/them) 11:59, 29 September 2022 (UTC)

Done — xaosflux ^Talk 13:25, 29 September 2022 (UTC)

Special:Redirect/logid/49584008

Hello, since I don't see any Farsi language knowledge stated on your talk page, I just wanted to ask whether you really wanted to delete this? There doesn't appear to be a problem with @AFlorence's translations (from 2015) at Special:Undelete/Template:Privacy policy navigation 2/fa that I would be able to find just by machine translation. ~~~~
User:1234qwer1234qwer4 (talk) 15:49, 30 September 2022 (UTC)

@1234qwer1234qwer4 cleaning up garbage translation elements are always a pain - something unintentional may have got caught up there. Feel free to restore any versions there you think are appropriate. — xaosflux ^Talk 16:38, 30 September 2022 (UTC)

Restored the translation page (for which I had to temporarily unmark the template from translation; not sure whether there is a Phab task about it) and all units except for the one that had been marked for deletion (also reverted what was apparently vandalism that only appeared on the translation when the other non-translation was posted). Please make sure to only delete the translation unit marked for deletion unless you really believe all translations are bad – the translation deletion interface with its two-step process should make it sufficiently clear when you are deleting what. ~~~~
User:1234qwer1234qwer4 (talk) 16:50, 30 September 2022 (UTC)

@1234qwer1234qwer4 thanks for the cleanup - the xlate system is such a mess and is ripe for non-sense vandals. I'd propose restricting edits to it, but in many cases that is the only way we get niche translators :/ — xaosflux ^Talk 16:52, 30 September 2022 (UTC)

Removing previous versions

Hello Xaosflux,
Can you remove previous versions of my user page? Thanks in advance.— MdaNoman (talk) 16:52, 9 October 2022 (UTC)

@MdaNoman I deleted your userpage, then restored just the last revision. — xaosflux ^Talk 17:50, 9 October 2022 (UTC)

HELP

Tracked in Phabricator:
Task T320473 resolved

Greetings @Xaosflux

I am both an Interface and regular admin on Tumbuka Wikipedia (Verify).

I discovered you are a global admin.

How do I change my wikis logo (which is in English) and replace it with one in my language found here.

Any suggestions or directions?

Your quick help, guide or action will be highly appreciated.

Thank you. Tumbuka Arch (talk) 15:51, 10 October 2022 (UTC)

@Tumbuka Arch Hello. To request a new logo be loaded for tumwiki please submit a site request using this form. Your new logo should be already created and published on commons; and if you have an active community it should be approved via a discussion on your project. When creating that request use the title "Replace site logo on tumwiki" or something very similar. — xaosflux ^Talk 16:02, 10 October 2022 (UTC)

@Xaosflux Thank you for your guide.

In fact, the logo is already available and I already requested it from the very same commons two months ago.

Just did not know how to change it.

I will now open a discussion on community page even though I am the only native speak there around.

Thank you. Tumbuka Arch (talk) 16:19, 10 October 2022 (UTC)

@Tumbuka Arch bascially: you can't change it directly. (Yes, there are technically some hacks where you could force a replacement locally - but it is the wrong way to do it). You can open the ticket now, a dev may say you need to wait for feedback, they may not. — xaosflux ^Talk 17:52, 10 October 2022 (UTC)

@Xaosflux I have just filed the form request on phabricator.

How does the the other way work? Tumbuka Arch (talk) 19:10, 10 October 2022 (UTC)

@Tumbuka Arch with script hacks, which would cause every single page to load slow and mess up caches. — xaosflux ^Talk 19:36, 10 October 2022 (UTC)

@Xaosflux The developers I contacted on phabricator haven't said anything yet and I don't think they will do it on time (if they will).

Pages loading slow is it permanent or temporary?

Is it similar to installing a mediawiki in a folder, dealing with PHs, Apaches, and MySQL?

If that is the similar case then I might be able to do it since I have already done it before on my personal testing wiki where I changed the default wiki logo in a folder and replaced it with mine. Tumbuka Arch (talk) 07:08, 11 October 2022 (UTC)

Yes, updating the logo folder and config is what needs to be done, but there is no front-end for that. That is why you needed to open your ticket, so that one of the back-end developers will do it for you; it is a now open on the workboard, someone will get to it. — xaosflux ^Talk 09:49, 11 October 2022 (UTC)

@Xaosflux yes I already requested it on Phabricator.

Thanks to you for directions and guides.

But one more thing, a weird to ask I guess, but really important to learn, how do you write those colorful signatures (or names). I have seen lots of users with that too but Wikipedia doesn't explain much about stylish color writing of usernames.

All in all, thank you for helping me contact the wiki logo team. Tumbuka Arch (talk) 11:36, 11 October 2022 (UTC)

You can change your signature in preferences here: Special:Preferences#mw-prefsection-personal; check the box for "wikitext signature", then you can use wikitext in there; for example you could put in: [[User:Tumbuka Arch|<span style="color:green;">Tumbuka Arch</span>]]</span> ([[User talk:Tumbuka Arch|talk]]) to make your username green. — xaosflux ^Talk 13:59, 11 October 2022 (UTC)

@Xaosflux Thanks.

I exactly did the same yesterday got an error "There are problems with some of your input.'' in color warning error.

[[User:Tumbuka Arch|<span style="color:green;">Tumbuka Arch</span>]]</span> ([[User talk:Tumbuka Arch|talk]]) (talk) 16:43, 11 October 2022 (UTC)

Other error : Your signature contains invalid or deprecated HTML syntax: 1 Stripped tag: span [[User:Tumbuka Arch|<span style="color:green;">Tumbuka Arch</span>]]</span> ([[User talk:Tumbuka Arch|talk]]) (talk) 16:44, 11 October 2022 (UTC)

• @Tumbuka Arch: in my example above, I had a syntax error (two /span's) - the fix is:

[[User:Tumbuka Arch|<span style="color:green;">Tumbuka Arch</span>]] ([[User talk:Tumbuka Arch|talk]])

• Hope that helps. — xaosflux ^Talk 17:22, 11 October 2022 (UTC)

  @XaosfluxThank you so much.

  Indeed it has worked!

  Thank you. Tumbuka Arch (talk) 21:39, 11 October 2022 (UTC)

GRATEFUL

Hello @Xaosflux

With your kind help and directions, along with your good heart , my wiki has now a logo of its own published. All this is because of how you explained and guided me.

Last time, I asked help about templates and you directed me well on enwiki, and now my wiki doesn't suffer about templates anymore.

Continue being such a good and friendly person.

You are really a good person.

Thank you for help.

Regards,

Tumbuka Arch (talk) 17:24, 19 October 2022 (UTC)

@Tumbuka Arch good news, glad it worked out for you! — xaosflux ^Talk 17:37, 19 October 2022 (UTC)

Global bot approval request for JhsBot

Hello!

In accordance to the policy, this message is to notify you that there is a new approval request for a global bot.

The discussion is available at Steward requests/Bot status#Global bot status for JhsBot on Meta-Wiki. All Wikimedia community members are invited to participate.

Thank you for your time.

Best regards,
--Martin Urbanec (talk) 23:25, 13 November 2022 (UTC)

Module:Text

Could you please delete this module? The looks useless tag I applied to Module:Text/doc was intended to apply to it as well. * Pppery * _{it has begun} 23:42, 13 November 2022 (UTC)

@Pppery ok, as it is unused. — xaosflux ^Talk 23:55, 13 November 2022 (UTC)

HELP

Hello @Xaosflux I am user Tumbuka Arch, this is my alternative account. I need your help and it is sort of emergency. Who might have a right to remove/disable 2nd factor authentication of anyone? My account Tumbuka Arch is inaccessible at the moment as the app that I get tokens from (Authy Desktop app) has crashed. I do have my email address and all login creditials, but not tokens. Your quick help, advice and steps will be highly appreciated. Thank you.

Tumbuka Arch 02 (talk) 09:46, 28 November 2022 (UTC)

@Main focus talk see Help:Two-factor authentication. The way to recover from a failed authentication device is with your "scratch codes". Outside of that, you can try to use the email address on that page to see if the foundation staff will help you. There is nothing we can about this on-wiki. — xaosflux ^Talk 11:32, 28 November 2022 (UTC)

@Xaosflux Thank you.

Yes, I have been reading about that.

What do I write on phabricator?

Not new there though, requested wiki logo through your help a month ago.

I still have my email + password of my account, also this account is using the same IP address, range and ISP as my main account. This could be verified by any Checkuser. Tumbuka Arch 02 (talk) 12:04, 28 November 2022 (UTC)

Also, this happened 20 hours ago. Last login to my account was yesterday. Tumbuka Arch 02 (talk) 12:07, 28 November 2022 (UTC)

@Main focus talk the phab part isn't that important. There is no on-wiki mechanism for handling this sort of issue, that is why you need to go to the foundation staff. During 2FA enrollment there should have been a warning that safely storing your scratch codes was extremely important - you should be able to log on with one scratch code, then use a second scratch code to disable 2FA. Then you will be able to start over again. — xaosflux ^Talk 16:41, 28 November 2022 (UTC)

Sound Logo CN banners

Hello! I noticed in your addition of enwiki to the Sound Logo banners, every language option except English was removed. According to the documentation, this would only show banners on meta and commons to people whose interface language is English, which is very much not intended. Do you know if this is the case, and if so how to avoid it? RAdimer-WMF (talk) 14:43, 9 December 2022 (UTC)

@RAdimer-WMF checking on this now. — xaosflux ^Talk 15:06, 9 December 2022 (UTC)

A fix could be to clone the campaign, one set to Meta and Commons in all languages, the other set to enwiki, if that’s feasible and the best option here. RAdimer-WMF (talk) 15:08, 9 December 2022 (UTC)

Yup, that's what I'm in the middle of doing right now. — xaosflux ^Talk 15:11, 9 December 2022 (UTC)

Awesome, thank you!! RAdimer-WMF (talk) 15:12, 9 December 2022 (UTC)

@RAdimer-WMF this should be done, apologies for the glitch. Updated notes at CentralNotice/Request/Wikimedia_Sound_Logo_contest_2#Central_Notice_admin_comments. — xaosflux ^Talk 15:16, 9 December 2022 (UTC)

Thanks!!!

So much for helping me! I don’t know how to thanks you more! The last available username (talk) 16:21, 21 January 2023 (UTC)

Any time! — xaosflux ^Talk 17:00, 21 January 2023 (UTC)

Images

Any idea on where I could find the local (not commons) images for the wikis? I have looked, but I could only find versions from 2005-2006/2012. – The last available username (talk) 21:17, 21 January 2023 (UTC)

@The last available username - Special:AllPages/File: and or Special:Newfiles; note the meta-wiki rarely uses "local" files, and only staff/admins can even upload them here. — xaosflux ^Talk 23:12, 21 January 2023 (UTC)

I meant a (dump) of images for enwiktionary, eswiktionary, frwiktionary, dewiktionary, enwikiquote, eswikiquote, frwikiquote, dewikiquote, enwikibooks, eswikibooks, frwikibooks, dewikibooks. Not metawiki. Sorry. The last available username (talk) 00:03, 22 January 2023 (UTC)

@The last available username as far as I know these aren't directly offered, though some external parties may build them. See w:en:Wikipedia:Database_download#Where_are_the_uploaded_files_(image,_audio,_video,_etc.)? for some info on that. — xaosflux ^Talk 01:03, 22 January 2023 (UTC)

Already seen, but I don’t really see how that helps. It basically just tells you to write your own script - which would probably be very slow to run and take a while to write. Thanks! The last available username (talk) 01:09, 22 January 2023 (UTC)

Which external parties? The only ones I found were from 2012. The last available username (talk) 01:10, 22 January 2023 (UTC)

@The last available username unknown ones. We never know who might mirror us; for example Internet Archive is an external party - it's up to them what they do or don't do. We don't provide "image dumps", especially because unlike text contributions they can have unfree licenses in many places. — xaosflux ^Talk 09:29, 22 January 2023 (UTC)

OK, then is there any script to download the files individually, or would I have to write one myself? The last available username (talk) 09:48, 22 January 2023 (UTC)

@The last available username no, and it may be generally discouraged - if you start doing massive downloads you could get blocked by the sysadmins. — xaosflux ^Talk 20:44, 22 January 2023 (UTC)

Okay....this seems like a catch-22, is there anyone I could contact to request a custom dump be made? The last available username (talk) 21:27, 22 January 2023 (UTC)

@The last available username try xmldatadumps-l@lists.wikimedia.org — xaosflux ^Talk 22:18, 22 January 2023 (UTC)

Why do I have to pay to receive a response?

Two days ago I am e-mailed xmldatadumps-l@lists.wikimedia.org about the images and have been eagerly waiting for a response.

Today, I open my indox and am delighted to see a response! So I open it and see this:

from: {{redacted}}@gmail.com (I can give you his e-mail if you need to know)

to: {{redacted}}@gmail.com



date: Jan 24, 2023, 6:54 AM

subject: [Xmldatadumps-l] Custom dump



Hi!



I use Gated to reduce noise in my inbox and benefit charity. I don’t recognize your email, so you’ll need to take one quick step to reach me:



* If we don’t know each other, make a small donation to support my nonprofit, International Fund For Animal Welfare 

* If we know each other personally, bypass the donation by verifying here



{{redacted}}

Why do I have to pay a minimum of two dollars to receive an answer from a free volunteer? Don't get me wrong, I would like to support charity, I just don't why it should be required for a "free" service. Is there a way to get around this, or do I have to pay? The last available username (talk) 14:13, 24 January 2023 (UTC)

That doesn't sound legit. I'll check it later today. — xaosflux ^Talk 15:02, 24 January 2023 (UTC)

It does appear to come from the official mailing-list, though.

Btw: "Larger donations get more attention and a higher likelihood of a reply." Yikes.

Supposedly, this supports the "International Fund For Animal Welfare"

I tried to post the url, but the edit was rejected by something called "Antivandalism (local)" The last available username (talk) 15:17, 24 January 2023 (UTC)

Just FYI, I've emailed the xmldatadumps-l list admins about this — this just seems to be an autoreply from a specific subscriber and should be ignored (https://www.gated.com seems like a nice service in principle, but should probably exclude mailing lists...) — TheresNoTime (talk • they/them) 16:18, 24 January 2023 (UTC)

Hey everybody, I think your initial email was moderated; maybe you sent it from an address that's not subscribed. It was passed through to the list earlier today. The donation thing has to be a scam. If you wouldn't mind forwarding the entire email, including headers, to ops-dumps@wikimedia.org, and we can act on it. Thanks! Note by the way that official replies, if any, will come from people with a wikimedia.org email address, but there are volunteers on the list who may often be able to help out. ArielGlenn (talk) 17:11, 24 January 2023 (UTC)

Okay, I have forwarded it, but I am still very confused. Why are scam charities being forwarded through Wikimedia mailing lists?

Also, is my original e-mail still being processed? The last available username (talk) 18:24, 24 January 2023 (UTC)

Please take this up on the mailing list to the address provided above, not here on my usertalk as I have nothing to do with that list. — xaosflux ^Talk 18:25, 24 January 2023 (UTC)

@The last available username there you go. — xaosflux ^Talk 17:58, 24 January 2023 (UTC)