[08:23:33] !log tools.heritage Deploy latest from Git master: 39aec68, 59e2ffb [08:24:47] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.heritage/SAL [08:39:26] bd808: thanks! appreciate it [12:42:17] !log openstack Set Icingia downtime on cloudcontrol100[34]and cloudservices100[34] for database switch over T229657 [12:42:19] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Openstack/SAL [12:42:20] T229657: Switchover m5 primary master: db1073 to db1133: Tuesday 3rd Sept at 13:00 UTC - https://phabricator.wikimedia.org/T229657 [12:53:15] The previously announced cloud VPS database maintenance will start in ~10 minutes. During this maintenance window only the OpenStack management services and browser will be unavailable. [12:54:47] This will not impact any existing virtual machines or tools in toolforge. [13:40:23] The Cloud VPS database maintenance is completed [18:09:55] hello all, does anyone know how to download a wikipedia article with embedded urls in Cyrillic? These foreign language urls are not saved clearly in the options like text files in the browsers chrome of modzilla. [18:32:44] tomthirteen: Hello, you may have better luck asking in #wikimedia-tech, as that channel is meant for technical support for wikimedia wikis! [18:49:43] tomthirteen: what is an "embedded URL"? [18:53:34] I thought maybe it was about percent-encoded URLs overflowing somewhere, but from a random ru.wiki page, if I download the article with Special:ElectronPdf, I get a normal PDF with a unicode filename which contains unicode URLs. [18:55:58] I also never heard of "options" which related to "text files" or "saving". Oh, unless you mean the default actions by MIME type. In which case the problem is that your system is not recognising the PDF as a PDF? [18:56:47] In that case, it sounds like a typical thing Microsoft Windows (or some of its terrifying "antivirus" software) would do. I don't remember if IE eventually managed to learn MIME. :) [19:00:39] (Some entry points on the topic if it's what you're looking for: https://support.mozilla.org/en-US/questions/1026555 https://unix.stackexchange.com/questions/162742/where-does-firefox-get-the-default-applications-for-opening-files-from ) [19:04:09] Thank you for the response. If you look at the page https://ru.wikipedia.org/w/index.php?title=%D0%91%D0%BE%D0%B3%D1%80%D0%BE%D0%B2,_%D0%93%D1%80%D0%B8%D0%B3%D0%BE%D1%80%D0%B8%D0%B9_%D0%98%D1%81%D0%B0%D0%B0%D0%BA%D0%BE%D0%B2%D0%B8%D1%87&oldid=81694514 the links (embedded URLs) are in Cyrillic, but it you save them as a text file, they come up as nu [19:04:09] mbers and percents [19:04:50] When I say options, I mean anyway to save the all the Cyrillic in a readable format [19:24:57] actually I got the answer. use urllib in python [19:25:10] thanks again! this forum is always great! [21:24:47] quarry SQL question... Goal: I'm trying to get a list of the top 20 most active editors (incl bots), for a given wiki. (Over all time, and last 360 days). [21:24:47] Problem: "rev_actor" is giving me the user-ID instead of username. [21:24:47] (I'm just hacking together parts and clues I found elsewhere. I'm a complete newcomer to SQL still!) [21:24:47] Current query: https://quarry.wmflabs.org/query/38787 [21:24:47] Similar, but for all time: https://quarry.wmflabs.org/query/38788 [21:41:43] quiddity, Due to the actor migration (https://www.mediawiki.org/wiki/Actor_migration), actor ids are stored with edits instead of usernames. https://wikitech.wikimedia.org/wiki/News/Actor_storage_changes_on_the_Wiki_Replicas has more information on updating queries. [21:42:26] I, unfortunately, can not help more than that as I can't SQL. [21:47:15] quiddity: join actor on actor_id = rev_actor, and use actor_name [21:47:59] quiddity: e.g. https://quarry.wmflabs.org/query/38790 [22:04:50] Thank you, both! SQL: I had tried a variant of that, but was missing something. Perfect, thanks again. :) [22:05:10] np [22:39:15] !log codesearch "sudo MODE=restart /srv/codesearch/manage.sh" [22:39:17] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Codesearch/SAL