[04:43:15] hey [04:47:39] anyone know why the interlanguage links would show in the wrong order on mobile? [05:37:25] Someguy1221: define "wrong" [05:38:16] MobileFrontend reimplements a lot of things so it might be ignoring some local override or language data [05:40:55] basically, the language bar in mobile seems to not recognize accented characters as latin characters, causing any language name starting with one to get shoved down below z in alphabetical order [05:41:12] in desktop accented characters are recognized as their basic latin equivalent [05:42:58] So that could be unicode code point order vs UCA order [05:43:12] although i don't think we actually did UCA sorting of interlanguage links anywhere [05:43:17] but i'm not that familar with the code [05:49:34] is there any resource that would say how the sorting is done in the first place? if it's displaying differently in different skins, then it's dynamically generated or altered somewhere? [06:00:49] No, and its probably spread out between skin code, mobile frontend, wikidata, and maybe even ULS code [06:24:57] Interwikis are not supposed to be sorted by name anyway, by default [06:25:09] See wgInterwikiSortingSort https://noc.wikimedia.org/conf/highlight.php?file=InitialiseSettings.php [14:00:30] Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @amir1 & @subbu - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [14:14:08] [[Tech]]; Dovi; /* Update of MediaWiki:PageNumbers.js for the function at Hebrew Wikisource */ new section; https://meta.wikimedia.org/w/index.php?diff=19022001&oldid=19013733&rcid=13452770 [14:50:15] Technical Advice IRC meeting starting in 10 minutes in channel #wikimedia-tech, hosts: @chiborg & @milimetric - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [15:01:14] Welcome to the technical advice IRC meeting! [15:01:32] hi chiborg, I'll be helping out as I can today [15:02:20] last time we fixed Brexit, what's going on this time everyone? [15:02:45] o/ [15:02:59] Notre Dame [15:04:13] milimetric, I posted on Talk:Quarry the other day in reply to you. Shall we discuss now? [15:04:41] RhinosF1: oops, I sometimes miss those pings, lemme catch up, I'll ask you follow-ups if needed [15:05:49] np [15:07:48] RhinosF1: ok, are you as specific as possible when you say "number of editors with a logged edit or action in last 30 days"? Your other queries exclude users who are currently blocked, users with less than X edits, and users with certain registration dates [15:10:01] milimetric, For this one I only need people that have made a logged edit or action in the last 30 days. It's to compare the results of the other queries to. It's based on what was the active user field on Special:Statistics. Only thing that needs excluding are bots from this one. [15:11:25] RhinosF1: ok, cool. Do you want me to walk you through writing the query yourself? Seems like you're doing a lot of SQL but you're not super comfortable with it? [15:11:56] milimetric, that's exactly it, I'm doing some research just not comfortable with the SQL [15:12:12] RhinosF1: ok, well this one may be a good one to learn, let's paste it in here: [15:12:14] https://www.irccloud.com/pastebin/cCt21Cbm/ [15:12:42] Okay [15:12:43] ok, now copy that into a new quarry query, and I'll walk you through it [15:12:55] Got quarry open [15:13:10] 1. you don't care about user registration, so you can remove the join on lines 3 and 4, and the where clause on line 12 [15:13:23] (this is why I format the queries this way, makes it easy to edit them) [15:13:39] you can also remove line 13, as that's from the user table too [15:13:56] 2. you don't care about block status, so you can remove the left join from lines 5 and 6, and the clause on line 11 [15:14:42] 3. you don't care whether the user is a bot, so ... maybe you can figure this one out yourself? [15:15:19] remove rc_bot = 0 [15:15:30] yep :) [15:15:42] 4. and finally, you don't care about rc_type being something specific (= 0 limits it to edits only) [15:16:14] and that's it, that will give you registered users (rc_user != 0), so remove that too if you want all users [15:16:19] (including IP) [15:16:24] https://www.irccloud.com/pastebin/6R1l3mNt/ [15:16:42] IPs aren't included in the stats for this [15:16:43] good, nice and simple [15:16:46] ok, good [15:16:58] 35211 is now running [15:17:01] and done [15:17:09] yeah, should be pretty fast [15:17:44] 245333 make sense as a number there? [15:18:33] <[1997kB]> hi anyone having issue with copy paste in source editor? [15:18:54] btw, I think [1997kB] what issue are you having? [15:18:56] Actually higher than the special:statistics stat which was showing 139937 but that's broke so I don't know [15:19:37] <[1997kB]> when I paste, text next to it disappear. [15:19:45] RhinosF1: btw, you may want to put use enwiki; as the first line in your queries just to make it explicit that you're querying english wikipedia. It's the default if you specify nothing. [15:20:16] [1997kB]: you may be copying a backspace character, which is weird and rare but possible, do you have an example? [15:20:16] I've seen it mentioned before what's the line for that again?? [15:20:36] RhinosF1: "use enwiki;" just like that without the quotes on the first line [15:21:33] milimetric, I've put rc_type in and it goes down a lot some i'm guessing Special:Statistics used that when it is working as the figures are more similar. Thanks! [15:22:31] <[1997kB]> no im just copying simple text, and when pasting adjacent to text already exists, it disappear the older one. [15:22:41] RhinosF1: yes, rc_type = 0 is just edits, you can see all the types here: https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_type [15:22:54] <[1997kB]> but if I put a space and then paste, it doesn't happen. [15:23:30] [1997kB]: the backspace character doesn't show up in normal textboxes, that's why you might not even see it [15:23:50] so it looks like you're copying normal text, but you may not be, want to send a link to where you're getting the text from? [15:24:07] Thanks!!, You're on analytics mailer aren't you? I did email about it not so long ago [15:24:15] [1997kB]: if you have VIM or an editor like that, you can open up the text in it and see special characters [15:24:45] <[1997kB]> well it's just happening all over, just tried at https://test2.wikipedia.org/wiki/User:1997kB/CUU [15:24:50] RhinosF1: I work on the analytics team, yes, but I generally do software not data stuff [15:25:20] <[1997kB]> I copy pasted safesubst: [15:26:57] [1997kB]: hm, I can copy/paste that easily with no problem [15:27:03] milmetric, It was Dan Andreescu and Jonathan Morgan that responded to me, It's been very helpful. Can't remember who wrote the original query, Would have been someone in here a while ago? [15:27:33] RhinosF1: I'm Dan Andreescu [15:27:42] plot twist! [15:27:54] Then it was you that responded when I emailed [15:28:39] milimetric, New User Analysis on https://lists.wikimedia.org/pipermail/analytics/2019-March/thread.html#6586 [15:28:54] lol [15:29:26] Reedy: I loved Tim's post about Notre Dame's relics being saved, did you see that? [15:29:42] I did follow up with https://lists.wikimedia.org/pipermail/analytics/2019-April/006609.html as well. I've started the research not so long ago [15:34:23] <[1997kB]> milimetric: check https://drive.google.com/file/d/1L3zOHj3TfTYZPSKTU2Z477xFDof5EoGx/view?usp=drivesdk [15:34:28] RhinosF1: I recommend practicing with SQL and looking over the table manuals on wiki (from the Manual:Recentchanges_table link I sent). Because I think until you get more comfortable with the data and the schemas, you won't know exactly what you're looking for (like the rc_type filter) [15:35:58] milmetric, Thanks for the advice! I'll try some practice stuff, I'm starting to get my head round these queries and I've got the ones I want for now [15:37:00] np [15:40:37] [1997kB]: oh! on mobile. Ok, I just tried it on my iPhone and it's perfectly fine. I think your phone's keyboard has some kind of bug [15:42:19] <[1997kB]> hmm.. well it's google keyboard.. [15:43:01] milimetric, I'm going to run this until I get 10-14 days worth of data over varied times of the day then I'll post at enwikis village pump asking for help collecting data and with some thoughts on it and maybe go more in-depth. There's definitely some interesting things to look at as a lot of users make an edit, but then it drops off a lot. Need to see whether it's edits or time having the biggest effect as well but that's off-topic for this [15:43:01] meeting [15:44:11] RhinosF1: cool, yeah, you can maybe show folks in Research what you're working on and see if they're interested in reviewing your paper or giving you feedback (#wikimedia-research) [15:44:54] milimetric, I'll certainly do so soon, I'll get a tad more data first to make sure it's accurate [15:49:59] Thanks All, Have a good day [15:50:03] * RhinosF1 out [16:02:52] Thanks all for participating! Bye! [16:32:14] Is there someone Gerrit specialist? https://imgur.com/BdFe9TH [16:32:26] Please help! [16:33:51] sounds like https://phabricator.wikimedia.org/T220867 [16:35:21] Yep! Looks same [16:36:12] hold on a minute, you're Aldnonymous? [16:36:35] Nope, Just help Aldnonymous to resolve the issue. [16:36:44] Just helping* [20:29:32] [[Tech]]; Tacsipacsi; /* Update of MediaWiki:PageNumbers.js for the function at Hebrew Wikisource */; https://meta.wikimedia.org/w/index.php?diff=19023057&oldid=19022001&rcid=13454468