[01:18:22] Hi, does anyone know if "archive_userindex" table is available in other wikis than enwiki_p? [01:56:32] Superzerocool, yes it is [01:56:57] Krenair, the view returns 0 rows :( [01:57:11] (in eswiki_p database) [01:58:00] works on frwiki_p [01:58:34] archive table is also replicated as empty on eswiki_p [01:59:05] mmm... [01:59:43] over 7 million entries in prod though [01:59:55] Do I need fill a new ticket in Phabricatorto fill the table? [02:03:28] yes [02:05:48] Krenair, thanks for your assistance! (ufff... I'm not crazy after all :)) [03:05:39] I'm an admin for one of the mailing lists and someone emailed me today saying they'd sent a message to the list which never showed up and didn't trigger a bounce email. It didn't show up in the pending moderation tasks, so I asked them to resend, with seemingly the same result. filter_action is set to Reject. Any ideas, or suggestions on where to ask? [03:08:45] I would suggest filing a ticket in our phabricator instance [04:32:22] Leftmost: does the archive show their email? [04:59:58] Nemo_bis, it does not. [05:01:23] Leftmost: are we talking of Wiktionary-l? [05:01:44] Before handing the administration to you, I set up some regex filters [05:02:18] Per https://wikitech.wikimedia.org/wiki/Mailman#Spam_scores [05:03:05] You could switch these to "Hold" temporarily [05:09:47] What's the difference between Defer and Hold? Not clear on that. [05:20:52] Leftmost: "Defer" does nothing [05:21:18] https://wiki.list.org/DOC/Mailman%202.1%20List%20Administrators%20Manual#How_do_I_moderate_messages.3F [05:22:52] Alright, thanks for the help. [12:13:39] Reminder: The wikis will not be editable for ~30 minutes in a couple of hours. [12:13:42] https://meta.wikimedia.org/wiki/Tech/Server_switch_2016 [12:56:06] Banners are displayed now. [12:57:18] thanks. [13:00:23] how do i report a problem? [13:03:25] abolsutely3: just typing it here is a good first step [13:05:57] I was trying to upload a replacement image in English Wikipedia yesterday, but it gets stuck on uploading when I hit Save. I was told yesterday there's an error in my JS console? [13:09:47] Tried disabling your addons/extensions? [13:09:56] Or using another browser? [13:10:13] Funny https://phabricator.wikimedia.org/T129486#2227013 [13:11:01] I've tried firefox and chrome so far [13:13:24] Hm. [13:13:35] What is your JS console saying? [13:13:52] (note, I am not a developer, just trying to help others :) ) [13:16:28] 09:16:06.172 TypeError: finishStash(...) is undefined UP.finishStashUpload/<() load.php:80 .Deferred/promise.then/ interesting [13:17:58] so it does look like a server-side thing [13:18:08] I'll let more technically able folks help you out from here [13:18:33] thanks :) [13:42:12] hm [13:43:02] abolsutely3: interesting [13:44:10] abolsutely3: does this always happen when you try uploading? (i'm guessing you're using the upload dialog in visual or wikitext editor) [13:44:54] abolsutely3: can you also send me the file you're trying to upload? (e.g. through https://phabricator.wikimedia.org/file/upload/ , or your favorite file sharing website) [13:55:18] we're going read-only in ~5 minutes [14:01:02] disabling edits now [14:14:27] MatmaRex: only the past 2 days [14:14:49] MatmaRex: Can you download it from here? https://www.dropbox.com/s/ycb3k5odvi3tjh2/gb-tm-full-1.jpg?dl=0 [14:20:44] we're going back read-write [14:22:27] abolsutely3: yeah. i'm away for a minute, i'll file a ticket and look into this later [14:23:14] actually, might as well file now [14:23:28] https://phabricator.wikimedia.org/T133295 [14:24:15] thanks! [14:31:10] abolsutely3: thank you for letting us know! (and thanks foks and MatmaRex for much more useful replies than mine) [15:49:52] abolsutely3: hey, i debugged it and we'll have the fix deployed soon. the upload actually goes through (your file is here: https://commons.wikimedia.org/wiki/File:Gb-tm-full-1.jpg ), but the upload dialog had a bug in it :/ [16:06:59] thanks for all your help :D you're awesome [17:21:41] getting "Sorry, the servers are overloaded at the moment." when trying to view https://en.wikipedia.org/wiki/Prince_(musician) [17:23:21] MusikAnimal: too many people are trying to view and edit it, so to avoid falling over entirely, there's a limit [17:23:34] haha figures [17:23:35] <_joe_> MusikAnimal: I can see it right now [17:23:42] <_joe_> it has been protected I see [17:23:43] yeah I can too [17:23:47] just never seen that error before [17:23:57] it was already semi'd [17:48:13] MusikAnimal: Last time you might have seen it was Robin Williams's death, or the Pope's. It was created following Michael Jackson's. [17:48:23] yeah [17:48:30] I recall that Robin Williams had to be fully protected [17:48:45] Yes, I was maybe overly-cautious. [17:49:34] nah I think being able to see the page is worth not being able to edit it [17:50:07] I also noticed there was an array of edit filters created following Jackson's death hah [17:50:46] Yeah, which make it worse not better. ;-) [17:50:48] yea, that should actually be the protection kicking in to prevent worse [20:59:57] I'm trying to get a list of all audio pronunciations on en.wiktionary. I'm happy to use Quarry to query the database, but I can't for the life of me work out where audio files are *stored* in the database; am I missing something obvious? [21:03:34] <_joe_> aquarius: i guess they are not stored on the db but on our object storage, on the db you'll just find the file metadata (if that's what you were asking) [21:04:37] _joe_, ah, it's the metadata I'm looking for (for now :)) [21:05:24] aquarius: the audio files are probably mostly on Commons, rather than Wiktionary [21:05:31] oh. [21:05:34] (their metadata too) [21:05:38] that explains why i can't find them, then :) [21:06:27] essentially, what I'm looking to do here is get a list of all the words which *have* an attached pronunciation, and links to the audio files themselves. [21:07:09] getting the text of all the pages and looking for {{audio|whatever.ogg}} links will obviously do it, but that seems rather a lot of data; if that's the best way, though, I can do that. [21:09:41] aquarius: which files are used on which pages should be recorded in the 'imagelinks' table on enwiktionary [21:09:50] (the name is for historical reasons) [21:10:21] ah! I looked in the image table, but that only contains actual images, so I figured that imagelinks wasn't useful :) [21:12:14] aquarius: and join that with commonswiki.image [21:12:24] hrm [21:12:31] 'image' also contains all files, not just images [21:12:51] yeah, on commonswiki -- that's the mistake I was making there :) [21:12:54] generally, most things that refer to images really mean all files :) but when they were created, mediawiki only had any handling for actual images [21:14:04] aquarius: although i'm not sure how wiktionary does things. if they don't embed the audio files on pages, but only link to then, that will be in the pagelinks table (and pl_namespace=6). [21:14:06] So, I'm a little confused, then; https://en.wiktionary.org/wiki/pope links to https://commons.wikimedia.org/wiki/File:En-us-pope.ogg, and therefore I'd expect a query "select * from imagelinks where il_to = 'En-us-pope.ogg' limit 1;" against enwiktionary_p to show a result in Quarry, but it doesn't. [21:14:10] aaaaaaah [21:14:47] https://en.wiktionary.org/wiki/pope#Pronunciation ? that actually looks embedded [21:15:07] hm [21:16:14] aquarius: argh [21:16:34] aquarius: try with 'en-us-pope.ogg', lowercase [21:17:06] ha. [21:17:07] this is pretty weird though. i'm blaming it on wiktionary's lowercase title weirdness… [21:17:18] yep! that finds it :) [21:17:23] file names on Commons can't actually start with lowercase letter [21:17:57] so you might have to handle both kinds of entries in wiktionary imagelinks, i guess [21:19:12] hooray! and il_from is a page.id. Given that and a dump of those two tables, I can find them all. Excellent; that's exactly what I was looking for. Thank you! [21:19:24] i'll file a bug about this case inconsistency. not that anyone will race to fix it. :P [21:20:07] ah, with a database dump I can just look for everything ending .ogg; doesn't matter that that's unindexed because I'm doing it on my machine, not your servers :) [21:22:34] Just in case I'm being stupid: in https://dumps.wikimedia.org/enwiktionary/20160407/, enwiktionary-20160407-pages-articles.xml.bz2 ("Articles, templates, media/file descriptions, and primary meta-pages") is ~508MB, but enwiktionary-20160407-pages-meta-current.xml.bz2 ("All pages, current versions only.") is 626MB. I'm surprised that the amount of stuff in "all pages" which isn't in "articles, templates, media/f [21:22:34] ile descriptions" adds up to 126 extra MB? [21:24:14] aquarius: i'm not sure what exactly is included in each [21:24:30] aquarius: it might be talk pages, or the project discussions? i really don't know [21:24:32] ah well. Am downloading the 500MB one anyway, which will take me 15 minutes :) [21:24:35] filed https://phabricator.wikimedia.org/T133351 , by the way [21:24:38] thank you for all the help! [23:51:47] .. [23:51:55] https://en.wikipedia.org/wiki/Special:CentralAuth/momonyc "Exception encountered, of type "Exception"" [23:53:22] Exception from line 2289 of /srv/mediawiki/php-1.27.0-wmf.21/extensions/CentralAuth/includes/CentralAuthUser.php: Could not find local user data for Momonyc@enwiki [23:54:11] RileyH, https://phabricator.wikimedia.org/T119736 [23:54:25] just commented on [23:54:26] thanks