[10:21:50] good morning folks.. in case someone is around who can give me a quick answer, what's the canonical way to make sure there are no lab instances using a given puppet role (or class)? [10:23:48] Hi [10:25:52] Does anyone know how to turn off auto welcome in huggle? [10:41:01] nm, found, used, bye [10:57:58] FriyMan: #huggle for Huggle questions [11:06:36] thank you [13:47:44] Is there any problem with PAWS right now? I am getting a 500 "Failed to start your server. Please contact admin." message [15:04:34] (03PS1) 10Ottomata: Dummy files for PCC kafka-jumbo [labs/private] - 10https://gerrit.wikimedia.org/r/395551 [15:05:02] (03PS2) 10Ottomata: Dummy files for PCC kafka-jumbo [labs/private] - 10https://gerrit.wikimedia.org/r/395551 [15:05:22] (03CR) 10Ottomata: [V: 032 C: 032] Dummy files for PCC kafka-jumbo [labs/private] - 10https://gerrit.wikimedia.org/r/395551 (owner: 10Ottomata) [18:47:10] !help I am trying to find out which pages in all the language Wikipedias were closed to IP edits in 2016. I thought I could use the logging table and the protect status under the log action, but it seems this does not capture all the times the pages were closed to IP edits. [18:47:10] tomthirteen: If you don't get a response in 15-30 minutes, please create a phabricator task -- https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?projects=wmcs-team [18:47:33] Any help is much appreciated [18:53:15] I guess "closed to IP edits" == "protected with protect level autoconfirmed"? [18:54:28] Eddiegp, thank you, but how to do that systematically. [18:55:40] Hmm, what makes you thing the logging table doesn't have that data? It should definitely have an log entry for each protect action. [18:56:11] For example this: (Protected "Pokémon GO": Persistent disruptive editing ([Edit=Allow only autoconfirmed users] (expires 00:59, 1 March 2016 (UTC)) [Move=Allow only autoconfirmed users] (expires 00:59, 1 March 2016 (UTC)))) [18:56:29] In the history page in pokemon this appears [18:56:38] !log quarry quarry-main-01: `MariaDB [quarry]> UPDATE user SET username = '-revi' WHERE username = 'Hym411';` T182064 [18:56:39] I don't see this in the logging table [18:56:41] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Quarry/SAL [18:56:42] T182064: Rename Hym411 to -revi - https://phabricator.wikimedia.org/T182064 [18:56:55] thanks! [18:57:24] tomthirteen: Is this enwp? [18:57:30] yes [18:58:17] revi: np [18:58:20] :D [18:58:27] good night then! /me goes to bed [18:58:41] good night [18:58:51] What's your query? [19:00:13] select * from logging where log_title = "pokemon_go" and log_timestamp > 20160101000 and log_action = "protect"; [19:00:54] you need to capitalize the log_title properly [19:01:31] yes, that was the same query for another title. i just quickly put in pokemon now to show you [19:02:11] what's the *exact* query you're trying to run [19:02:32] select * from logging where log_title = "Pokémon_Go" and log_timestamp > 20160101000 and log_action = "protect"; [19:04:23] Still a different page name [19:04:25] your log_timestamp is too short [19:04:41] The log excerpt you posted above is from _GO. This one is for _Go. [19:06:00] yeah now i'm having problems replicating the query [19:06:03] one sec [19:06:19] I know your problem [19:06:34] the log stores the title at the time of the block [19:06:38] but the page may have renamed [19:07:20] as far I know, there is not such a thing as protecting pages, only titles are protected, but I may be wrong [19:07:36] ah, i see it now [19:07:45] at least to what the log table concerns [19:08:00] that makes sense now why it doesn't show up in the logging table [19:08:38] the protection was for GO not Go, as you are saying [19:09:14] so, for a "hostory of protections", you may have to scan renames [19:09:19] *history [19:09:38] but, given this, is there a way to systematically check for 2016 the page for protections? i have to do this for all language wikipedias for 2016 [19:09:59] mediawiki is not that great regarding reconstructing history [19:10:05] so, you think also for renaming? [19:10:08] it is possible, it is just not trivial [19:10:23] yes, jynus, i've been seeing this :) [19:10:32] yes, there are some things associated with titles, and others with pages [19:10:40] and they are based on what it is practical [19:10:53] not on what it is easy for later statistical analysis [19:11:08] I'm sorry. I didn't follow [19:11:58] I am giving you an example [19:12:01] just 1 sec [19:12:06] thank you [19:14:18] select DISTINCT * from logging where log_namespace=0 and log_title = "Pokémon_GO" and log_timestamp > 20160101000 and log_action like 'move%'; [19:14:25] ^see that ? [19:14:34] first, you are missing a log_namespace parameter [19:14:35] yes, but that's the old name [19:15:09] actually, as far as I can see, it is the current name [19:15:20] https://es.wikipedia.org/wiki/Pok%C3%A9mon_GO [19:15:51] so you have to get those old names, too, and query for protections there [19:15:59] and you will have the full history of the page [19:16:17] the page you gave is the spanish one [19:16:23] ops [19:16:34] sorry, the advice still stands [19:16:54] select DISTINCT * from logging where log_namespace=0 and log_title = "Pokémon_Go" and log_timestamp > 20160101000 and log_action like 'move%'; [19:16:55] I did the data mining for the english wiki delimited to 2016 and it gives the title as Pokémon_Go [19:17:01] it is ok [19:17:19] just apply the same advice to Go title [19:17:31] (both will have the logs of the move) [19:17:53] Ok, so just to confirm, I'm doing that to check to see if there have been renaming, and then check to see if the old version of the title had protections? [19:18:07] yep, you can automatize that [19:18:15] if there was an old verision of the title [19:18:19] yes. [19:18:25] log_params {s:11:"4::oldtitle";s:11:"Pokémon GO";} [19:18:32] it should be "recursive" [19:18:41] Thank you. This formum has been very helpful [19:18:42] it could have been moved multiple times [19:18:52] eg title war and the protection [19:19:11] Yeah it's a pain to reconstruct the history of the page. [19:19:17] I agree with you [19:19:34] not though from the ground to do that [19:20:18] it used to be worse- at least we can do archeology now :-) [19:20:46] well, at least it's interesting :) [19:20:55] (and a pain) [19:21:05] I would like to see more people doing research involved on architecture decisions, that would help avoiding problems like this [19:21:07] anyway jynus, THANKS! [19:21:21] you've been a great help [19:21:32] actually i'd like them create better documentation [19:21:46] it always takes me a while to try to figure out what's happening [19:22:16] have a good day [19:23:54] bd808: https://phabricator.wikimedia.org/T182142 [22:30:17] Hi. [22:31:11] Anyone here? [22:31:26] yea [22:31:52] Does anyone know how to setup Git? [22:32:03] Git/Gerrit [22:37:03] Adotchar: have you seen this one https://www.mediawiki.org/wiki/Gerrit [22:37:22] Yes [22:37:25] https://www.mediawiki.org/wiki/Gerrit/Getting_started [22:37:25] Currently on the tutorial [22:37:35] cool [23:43:33] bd808: hey question why cant i add Adotchar as a maintainer to tools.revitalizebot? [23:43:46] Im trying thru striker atm