[00:23:51] Anyone checked if Wikipedia is blocked in Turkey? https://www.comparitech.com reports that en.wikipedia.org is blocked. [00:26:10] https://explorer.ooni.org/search?test_name=web_connectivity&probe_cc=TR&probe_asn=34984&domain=en.wikipedia.org&since=2019-12-31&until=2020-01-31 [00:26:19] OONI shows it as accessible [00:28:33] I suspect the site is trottled. [00:46:40] tgr : it says "A consumer with this name/version/publisher combination already exists" [00:46:46] i think you need todelete it first [12:34:43] Hi! I'm creating a central notice campain, but getting a 503 error creating a banner. What could be wrong? [12:34:50] Now I'm getting [12:34:51] [XjQeygpAAEIAAHlbcFMAAAAW] 2020-01-31 12:34:18: Fatal exception of type "BannerDataException" [12:37:02] error message in logstash is “Banner name must be in format /^[A-Za-z0-9_]+$/” [12:37:14] though I imagine it would be nicer to show that message to you, instead of an internal error :) [12:37:21] but maybe that helps you go ahead with the campaign at least [12:40:37] created https://phabricator.wikimedia.org/T244020 [12:45:25] Yes, it would be [12:45:31] Thanks Lucas [12:46:46] no problem [12:46:52] good luck with the campaign ^^ [12:47:02] thanks [16:18:36] still cannot access Wikimedia [17:14:53] TIL: There's an actor whose name is the empty string [17:15:12] Also one named "Unknown user" despite that being invalid for not-logged in, i though [18:37:10] Hello, I'm running importDump.php to import Wikitionary but I'm running into this error: [18:37:12] Wikimedia\Rdbms\DBUnexpectedError from line 3880 of C:\xampp\htdocs\mediawiki-134git\includes\libs\rdbms\database\Database.php: No atomic section is open (got MediaWiki\Revision\RevisionStore::insertRevisionOn) [18:37:13] Wikimedia\Rdbms\Database->cancelAtomic('MediaWiki\\Revis...', Object(Wikimedia\Rdbms\AtomicSectionIdentifier)) [18:37:14] C:\xampp\htdocs\mediawiki-134git\includes\libs\rdbms\database\DBConnRef.php(635): Wikimedia\Rdbms\DBConnRef->__call('doAtomicSection', Array) [18:37:14] C:\xampp\htdocs\mediawiki-134git\includes\Revision.php(968): MediaWiki\Revision\RevisionStore->insertRevisionOn(Object(MediaWiki\Revision\MutableRevisionRecord), Object(Wikimedia\Rdbms\DBConnRef)) [18:37:16] C:\xampp\htdocs\mediawiki-134git\includes\import\WikiRevision.php(616): ImportableOldRevisionImporter->import(Object(WikiRevision)) [18:37:17] WikiImporter->importRevision(Object(WikiRevision)) [18:37:19] C:\xampp\htdocs\mediawiki-134git\includes\import\WikiImporter.php(860): WikiImporter->processRevision(Array, Array) [18:37:21] C:\xampp\htdocs\mediawiki-134git\maintenance\importDump.php(359): WikiImporter->doImport() [18:37:23] C:\xampp\htdocs\mediawiki-134git\maintenance\doMaintenance.php(99): BackupReader->execute() [18:37:28] Does anyone know what this means? [18:38:23] I'm able to import several thousand pages, so this must be from something on a particular page [19:18:03] Alright, I don't know what I'm doing/not doing to make https://quarry.wmflabs.org/query/41782 not work [19:19:32] I'm trying to get a list of years compared to the number of images from that year [19:19:33] AntiComposite: You can't re-use an alias in the SELECT part. You should either use a variable, or just repeat the expression (AFAIK) [19:21:33] Or use group by [19:21:56] I tried group by like 3 different times, and now it works. [19:23:08] I think it was because I was using MIN(img_timestamp) to try to get only the first upload for a page [19:23:13] using numbers in the group by is often easier [19:23:23] e.g. group by 1 to group by the first thing in the SELECT clause [19:24:50] AntiComposite: Yeah, you can't group by an aggregate function [19:25:50] * AntiComposite grumbles about unhelpful error messages [19:26:39] AntiComposite: if you wanted to have the first of the year, you would do something like: https://dpaste.org/jwyc [19:28:09] i.e. group by is how you split up the results, and aggregate functions is how you pick out which of your group to show. You can't pick out the smallest member of a group if your group is defined as every row with a different smallest member is in a separate group [19:28:22] Not sure if that explanation made sense [19:28:47] Yeah [19:32:10] I think what I have now works well enough for what I wanted it for, there probably aren't that many overwritten files in CAT:LRN anyway. [19:35:37] I could have a go at making it look at overwritten images [19:36:20] I semi- got in an argument with Fae on the village pump, and now I'm spending inordinate amounts of time trying to optimize his query, which i think more proves fae's point than mine... [19:42:49] AntiComposite: So this was my attempt at using overwritten images: https://quarry.wmflabs.org/query/41787 [19:43:46] There's mild differences, but its mostly the same [19:44:02] yup [19:45:14] both work for the point that I'm making: there's two orders of magnitude more images in 2019-2020 than the previous decade [20:30:40] paladox|UKInEU: huh, interesting. I would have thought that gerrit would reject PS1 if it didn't actually modify a file. Didn't know you could commit things that didn't actually change things [20:31:12] bawolff yup :) [20:31:53] bawolff i did that in a web change though [20:31:55] (all of that) [20:32:08] ah [20:48:26] bawolff do you know anything about this? https://www.mediawiki.org/wiki/Topic:Vfxjdmden3nt8k18 [20:49:49] velox828: At a guess, something is broken in the error handling of the import script [20:50:18] So I'd guess that the page is attempted to be inserted, fails for reason, and then the error handler doesn't work, and this error message is about the error handler exploding [20:52:49] velox828: If you could extract just the part of the dump that's causing the problem (e.g. minimal testcase) you could file a bug report in https://phabricator.wikimedia.org [21:14:15] velox828: next time please use pastebin if you are going to post this many lines [21:34:42] bawolff the page I've run into seems to be several hundred lines long. I can truncate it a bit to provide an example [21:35:43] If you can provide a minimal test case that triggers the bug, uploading it to phabricator might mean the people who look after the import code would be able to fix the issue [21:39:35] Okay, I'll do that [21:48:16] bawolff let me know if this is descriptive enough: https://phabricator.wikimedia.org/T244035 [21:51:09] yeah, that looks fine [22:19:07] [[Tech]]; Pols12; Undo revision 19755925 by [[Special:Contributions/Master AEP|Master AEP]] ([[User talk:Master AEP|talk]]) answered on their user talk page; https://meta.wikimedia.org/w/index.php?diff=19763680&oldid=19755925&rcid=14805842