[Wikitech-l] Re: SQL problem

be pretty slow. > > -- > Bawolff > > On Saturday 1 June 2024, Martin Domdey wrote: > >> Hi, >> >> I want to look in table comment column comment-text for %Unsinn% >> case-insensitive with this clause: >> >> where comment_text collate utf8mb4

[Wikitech-l] Re: SQL problem

execute that query exactly? > > суб, 1. јун 2024. у 17:57 Martin Domdey је > написао/ла: > >> Hi, >> >> I want to look in table comment column comment-text for %Unsinn% >> case-insensitive with this clause: >> >> where comment_text collate utf8mb4_ge

[Wikitech-l] SQL problem

Hi, I want to look in table comment column comment-text for %Unsinn% case-insensitive with this clause: where comment_text collate utf8mb4_general_ci like '%Unsinn%'; but this gives me error: COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'binary' How can I proceed such a

[Wikitech-l] pagelinks table defective?

Hi all, very simple queries don't work, what happened. It seems to be defective since about 30 minutes. select * from pagelinks; mysqlsel/db server: View 'dewiki_p.pagelinks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

[Wikitech-l] Re: AI phabricator profile

ible by default. > > AntiCompositeNumber > (he/him) > > On Tue, Jan 9, 2024 at 10:13 AM Martin Domdey wrote: > > > > Hi, > > > > how is it possible, that an AI knows about my Phabricator real name user > profile? > > > > Have AI access to WMF phabri

[Wikitech-l] AI phabricator profile

Hi, how is it possible, that an AI knows about my Phabricator real name user profile? Have AI access to WMF phabricator user profiles? Is this a security issue? Kind regards Doc Taxon ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org

[Wikitech-l] Re: mySQL query

JOIN revision > ON rev_actor = actor_id > JOIN page > ON rev_id = page_latest > WHERE page_id = 1; > > > Regards, > Zabe > > > Am 2023-12-30 23:28, schrieb Martin Domdey: > > Hi, > > > > can you send me a mySQL qu

[Wikitech-l] mySQL query

Hi, can you send me a mySQL query example please, how to get user.user_name of the user who edited page.page_latest ? Thank you very much Martin ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to

[Wikitech-l] Re: SVG and PNG in dewiki and enwiki not transparent any more

> Zoran > > пет, 17. нов 2023. у 21:09 Bartosz Dziewoński је > написао/ла: > >> On 2023-11-17 09:57, Martin Domdey wrote: >> > >> > but let's jump to Commons (and to Wikidata) please, to >> > >> https://commons.wikimedia.org/w/index.php?t

[Wikitech-l] Re: SVG and PNG in dewiki and enwiki not transparent any more

> > Yeah, it's making the issue. I made a PR on their GitHub which reverts > the commit that made this bug happen. > https://github.com/darkreader/darkreader/pull/11906 > > I'm really hoping that it'll be approved and merged soon. > > Best regards, > Zoran > > пет, 17.

[Wikitech-l] Re: SVG and PNG in dewiki and enwiki not transparent any more

Thank you, an example: On this page ( https://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Wappen ) there are many galleries with PNG and SVG having transparent backgrounds, but are shown with white background now since about eight hours. Before these 8 hours all was transparent what has to be

[Wikitech-l] SVG and PNG in dewiki and enwiki not transparent any more

Hi, since a short time all PNG and SVG files in galleries are shown with a white background where instead of transparent background where really a transparent background is. About seven hours ago all was fine, transparent background was transparent in galleries. In dewiki, frwiki, enwiki I

[Wikitech-l] Re: ALT+V for Visual Editor

t; If you want to remove all on-wiki accesskeys altogether, you can remove > the =v part from accesskey=v in that snippet. > > tor. 16. nov. 2023 kl. 08:49 skrev Martin Domdey : > >> Thank you! >> >> It's the second one of your suggestions. >> >>

[Wikitech-l] Re: ALT+V for Visual Editor

veAttr( 'accesskey' ); > > ons. 15. nov. 2023 kl. 22:43 skrev Martin Domdey : > >> Hello! >> >> Can you say me please how can I opt out the switch to Visual Editor by >> ALT+V ? >> >> Thank you >> Martin ... >> >> >> >

[Wikitech-l] ALT+V for Visual Editor

Hello! Can you say me please how can I opt out the switch to Visual Editor by ALT+V ? Thank you Martin ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org

[Wikitech-l] Re: odd effects after updates

Hi! Tell us about your problems please! Kind regards, Martin schrieb am Di., 31. Okt. 2023, 19:34: > Hello List, > i have updated an old wiki to the current 1.40 version but now > i have some strange effects that i do not understand. > Is that the right list to ask for help ? > > CU >

[Wikitech-l] Re: incorrect category entries / German Wikipedia

okay, thank you, with this I'll open a bug report. Do you know the extension or software, that categorizes the mentioned pages? Am Fr., 9. Juni 2023 um 10:46 Uhr schrieb Thiemo Kreuz < thiemo.kr...@wikimedia.de>: > Yea, that's really confusing. For consumers that read the page as > JavaScript

[Wikitech-l] Re: incorrect category entries / German Wikipedia

Hi Thiemo, it helps a little. The most interesting thing is, that within the mentioned .js pages is commented out. So it should not be read as deprecated alias, should it? Thanks Martin ... Am Fr., 9. Juni 2023 um 09:13 Uhr schrieb Thiemo Kreuz < thiemo.kr...@wikimedia.de>: > Both pages

[Wikitech-l] incorrect category entries / German Wikipedia

Hi, in German Wikipedia there are two incorrect entries in https://de.wikipedia.org/wiki/Kategorie:Wikipedia:Seite_mit_Syntaxhervorhebungsfehlern This category is filled by Mediawiki software, something like Syntaxhighlight-source-category or similar. Please explain, how it's possible, that

[Wikitech-l] Replag

Hi, it looks like there is a very big replication lag in dewiki. Is a debugging already in progress? Kind regards, Martin ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to

[Wikitech-l] Re: Phabricator Workboard Help

Thank you and kind regards Martin Andre Klapper schrieb am Fr., 28. Apr. 2023, 12:07: > Hi, > > On Fri, 2023-04-28 at 06:53 +0200, Martin Domdey wrote: > > But there's no "All tasks", > > see https://upload.wikimedia.org/wikipedia/commons/archive/2/28/202

[Wikitech-l] Re: Phabricator Workboard Help

But there's no "All tasks", see https://upload.wikimedia.org/wikipedia/commons/archive/2/28/20230428045221%21JPG_Test.jpg Am Fr., 28. Apr. 2023 um 06:44 Uhr schrieb Martin Domdey : > But there's no "All tasks", see appended screenshot. > > Martin > > > >

[Wikitech-l] Phabricator Workboard Help

https://phabricator.wikimedia.org/T335420 Hi, I want to list this resolved task on the workboard TaxonBot, but can't see it in Backlog or anywhere (I guess because it's resolved). Can you help me please? Thank you, Martin ... ___ Wikitech-l mailing

[Wikitech-l] Re: Help with sanitized css and templatestyles

Hm okay, thank you all! Martin ... Am Fr., 14. Apr. 2023 um 21:59 Uhr schrieb Bartosz Dziewoński < matma@gmail.com>: > There is unfortunately no way to do this. The feature request was > declined in 2021: https://phabricator.wikimedia.org/T271588#7296606 > (although it was with a note to

[Wikitech-l] Re: Help with sanitized css and templatestyles

@wikimedia.se > Telefon/*Phone*: (+46) 0707 - 92 03 84 > > > On Fri, 14 Apr 2023 at 01:20, Martin Domdey wrote: > >> css (commented out): >> https://de.wikipedia.org/wiki/Benutzer:Doc_Taxon/TestA/styles.css >> page: https://de.wikipedia.org/wiki/Benutzer:Doc

[Wikitech-l] Help with sanitized css and templatestyles

css (commented out): https://de.wikipedia.org/wiki/Benutzer:Doc_Taxon/TestA/styles.css page: https://de.wikipedia.org/wiki/Benutzer:Doc_Taxon/TestA Hi, I want to style the page body content with light blue background and double border like given in linked css (commented out). This style should be

[Wikitech-l] Re: Parsing a page: any sections missing

Hi Thiemo, since when is it so? February 22nd it worked properly last time. Kind regards Doc Taxon ... Am Do., 23. März 2023 um 19:35 Uhr schrieb Thiemo Kreuz < thiemo.kr...@wikimedia.de>: > The page contains __NOTOC__. That's why the "sections" property is empty. > > Best > Thiemo >

[Wikitech-l] Parsing a page: any sections missing

Hi, I'm parsing a page, but get not one section with page https://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Kategorien/Warteschlange , using this: https://de.wikipedia.org/wiki/Spezial:ApiSandbox#action=parse=json=Wikipedia%3AWikiProjekt%20Kategorien%2FWarteschlange=sections=2 The parsing of

[Wikitech-l] Re: VisualEditor inserting ``

Hi Robert and all, I would recommend using for the following reasons: 1) Text and XML editors that highlight XML syntax in different colours will highlight properly with but this is not always the case if you use 2) is backwards-compatible with XHTML and well-formed HTML (ie: XHTML) is

[Wikitech-l] Re: Wikipedia Library

being investigated. > > > > > > > > Kind regards, > > Sammy > > > > On Mon, 13 Feb 2023, 16:52 Martin Domdey, wrote: > >> > >> Hi! > >> > >> Is there an issue with W

[Wikitech-l] Wikipedia Library

Hi! Is there an issue with Wikipedia Library: https://wikipedialibrary.wmflabs.org/ It seems to be down. Kind regards Doc Taxon ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to

[Wikitech-l] Re: JSON of Lint errors list

Thank you very much, very helpful. Kind regards Martin ... Bartosz Dziewoński schrieb am Do., 19. Jan. 2023, 23:11: > Yes: > > > https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query=json=linterrors=2=obsolete-tag=401=3 > > -- > Bartosz Dziewoński >

[Wikitech-l] JSON of Lint errors list

Hi! Is it possible to parse a JSON of this Lint errors list, maybe by API or anyhow? https://en.wikipedia.org/w/index.php?title=Special:LintErrors/obsolete-tag=401=1=3= Thank you Martin ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org

[Wikitech-l] Re: Avoid invisible characters in page titles

Thank you, it seems that there's nobody working on it anymore, right? Kind regards, Martin ... Am Di., 17. Jan. 2023 um 12:28 Uhr schrieb Andre Klapper < aklap...@wikimedia.org>: > Hi, > > On Tue, 2023-01-17 at 12:03 +0100, Martin Domdey wrote: > > isn't it bett

[Wikitech-l] Avoid invisible characters in page titles

Hi, isn't it better to avoid invisible characters in page titles while creating the pages? Please look here, there has been problems with invisible characters working with it when parsing or page linking those page titles with invisible unicode characters:

[Wikitech-l] Fwd: [Maniphest] [Commented On] T274335: https://taxonbot.toolforge.org/ is a HTTP 503 error

Hi, if here's anyone who can help me, please check https://phabricator.wikimedia.org/T274335 to check out the ongoing problem. Subscribe please and reply there to hold the discussion in one discussion room only. Thanks a lot, DocTaxon ... -- Forwarded message - Von: Aklapper

[Wikitech-l] MediaWiki link tables

Hi! Can you describe next step of Normalize MediaWiki link tables as T299417 "Normalize templatelinks table" has already been done please? Thank you, Martin ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email

[Wikitech-l] Re: No Commons Uploads

-11-01 23:32, Martin Domdey wrote: > > is it known, that there cannot be uploaded a file to Commons right now? > > This doesn't seem to be the case, I see many files uploaded within the > last minute at https://commons.wikimedia.org/wiki/Special:Log/upload . > If you're experienci

[Wikitech-l] No Commons Uploads

Hi, is it known, that there cannot be uploaded a file to Commons right now? Martin ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org

[Wikitech-l] Request Timeout

Hi, it looks like there is nobody who can work on a bug or production error like this: https://phabricator.wikimedia.org/T316858 I don't think, that this is a production error but really a bug. If it's not possible to open a page ( https://de.wikipedia.org/wiki/Benutzer:Doc_Taxon/Test4 ) because

[Wikitech-l] Re: Deletion of 5000+ pages forbidden

Thanks for your reply. No, it's a portal service page with bot stuff only and without notable history at all. But how can a 5000+ page deletion crash any of your servers? In my opinion happens not much in databases. All the best, Martin Thiemo Kreuz schrieb am Di., 23. Aug. 2022, 13:35: >

[Wikitech-l] Deletion of 5000+ pages forbidden

Hi, please tell me, what is the thought behind the impossibility, that a normal admin can delete pages with more than 5000 revisions. Thank you Martin aka Doc Taxon ... ___ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send

[Wikitech-l] Re: MediaWiki core schema drifts with production databases

Thank you very much for the great job, if there are no tl_namespace and tl_title columns in table templatelinks, please don't forget to actualize https://www.mediawiki.org/w/index.php?title=Manual:Database_layout/diagram=render and https://www.mediawiki.org/wiki/Manual:Templatelinks_table All

Re: [Cloud] [Cloud-announce] Maintenance reboots upcoming (some of them TODAY)

Dear Andrew, Let us know please, when the reboots have been done. Thanks, Martin ... -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 11.01.2018, 20:02, Andrew Bogott schrieb: In a few minutes I'm going to start the first round of

Re: [Cloud] Tools that need user tables joins

Hi Maarten! I didn't got it by -announce, but I need it too in close future. Cheers, Martin ... -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 23.12.2017, 14:29, Maarten Dammers schrieb: Hi everyone, In the new database setup user

Re: [Mediawiki-api] Too big SQL query

Ah, before June 22nd the query has been done in less than 4 minutes [sic!]. Now it lasts more than 1 hour! -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 28.06.2017, 09:41, Martin Domdey <anima...@gmx.net> schrieb: Hi! MariaDB [dewiki_p]> select page_

[Mediawiki-api] Too big SQL query

Hi! MariaDB [dewiki_p]> select page_id, cl_to from page left join categorylinks on cl_from = page_id where !page_namespace and !page_is_redirect order by page_title; Before the query has been done, I get a database close but I cannot filter the query more. What can I do? Greetings, Martin

Re: [Mediawiki-api] Backlinks list order

Hi! Do we get data from different wikibase table columns using API linkshere or using API backlinks? Why is the one "less complicated and hacky" than the other? Greetings, Martin ... -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 03.06.2017, 09:24, Max

Re: [Mediawiki-api] How does yourdictionary obtains structured information from Wiktionary?

Wow! I have been looking for such as this. Thank you for that information, Martin ... -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 17.04.2017, 17:23, "Brad Jorsch (Anomie)" schrieb: On Mon, Apr 17, 2017 at 10:35 AM, Furkan Gözükara

Re: [Labs-l] Reimplementing account expiries

  Hi, X! is writing: "Hi, I am X! on Wikipedia, and known as Yetanotherx on other websites. I'm relatively inactive on Wikipedia now, and while I read it often, I mostly will stick to mainspace work. I no longer maintain my toolserver tools, those have been passed on to other maintainers. If

Re: [Mediawiki-api] Logging in to use action=edit from within Bash

But is it possible to do this using clean bash? Martin -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 30.01.2017, 20:26, Martin Urbanec schrieb: Hi,  Maybe pywikibot will be more better than doing this using

[Labs-l] T152456 - Increase resource quota for dwl

Hi Labs operators   I am of the opinion you didn't get T152456, did you? Please bring me up to date concerning this task.   Thank you, Martin Domdey     ___ Labs-l mailing list Labs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman

Re: [Labs-l] Tools NFS disruptive maintenance scheduled on 11/2 is being postponed to 11/14

Hi! The window was not so long as planned before. Thanks a lot for the fast and good job. Kind regards, Martin -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 15.11.2016, 06:39, Madhumitha Viswanathan schrieb: Hi

Re: [Labs-l] Disruptive Tools NFS maintenance on 11/2/2016

6 Hi,   On Fri, Oct 21, 2016 at 11:29 AM, Martin Domdey <anima...@gmx.net> wrote: Why do you need 48 hours for that?   I'm submitting very many cron jobs the day to deliver much stuff and services to a lot of users in dewiki and other wikis. An outage window of 48 hours (!) is simply no

Re: [Labs-l] Disruptive Tools NFS maintenance on 11/2/2016

Why do you need 48 hours for that?   I'm submitting very many cron jobs the day to deliver much stuff and services to a lot of users in dewiki and other wikis. An outage window of 48 hours (!) is simply not possible. Please suggest a solution how I can work on during the outage window or at

Re: [Labs-l] [Labs-announce] Tool Labs NFS space conservation (round 3)

But do not delete log, err and out of then running scripts, these are important for me. Thank you Martin -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 12.10.2016, 22:39, Chase Pettet schrieb: It was kindly

Re: [Labs-l] Outage in progress

It is possible to avoid that using a redundant network stack controller, isn't it?   Gesendet: Freitag, 25. September 2015 um 13:47 Uhr Von: "Jaime Crespo" An: "Wikimedia Labs" Betreff: Re: [Labs-l] Outage in progress There was a network

Re: [Labs-l] NFS outage in progress [UPDATE]

Hey Steini, soll noch mehrere Stunden dauern laut den Technikern ... Gesendet:Donnerstag, 18. Juni 2015 um 14:55 Uhr Von:Steinsplitter Wiki steinsplitter-w...@live.com An:Wikimedia Labs labs-l@lists.wikimedia.org Betreff:Re: [Labs-l] NFS outage in progress [UPDATE] Toolslabs will be back

Re: [Labs-l] NFS outage in progress [UPDATE]

Wikipedia Account Creation Team Mailing List Moderator On Jun 18, 2015, at 09:40, Steinsplitter Wiki steinsplitter-w...@live.com wrote: @Martin Domdey: hi, ist exakt das selbe was in der vorherigen mail zu finden ist, ich erwarte mir von seiten der foundation eine

Re: [Wikimedia-de-by] Was wir für Wikipedia in München wollen!

Hallo Willy und die anderen! Wenn Ihr bekannt gebt, dass Ihr das Schreiben unterzeichnet, wird Euer Name unten der Liste angefügt. Das wars schon... Vielen Dank, Euer Martin ... -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet. Willy Manchot

Re: [Labs-l] Installation of rlwrap

for software installation On Thu, Jan 22, 2015 at 1:59 AM, Martin Domdey anima...@gmx.net wrote: Dear Yuvi Panda, to use the tcl shell onto trusty.tools.wmflabs.org I need the program rlwrap to be installed onto. The program rlwrap is currently not installed. To run rlwrap please ask your

[Labs-l] Installation of rlwrap

Dear Yuvi Panda, to use the tcl shell onto trusty.tools.wmflabs.org I need the program rlwrap to be installed onto. The program rlwrap is currently not installed. To run rlwrap please ask your administrator to install the package rlwrap Thank you very much, Martin Domdey