[01:35:41] <Mbrt>	 hi
[01:36:16] <Mbrt>	 hi akl
[01:36:17] <Mbrt>	 all
[01:37:04] <Mbrt>	 hi all
[01:37:18] <Mbrt>	 Do you know about captcha
[01:37:43] <Mbrt>	 I install mediawiki with hard captcha
[01:38:06] <Mbrt>	 And I want to captcha can same with wikipedia
[01:38:10] <Mbrt>	 how?
[01:38:19] <Mbrt>	 Thanks for time
[01:41:46] <MaxSem>	 https://www.mediawiki.org/wiki/Extension:ConfirmEdit
[01:41:55] <MaxSem>	 Mbrt, ^
[01:42:45] <Mbrt>	 in special:CreateAccount?
[01:44:04] <MaxSem>	 you can configure where to add the captcha: https://www.mediawiki.org/wiki/Extension:ConfirmEdit#Configuration
[01:48:25] <Mbrt>	 Thanks for link
[01:48:29] <Mbrt>	 s
[01:48:34] <Mbrt>	 :)
[07:54:47] <ankry>	 hi
[07:55:01] <ankry>	 any hints how to revert this vandalism:
[07:55:03] <ankry>	 https://commons.wikimedia.org/w/index.php?title=Commons%3ASignatures%2Fbn&type=revision&diff=224760517&oldid=224760396
[07:55:07] <ankry>	 ?
[07:55:46] <ankry>	 "This page cannot be updated manually" on an attempt
[08:04:57] <legoktm>	 ankry: I guess you figured it out?
[08:05:41] <legoktm>	 andre__, Nemo_bis: what IRC client do we normally recommend to windows users? they seem to be running into issues picking a FOSS one (most choose mIRC), and I have no idea what the good ones are for that OS...
[08:07:19] <ankry>	 legoktm: yes, I just found I reverted the vandalism.
[08:07:33] <ankry>	 only stub left
[08:07:50] <ankry>	 no problem with it
[08:07:54] <ankry>	 thx
[08:09:52] <Nemo_bis>	 legoktm: imho xchat
[08:10:05] <Nemo_bis>	 that is, hexchat
[08:10:33] <mutante>	 legoktm: i think they use hexchat
[08:10:44] <Nemo_bis>	 I think last year I ended up adding a couple examples to the IRC task text, didn't I?
[08:11:02] <legoktm>	 alright, I'll recommend that in the future, thanks
[08:11:16] <legoktm>	 Nemo_bis: I'm not sure if it's still there this year, but I've now had two students use mIRC
[08:12:10] <mutante>	 there's also Quassel, for Windows/Mac/Linux
[08:12:32] <Nemo_bis>	 The resilience of mIRC is always surprising
[08:13:05] <mutante>	 yes, everybody remembers Khaled
[08:13:16] <mutante>	 and trying to remove the nag screen 
[08:16:14] <mutante>	 http://quassel-irc.org/node/95
[08:18:15] <mutante>	 https://en.wikipedia.org/wiki/Comparison_of_Internet_Relay_Chat_clients
[08:20:44] <mutante>	 you know what..  https://en.wikipedia.org/wiki/BitchX
[08:21:13] <mutante>	 now that's a classic but totally for Windows too heh
[08:24:41] <Nemo_bis>	 Yes, we already tell them to pick from that comparison. Last year, some of them made me discover some interesting clients. :)
[08:34:20] <mutante>	 :) IceChat doesnt sound bad, recent stable release, GPL, supports IPv6/SSL/sasl bla..  anyways.. bbl
[09:03:57] <koenji>	 i need to get rid of chatzilla
[09:58:55] <changed-nick>	 !ops https://en.wikipedia.org/wiki/Sharia
[09:59:08] <changed-nick>	 tries to make Sharia appear acceptable in some context
[09:59:17] <changed-nick>	 to the detriment of LGBT and women's rights
[10:03:44] <andre__>	 changed-nick: What's the technical aspect?
[10:03:48] <andre__>	 ah. and left.
[10:05:22] <JollyOldStNick>	 andre__: he's trolling across lots of channels. Vandalised en.wp, got blocked, now being a nuisance. 
[10:10:47] <andre__>	 Heh :)
[10:24:50] <wastebasket>	 Niggers smoke weed
[12:42:20] <Steinsplitter>	 http://commons.wikimedia.org/w/api.php?action=query&format=xml&list=logevents&rawcontinue=1&leaction=upload%2Fupload&lestart=2016-11-01T12%3A33%3A21.000Z  does not load?
[12:53:59] <Reedy>	 Steinsplitter: WFM
[12:54:04] <Reedy>	 But it's probably cached now
[13:41:25] <Nemo_bis>	 Grr, "Start editing" splashscreen three times in a row on talk pages on a single wiki
[15:12:47] <lestaty>	 hey guys, Notifications is asking for wikimedia gerrit username and pswd when downloading all extensions 
[15:15:40] <andre__>	 lestaty, how do you download all extensions?
[15:17:16] <lestaty>	 using git clone https://gerrit.wikimedia.org/r/p/mediawiki/extensions.git / git submodule update --init --recursive 
[15:21:29] <Reedy>	 because you're cloning over https
[15:21:36] <Reedy>	 I've noticed it does it for some extensions, but not all
[15:22:06] <lestaty>	 hmm
[16:08:58] <lestaty>	 Reedy, andre__ same problem using http 
[16:16:48] <Reedy>	 I didn't say to use http ;)
[16:16:49] <Reedy>	 Use ssh
[16:18:16] <lestaty>	 to use ssh I need to be a dev, no?
[16:21:01] <andre__>	 lestaty, become one! It's for free! :P https://www.mediawiki.org/wiki/Developer_access
[16:21:21] <lestaty>	 lol
[16:55:18] <Stryn>	 why does the interwiki links goes to Wikipedia when they should go to Wikivoyage? https://fi.wikivoyage.org/wiki/Etusivu
[16:55:46] <Stryn>	 a bug or some settings still need to be done?
[16:56:52] <Nemo_bis>	 At some point the script for wiki creation was instructed to import the "standard" interwiki map, which is wrong for any sister project
[16:57:16] <Nemo_bis>	 Should just rerun the interwiki map update I guess
[18:54:32] <krd>	 Hello. At Commons Special:Notifications does not load, and some gadgets don't work either. Is this already known?
[19:00:36] <MatmaRex>	 krd: first time i hear of it. the page loads for me though.
[19:01:20] <krd>	 When I click on the bell symbol (there is 1 message for me) I get a empty page.
[19:01:37] <krd>	 Anything I can do?
[19:02:52] <MatmaRex>	 krd: have you enabled any new gadgets recently or something?
[19:03:08] <krd>	 no
[19:03:34] <krd>	 stopped working somewhen in the last 24 hours.
[19:04:46] <MatmaRex>	 krd: does the page load in debug mode? https://commons.wikimedia.org/wiki/Special:Notifications?debug=1 (it might take a while, this way is much slower)
[19:05:48] <krd>	 yes
[19:06:24] <MatmaRex>	 huh, that's weird.
[19:06:49] <krd>	 It takes 10 seconds, but it works.
[19:07:02] <stemd>	 Requesting temporary lift of IP cap
[19:07:07] <krd>	 I have the impression that in non-debug some thing are not getting loaded.
[19:07:21] <MatmaRex>	 ok, well, that won't help find out why it doesn't work normally then :D let's go back to https://commons.wikimedia.org/wiki/Special:Notifications
[19:07:22] <stemd>	 193.198.60.223
[19:07:52] <stemd>	 if it can be done, here are ~20 people of which only few could make new account
[19:07:57] <MatmaRex>	 after it finishes loading, please open your browser error console and copy-paste everything shown there
[19:08:18] <MatmaRex>	 which browser are you using?
[19:08:22] <stemd>	 thanks!
[19:08:26] <krd>	 MatmaRex: Firefox
[19:08:54] <MatmaRex>	 stemd: please see https://meta.wikimedia.org/wiki/Mass_account_creation#Requesting_temporary_lift_of_IP_cap
[19:08:57] <MatmaRex>	 ugh
[19:10:32] <MatmaRex>	 krd: you can open it with Menu -> Developer -> Browser Console, or Ctrl+Shift+J
[19:11:38] <krd>	 pasted in private
[19:14:56] <MatmaRex>	 thanks, i replied
[20:12:35] <d3r1ck>	 c
[21:37:47] <Stryn>	 meh, I'm getting DBQueryError on Finnish Wikivoyage when going to  https://fi.wikivoyage.org/wiki/Toiminnot:Poistetut_muokkaukset/Stryn
[21:38:40] <Stryn>	 (it's Special:DeletedContributions btw)
[21:40:07] <Krenair>	 Function: IndexPager::buildQueryInfo (DeletedContribsPager)
[21:40:08] <Krenair>	 Error: 1176 Key 'usertext_timestamp' doesn't exist in table 'archive' (10.64.0.19)
[21:40:08] <Krenair>	  {"exception_id":"WECYogpAIDYAADTi2oIAAABN"} 
[21:40:28] <Krenair>	 Query: SELECT  ar_rev_id,ar_namespace,ar_title,ar_timestamp,ar_comment,ar_minor_edit,ar_user,ar_user_text,ar_deleted  FROM `archive`  FORCE INDEX (usertext_timestamp)  WHERE ar_user_text = 'Stryn'  ORDER BY ar_timestamp DESC LIMIT 51  
[21:41:33] <Krenair>	 isn't that index supposed to have an ar_ prefix?
[21:43:21] <Krenair>	 | Table   | Non_unique | Key_name              | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
[21:43:36] <Krenair>	 | archive |          1 | ar_usertext_timestamp |            1 | ar_user_text | A         |          57 |     NULL | NULL   |      | BTREE      |         |               |
[21:43:36] <Krenair>	 | archive |          1 | ar_usertext_timestamp |            2 | ar_timestamp | A         |         229 |     NULL | NULL   |      | BTREE      |         |               |
[21:46:07] * Krenair grumbles
[21:49:00] <Krenair>	 So somewhere between tcywiki creation (4th of August) and olowiki creation (7th of October)
[21:50:23] <Reedy>	 is the table big?
[21:51:04] <Krenair>	 fiwikivoyage was created literally yesterday I doubt they've had a chance to delete much stuff yet
[21:51:34] <Reedy>	 CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision (rev_user_text,rev_timestamp);
[21:51:48] <Reedy>	 CREATE INDEX /*i*/ar_usertext_timestamp ON /*_*/archive (ar_user_text,ar_timestamp);
[21:51:56] <Reedy>	 Krenair: looks like a MW bug, not a wiki setup bug
[21:52:05] <Krenair>	 indeed
[21:52:16] <Krenair>	 https://gerrit.wikimedia.org/r/#/c/312089/ looks highly suspect
[21:52:40] <Reedy>	 heh, yup
[21:54:03] <Reedy>	 		$condition['ar_user_text'] = $this->target;
[21:54:03] <Reedy>	 		$index = 'usertext_timestamp';
[21:54:24] <Reedy>	 Krenair: want me to put a patch?
[21:54:42] <Krenair>	 what're you going to do?
[21:54:57] <Reedy>	 add the prefix on that $index in DeletedContribPager
[21:55:06] <Krenair>	 that'll break all the old wikis
[21:55:23] <Krenair>	 compare 'show indexes in enwiki.archive' with 'show indexes in fiwikivoyage.archive'
[21:55:23] <Reedy>	 Why... Does the index exist in both forms?
[21:55:26] <Reedy>	 Sigh
[21:55:36] <Krenair>	 old wikis have usertext_timestamp, new ones have it prefixed
[21:55:36] <Reedy>	 Revert Aarons patch then? :P
[21:57:13] <Krenair>	 Stryn, wanna file a task?
[21:57:36] <Reedy>	 reverted on master and cherry picked
[21:57:44] <Reedy>	 https://gerrit.wikimedia.org/r/#/c/324810/
[21:57:49] <Reedy>	 https://gerrit.wikimedia.org/r/#/c/324809
[21:58:38] <Stryn>	 just going to sleep, too tired to do anything :/
[21:58:45] <Krenair>	 ok Stryn, we'll handle this
[21:58:48] <Krenair>	 I'll fix the index on the 4 affected wikis
[21:58:57] <Stryn>	 thanks guys! :)
[22:09:23] <Krenair>	 Reedy, got a sysadmin flag? can you try loading the page?
[22:09:29] <Krenair>	 all I get is the permission error
[22:09:35] <Krenair>	 or I could ping a steward or someone I guess
[22:09:46] <Reedy>	 i think my wmf account does
[22:09:53] <Reedy>	 moment
[22:11:20] <Reedy>	 Krenair: page loads
[22:11:23] <Reedy>	 no errors
[22:11:23] <Krenair>	 great
[22:11:37] <Krenair>	 Reedy, you know this issue probably just got released..
[22:11:44] <Reedy>	 fucking lol
[22:11:46] <Reedy>	 probably
[22:11:50] <Reedy>	 almost certainly?
[22:11:56] <Krenair>	 we might be able to have update.php clean it up
[22:12:06] <Reedy>	 should be able to
[22:12:17] <Reedy>	 probably a function rather than just an sql file
[22:26:19] <Krenair>	 ostriches, ^
[22:26:44] <Krenair>	 tl;dr there was a patch included in the release that broke the creation of an index
[22:27:20] <Krenair>	 gave it a name different to what a query using FORCE INDEX to render DeletedContribs expected
[22:27:48] <Krenair>	 this would only cause issues on wikis created with the patch applied
[22:29:55] <legoktm>	 so all new 1.28 wikis?
[22:30:27] <ostriches>	 So, wmf.4 needs an update backported, which I see has been done.
[22:30:37] <ostriches>	 Does is warrant a 1.28.1, or can it wait for said 1.28.1?
[22:30:56] <Krenair>	 I just manually repaired the wikimedia databases affected
[22:31:22] <Krenair>	 but MW will need something like an update.php addition
[22:31:24] <Krenair>	 I think so legoktm 
[22:31:50] * legoktm sets up a new wiki quickly to test
[22:33:15] <Krenair>	 annoyingly this sat on master for two months and was only just caught due to it's nature
[22:34:58] <legoktm>	 is this only a problem on mysql?
[22:35:59] <Krenair>	 probably affects both mysql and sqlite, I don't know how it affects anything else
[22:36:55] <legoktm>	 I installed with core at 2c657ec25613a82210bb67983bff06e509816a39 and deletedcontribs appears to work fine w/ sqlite
[22:40:30] <Krenair>	 legoktm, test it on mysql
[22:42:57] <legoktm>	 will do
[22:47:26] <legoktm>	 Krenair: okay, reproduced on mysql
[22:49:32] <legoktm>	 ostriches: so on new 1.28 wikis that use mysql, Special:DeletedContributions is entirely unusable
[22:50:01] <ostriches>	 legoktm: Upgraded, or new only?
[22:50:15] <legoktm>	 new only I think.
[22:51:23] <Krenair>	 new only, wiki has to be created with a broken version of MW
[22:53:36] <legoktm>	 if it was on upgrade, I think we would have gotten a ton more user complaints
[22:54:11] <legoktm>	 also the default main page content is broken
[22:55:25] <legoktm>	 hah, I was the one who +2'd it too -.-
[22:56:26] <gry>	 Woo, breaking things. :)
[22:56:44] <legoktm>	 Krenair, ostriches: https://gerrit.wikimedia.org/r/324824
[22:58:08] <Krenair>	 +2'd
[22:58:12] <legoktm>	 thanks
[23:02:05] <ostriches>	 I guess we could do a 1.28.1
[23:02:17] <Krenair>	 I don't know if this warrants it
[23:02:54] <Krenair>	 certainly should be in a 1.28.1
[23:03:05] <Krenair>	 just not sure it's required for this alone
[23:03:11] <Krenair>	 broken DeletedContribs on all new mysql-based instances...