[00:17:43] 2.91M [01:14:36] 2.91 mil out of what, 14 mil? [01:14:57] 15 [01:16:49] grr [01:16:58] so what, another day or two? [01:17:08] and we can't do anything useful then? [01:17:11] 30 hours Reedy last said [01:18:31] it's been about 12 hours and he's 1/5th of the way through [01:18:38] so 30 hours is optimistic [01:19:11] MF-W: üba watt redn dien dah? [01:19:50] jewalt un ßeks, höhöhö [01:20:46] O.O [01:21:50] schlümm …, schlümm, schlümm --Ruthä.de,eh :P [01:54:15] New patchset: Daniel Werner; "Switching from JS globe coordinate parser to back-end parser" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69048 [07:30:27] New review: Henning Snater; "(1 comment)" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69638 [07:38:56] Reedy: If you're still awake, where are we at in the restoration? [08:00:01] New patchset: Tobias Gritschacher; "Make use of serializers when generating result in the API" [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69317 [08:02:51] I'd like to understand how I can use images from wikidata inside a wiki page [08:52:49] Lydia_WMDE: i'd dial in for the dialy, if someone sets that up on your side [08:54:02] DanielK_WMDE: ok [08:54:40] DanielK_WMDE: will invite you in a bit [08:55:25] i'll use the hangout link in the calendar entry [08:55:30] ok [08:57:04] Change abandoned: Daniel Kinzler; "no point in deploying this hot fix now" [mediawiki/extensions/Wikibase] (mw1.22-wmf6) - https://gerrit.wikimedia.org/r/68397 [09:11:36] so here's what krinkle said tonight: "the rest should not be in the WikidataClient extension, at least it shoudn't register all 90 modules on every single wiki for every single reqyest." [09:12:11] yea.... [09:12:17] why would we? [09:12:29] probably a mistake [09:12:36] first we should figure out, if we really do this [09:12:40] and then figure out to fix that [09:12:45] that would indeed be unfortunate [09:13:57] New patchset: Daniel Kinzler; "(bug 49832) i18n for input validation." [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69844 [09:15:18] New patchset: Daniel Kinzler; "(bug 49832) i18n for input validation." [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69844 [09:15:38] New patchset: Daniel Kinzler; "Merge results in CompositeValidator" [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69845 [09:15:53] New patchset: Daniel Kinzler; "Use quick hasEntity in EntityExistsValidator" [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69846 [09:16:19] New patchset: Daniel Kinzler; "Allow Result objects to be merged" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69847 [09:16:37] New patchset: Daniel Kinzler; "Add error code and parameters to Error." [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69848 [09:17:06] the storm messed up the train schedule last night... can you tell? ;P [09:19:16] New patchset: Henning Snater; "Making calendar names translatable" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69849 [09:19:31] Denny_WMDE: would be good to get the following in, so we can finally enable more low level validation, and no longer fatal out when a bot submits a malformed structure to the api: [09:19:38] https://gerrit.wikimedia.org/r/#/c/68952/ [09:19:44] https://gerrit.wikimedia.org/r/#/c/68002/ [09:20:15] DanielK_WMDE: is that a review request to me? :) [09:20:32] If you like - or poke Danwe and/or Jeroen [09:20:49] I don't want to ask Tobi again, at least not before i have reviewd his stuff :) [09:20:56] i'll try to see if i can do it [09:21:13] no, tobi is here only shortly before he flies today, so he should have some time to finish his stuff [09:21:22] right [09:21:28] and i want danwe and henning to check the modules [09:21:45] i will do a quick scan of the wiktionary discussion and then check the review of the two bugs [09:24:02] Denny_WMDE: ok, great! not that jenkins fails when a change depends on a change in another module. either remove jenkins, or merge the change to the other module first (and then poke jenkins by rebasing or editing the commit message) [09:27:06] New patchset: Daniel Kinzler; "Allow Result objects to be merged" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69847 [09:27:17] hm, i guess i was going a bit too fast there :P [09:27:46] meaning -> sense [09:27:49] word -> ??? [09:28:11] is word -> expression an improvement? [09:29:05] for anything with spaces in it, yes. [09:29:08] it's more general [09:29:12] ok, will do [09:29:57] but I don't really like it because the "E" prefix is unsexy and "expression" is long and because "expression" also has a meaning in semantics that is not intended here [09:30:07] i don't have a good alternative, though [09:30:09] ah, the prefix can stay W [09:30:20] but that's more confusing :P [09:30:36] "phrase"? but that's a syntaxtic function, really [09:30:42] *syntactic [09:30:47] and p is already taken :) [09:30:50] W is nice [09:31:46] "Lexeme" is probably correct, but too technical [09:32:12] let's not bikeshed over terminology too much [09:32:22] i am already doing the change :) let's get back to work [09:43:20] Change merged: jenkins-bot; [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69317 [09:58:52] Change merged: jenkins-bot; [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69676 [10:37:29] New review: Daniel Werner; "(1 comment)" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69638 [10:38:38] New patchset: Daniel Werner; "Removed obsolete JavaScript globe coordinate parser" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69112 [10:45:38] Reedy: whenever you see this, a status update on the script would be welcome. seems the page looks mighty fine again [11:07:05] Hi all. I have a problem. https://www.wikidata.org/wiki/Q734338 linked to ru:VeriSign, but ru:VeriSign is redirect, and article name was always (since 2007) ru:Verisign. [11:07:26] But Wikidata suggest me only ru:VeriSign. [11:15:39] putnik: i see "Verisign" on that page for ru... [11:15:47] dito [11:16:16] ah, you removed it and added it again [11:16:18] and you actually changed it from VeriSign to Verisign [11:16:33] my guess is that if your new value is "nearly" the same as the old value, you'll get the old value [11:16:51] Denny_WMDE: my guess is that this isn't possible without removing it first. [11:17:05] checking [11:17:08] that would actually be a bug. Maybe Henning_WMDE can confirm [11:18:16] looks like it. could also be because it normalizes to the same. [11:18:18] Denny_WMDE: to check that, you need to actually rename the article, i think [11:18:35] no, you can try to save VERISIGN and it doesnt let me [11:19:08] btw, i do not feel qualified to review https://gerrit.wikimedia.org/r/#/c/68952/5 [11:19:16] well, does VERISIGN exist as a page in its own right? [11:19:23] it does not [11:19:38] but neither does VERISIG and this it could be saved [11:19:42] then it's correct that it doesn't let you save that [11:19:49] DanielK_WMDE: with what are we supposed to replace the deprecated method use \Sites::singleton()->getSite( $link->getSiteId() ); ? [11:19:51] oh? huh. [11:19:52] du you know? [11:19:54] err [11:20:38] Tobi_WMDE: by injecting a Sites object instead of using singleton() [11:21:00] DanielK_WMDE: hmm.. ok. [11:21:17] Denny_WMDE: yea, jeroen should probably review that. or danwe. please poke them, i'm off soon [11:21:51] Denny_WMDE: experiment for the sitelinks problem: If both Foo and FOO exist as separate pages, can you change a sitelink from Foo to FOO? [11:22:08] DanielK_WMDE: review https://gerrit.wikimedia.org/r/#/c/68952/5 ? [11:22:11] i havn't tried, but my guess is that you can't. that would be a bug. [11:23:03] Danwe_WMDE: yes, and the corresponding patch for Wikibase [11:23:21] that's https://gerrit.wikimedia.org/r/#/c/68002/ [11:23:25] DanielK_WMDE: I would feel uncomfortable merging it without JEroen having a look as well [11:23:37] then make him have a look when he comes in :) [11:23:46] but feeback would be appreciated [11:23:56] DanielK_WMDE: Lydia_WMDE says there is already a bug filed for the casechange thingy in sitelinks [11:24:07] ok, good [11:24:24] maybe pick that up soon [11:24:29] i would think it should be easy to fix [11:24:38] sounds like a job for henning :) [11:25:31] putnik: thanks for raising the issue! [11:25:32] https://bugzilla.wikimedia.org/show_bug.cgi?id=46451 [11:32:20] is there any way to figure out how far the rebuildscript is? :) [11:36:48] Denny_WMDE: i can't think of any [11:36:52] the table isn't on the toolserver [11:36:59] (maybe it'S accessible from labs?) [11:37:15] well, the page looks pretty good already [11:37:23] Denny_WMDE: which one? [11:37:27] wikidata [11:37:49] basically, entities with high ids would erronously show as "deleted" when used in a statement [11:37:56] well yea, which page on wikidata :) [11:39:15] most :) eg http://www.wikidata.org/wiki/Q64 [11:39:59] even the coordinate location has a label [11:40:08] and that's a property that has been created rather recently [11:40:44] Denny_WMDE: i'd look for items, not properties [11:44:05] hum? doesn't it go through all pages by pageid? [11:44:14] New patchset: Daniel Werner; "Reverts valueview.Expert interfaces changes from I30cb202 and compensates" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69827 [11:46:19] DanielK_WMDE: ^ [11:46:43] DanielK_WMDE: anyway, this one http://www.wikidata.org/wiki/Q11310243#sitelinks shows sitelinks when purged, so it seems we are done or almost done [11:54:15] New patchset: Henning Snater; "Switching from JS globe coordinate parser to back-end parser" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69048 [12:02:22] Denny_WMDE: it goes through all entities, yes, but i'm not sure of the order. could be page id or something else [12:02:44] good to know we are getting there [12:18:06] New review: Daniel Kinzler; "Several small code hygiene issues. Looks good in principle." [mediawiki/extensions/Wikibase] (master) C: -1; - https://gerrit.wikimedia.org/r/65648 [12:24:27] New patchset: Daniel Werner; "Implements autoActive() for listrotator widget" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69854 [12:37:39] Danwe_WMDE: you really want to block on the "error as an object" thing? is it important for anything specific? [12:37:47] anyway, i'm off. [12:40:03] DanielK_WMDE: It's about the general understandin on how the BadValueSnak should be used and how not. Using the Error object there would make this very clear and it actually shows the issues involved. [12:40:46] I can remove my -1 but it's still something I am concerned about [12:42:59] New patchset: Daniel Werner; "Switching from JS globe coordinate parser to equivalent back-end parser" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69048 [12:43:38] New patchset: Daniel Werner; "Switching from JS globe coordinate parser to back-end parser" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69048 [12:47:55] does someone have time to add the newest properties to http://www.wikidata.org/wiki/Wikidata:Status_updates/Next ? [12:50:28] * TCN7JM raises his hand. [12:50:34] \o/ [13:01:02] Done. [13:01:19] TCN7JM: you're the best [13:01:27] Thanks. [13:03:42] can anyone answer http://www.wikidata.org/wiki/Wikidata:Project_chat#redirect_item ? :> [13:07:51] addshore: no - https://bugzilla.wikimedia.org/show_bug.cgi?id=38962 is for that [13:08:02] (need to hurry so can't add it on project chat atm) [13:08:03] :> [13:08:36] addshore: also https://bugzilla.wikimedia.org/show_bug.cgi?id=38664 is related [13:09:29] ty :) [13:10:12] Lydia_WMDE: do you think the sitenotice is still needed? Just curious how far along the issues are coming [13:10:34] David_Stevenson: only Reedy knows how far it has gone by now :( [13:10:43] Reedy: *poke* :) [13:11:22] David_Stevenson: i need to leave soon but it seems to have come far along so feel free to remove it and add something to project chat as soon as Reedy gives the green light [13:11:37] i'll unfortunately likely be offline until later tonight [13:12:59] okay Lydia_WMDE, thanks :) [13:13:07] sure [13:14:03] * addshore thinks item redirects should be a higher priority :p [13:14:18] addshore: feel free to leave a comment [13:14:25] and get people to vote on the bug [13:14:34] PinkAmpersand: has said everything I was thinking ;p [13:15:08] heh [13:15:11] alright guys [13:15:13] i need to run [13:15:16] have a nice weekend :) [13:15:29] see ya :) [13:24:58] 7.8M [13:33:29] New patchset: Daniel Werner; "Reverts valueview.Expert interfaces changes from I30cb202 and compensates" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69827 [13:34:57] New patchset: Daniel Werner; "Reverts valueview.Expert interfaces changes from I30cb202 and compensates" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69827 [13:38:36] Lydia_WMDE: Hi! Is Wikivoyage support planed for the next deployment or for after? [13:44:06] New patchset: Daniel Werner; "Reverts valueview.Expert interfaces changes from I30cb202 and compensates" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69827 [14:07:47] Reedy: was that figure to go or done? :) [14:07:56] That's the figure [14:08:04] I think another 6M or so to go [14:08:10] okeydokey :) [14:12:17] 8.1M [14:14:50] New patchset: Daniel Werner; "Implements autoActive() for listrotator widget" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69854 [14:43:25] 61.3% or so [15:02:00] Pyfisch: re bug 49887: that's what i said :) [15:03:00] se4598: wrong bug id? [15:03:44] Pyfisch: https://bugzilla.wikimedia.org/show_bug.cgi?id=49887 [15:03:52] ok [15:21:14] New patchset: Henning Snater; "Enabling to specify time values in time output formats" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/69866 [16:08:35] New patchset: Se4598; "Adding separate messages for wikibase-deletedentity" [mediawiki/extensions/Wikibase] (master) - https://gerrit.wikimedia.org/r/69874 [16:34:50] New patchset: Jeroen De Dauw; "Deprecated $wgDataValues" [mediawiki/extensions/DataValues] (master) - https://gerrit.wikimedia.org/r/65677 [18:02:33] 9.51M [18:36:41] 9.73M [18:37:25] what are you counting? wikidata edits? [18:37:36] no, thats how many items have been fixed so far [18:38:45] basically stuff showed up as deleted due to something going wrong, so reedy is running a script to repopulate the table [18:38:47] ori-l: IT'S OVER 9000!!?!?! [18:39:31] 72% or so [18:39:47] I found when you tried to edit the "deleted" property or item, and hit cancel, it re-appeared [18:39:52] probably 6-8 hours till it'll be finished [18:39:54] is that what you're doing? :p [18:40:10] No, not for 13.5 million items : [18:40:11] p [18:40:22] David_Stevenson: Not the most efficent way but Reedy might resort to that eventually :P [18:40:29] Reedy: punishment for breakage [18:40:30] xD [18:40:43] i nearly died of boredom deleting over 100 messages on ilowiki last night [18:42:32] oh, 200 [18:42:34] ffs [19:03:41] :/ [19:06:35] 10.1M [19:10:55] Where is the bugzilla for this fun Reedy ? :D [19:11:09] Not sure there's a bug about fixing it [19:11:24] ahh oh well L) [19:11:25] :) [19:42:36] Tpt_: not next week - maybe the week after but not sure yet [19:48:59] Reedy: what's the repairs status? [19:49:23] 10.9M out of 13.5M [19:49:27] sweet [19:49:29] so most pages are probably fixed now [19:49:59] With the rate new pages seem to being created, it's probably a good chunk less than 13.5M it needs to get to [19:50:14] can someone with access please temporarily op me? [19:50:28] rschen7754: ^ [19:51:28] what do you need it for? [19:51:38] Jasper_Deng: topic change [19:51:59] https://www.wikidata.org/wiki/User_talk:Legoktm#Testwiki_main_page <-- how do i change where the main page points to? [19:52:15] MediaWiki:Mainpage [19:52:36] so i would need to change the /hu message then? [19:52:50] Yeah [19:52:56] legoktm: hi [19:53:00] hi Amir1 [19:53:11] 500 new pages an hour [19:53:13] That's quite low [19:56:54] Sven_Manguard: [19:57:18] thanks [20:00:32] err [20:01:00] there we go [20:01:07] that hasn't been updated in a long time [20:01:40] Sven_Manguard: "Wikidata:" --> "WD:" [20:01:54] wha? [20:02:08] if it's a shortcut, then you use WD: [20:02:13] by convention [20:02:22] "Requests for comment: https://www.wikidata.org/wiki/Wikidata:RFC" --> "Requests for comment: https://www.wikidata.org/wiki/WD:RFC" [20:02:29] Jasper_Deng: actually just cuz its shorter [20:02:31] meh, silly [20:02:31] Sven_Manguard: ty :D [20:02:40] we good? [20:02:46] well, depends [20:02:55] do any admins object to me using the ! team stalk word> [20:03:02] because I can remove it [20:03:02] not really [20:03:13] okay, in that case [20:03:29] you're kidding [20:03:36] ? [20:03:38] I'm not authorized to *de*op myself [20:03:43] hahaha [20:03:49] 11.1M [20:03:55] /cycle [20:04:01] lol [20:04:03] seriously, they should make me a chanop for this channel anyways [20:05:44] Lydia_WMDE: Thanks :-) [20:07:10] legoktm: can you do check and see how many articles of nl wiki are left? [20:07:24] (un-imported to wikidata) [20:08:58] Amir1: i think addshore can do that [20:09:25] ok [20:10:45] addshore: ^ [20:12:41] http://tools.wmflabs.org/addshore/addbot/iwlinks/raw.html?lang=nl [20:12:59] ew? :D [20:13:03] 18,573 [20:13:09] aproximatly [20:13:10] :> [20:13:23] |nostalgia|aa|bi|bm|cho|ho|hz|ii|kj|kr|mh|mo|mus| ne|ng|sq|st|tw|udm|xh| [20:13:26] string join fail [20:13:29] heh [20:13:35] Reedy: no string join intended xD [20:13:47] implode ftw [20:14:07] yup, I think I prefer |s to spaces though ;p [20:14:08] addshore, I think you should update that [20:14:11] and who likes tables! [20:14:14] Amir1: ?? [20:14:22] it updates every day [20:14:27] ttp://tools.wmflabs.org/addshore/addbot/iwlinks/raw.html?lang=nl [20:14:29] ok [20:14:32] as far as I know (unless something has gone wrong) [20:14:52] Amir1: tools.wmflabs.org/addshore/addbot/status/ [20:15:07] also http://tools.wmflabs.org/addshore/addbot/iwlinks/ [20:15:17] :) [20:15:34] :) [20:16:03] addshore: FASTER [20:16:03] addshore: FASTER [20:16:04] addshore: FASTER [20:16:04] I am going to create a way to add a list of articles to the db for the bot to check sometime soon :) [20:16:10] Reedy: faster? :< [20:16:51] hehe >> http://tools.wmflabs.org/addshore/addbot/iwlinks/raw.html?lang=hehe [20:17:56] lololol [20:18:21] I was told I should use so I did ;p [20:25:32] Reedy: what's the status of the epp rebuild script run? [20:26:17] [22:13:03] 18,573 [20:26:24] DanielK_WMDE: ^ [20:26:38] nooope [20:26:48] 11.3M [20:26:49] hmm? [20:26:53] oh [20:41:19] Hmm. DanielK_WMDE what query would be best to find out how many items there are left to be repopulated? [20:58:07] *waves. Peeps awake here, or is this a 'sleep and later response' channel? [20:59:50] Hi [21:01:11] addshore: I filed https://bugzilla.wikimedia.org/show_bug.cgi?id=49978 [21:01:12] 11.6M [21:01:47] :> [21:02:17] Reedy: are we aiming for 12.1M? [21:02:24] I've no idea what the target is [21:02:29] xD [21:02:45] Max 13.5M [21:02:54] I'm not sure what the new ones are [21:02:58] I imagine the number of items? :> so either 12.1M or 13.5 [21:03:01] *lols. Awake, I guess....is ther any guidance about how wikidata wikk handle book citations? Since I'm 'updating and fixing' lots of ISBNs, it would be good to know... [21:03:02] kk :> [21:03:09] *will handle [21:03:32] addshore: if we can work out a rough sql query, I can find out how many left to process [21:03:44] i.e. is merely migrating them to ISBN-13's sufficient for the later change? [21:04:34] Reedy: I'm not really sure what the initial problem was so not sure I would be able to even start to think of such a query ;p [21:04:42] $pages = $dbw->select( [21:04:43] array( 'page', 'wb_entity_per_page' ), [21:04:43] array( 'page_title', 'page_id' ), [21:04:43] $this->getQueryConds( $lastPageSeen ), [21:04:43] __METHOD__, [21:04:45] array( 'LIMIT' => $this->batchSize, 'ORDER BY' => 'page_id' ), [21:04:47] array( 'wb_entity_per_page' => array( 'LEFT JOIN', 'page_id = epp_page_id' ) ) [21:04:49] ); [21:04:54] That's what it's fixing them based on [21:05:12] so I guess a count based on that with no limit [21:05:20] :> [21:05:23] * addshore logs in [21:06:25] legoktm: what we are gonna do about this: http://www.wikidata.org/w/index.php?title=Wikidata:Requests_for_permissions/Bot/Dexbot_3 [21:06:41] ugh, I guess no consensus, Amir1 [21:06:46] Jasper_Deng: ??? [21:06:48] did you read it [21:07:09] $conds[] = 'epp_page_id IS NULL'; [21:07:10] counting opposes and supports [21:07:18] Anyone? [21:07:31] Jasper_Deng: don't count [21:07:33] It's a rule in wiki [21:07:39] Jasper_Deng: read, don't count. [21:07:49] Reedy: the count is basically: number of pages in the main namespace minus number of entries in the epp table [21:07:59] Amir1: I think someone needs to write a script to take the data from https://www.wikidata.org/wiki/User:Byrial/Uncles and ensure the right claims are in the right places so father-->brother == uncle [21:08:00] all pages in ns 0 should have exactly one entry there [21:08:16] Revent: if you don't get an answer here, ask on [[WD:PC]] [21:08:17] [1] 10https://www.wikidata.org/wiki/WD:PC [21:08:25] Revent: did i understand your numbers correctly - it has updated 2 out of 13 million? [21:08:38] err, sorry Revent, that was for Reedy [21:08:51] legoktm: I won't be active for the next week I have to take a break [21:09:00] SELECT count(page_id) from page LEFT JOIN wb_entity_per_page ON (page_id = epp_page_id) WHERE epp_page_id IS NULL; [21:09:09] in theory would do it.. might take a while ;) [21:09:14] Amir1: Ok, well I'll look at it after the weekend probably [21:09:26] legoktm: Thanks....I'm not 'active' on wd....wondering if migrating things on enwiki to {{cite isbn}}, for example, would be helpful... [21:09:27] [2] 04https://www.wikidata.org/wiki/Template:cite_isbn [21:09:31] hehe reedy, no joy for me ;p Table 'wikidatawiki_p.wb_entity_per_page' doesn't exist [21:09:38] o_0 [21:09:49] DanielK_WMDE: It's upto 11.6M, there's a max of 13.5M Q pages currently [21:09:51] DanielK_WMDE: 11.6M done I think it was [21:09:56] So 1.9M to go at a maximum [21:10:13] Reedy: ah, so ~2 million left, not done. good! [21:10:16] *pokes the bot ....that template doesn't exist on wikidata, dork. [21:10:20] Revent: That would definitely be interesting! [21:10:25] Reedy: what is wb_entity_per_page ? :> [21:10:34] addshore: A database table [21:10:41] not for me it isnt ;p [21:10:45] Reedy: btw - that join wold do it, but two counts would very likely be faster :) [21:10:45] addshore: use the toolserver, use the toolserver! [21:10:50] :< [21:10:53] silly labs [21:10:54] Yeaaah [21:11:02] the epp table isn't on the toolserver [21:11:06] sadly [21:11:29] it is nowhere :P [21:11:29] "someone" needs to create a view for that [21:11:31] legoktm: I probably have at least a thousand "ISBN cleanup; SBN & ISBN-10 -> ISBN-13" edits on enwiki, so.... [21:11:38] hell if i remember how to do that [21:11:59] there should be no problem with it being on labs? :) [21:12:10] or is there any secret privacy concerning data in it? [21:12:15] DanielK_WMDE: Oh. No data has to be hidden right? I'll file a jira ticket later then :/ [21:12:25] addshore: no, but it needs to be whitelisted, i suppose. [21:12:37] it's one of those "extra" tables someone has to actually think to put in [21:12:49] ill go and file a bug :) [21:12:54] legoktm: no secrets there [21:13:10] legoktm: you do ts ill do labs ;p [21:13:15] i don't think wikibase adds any tables with any private info, but don't take my word for it [21:13:35] addshore, legoktm: ask for all the wb_* tables [21:13:46] okeydokey :) [21:14:26] heh, https://bugzilla.wikimedia.org/show_bug.cgi?id=48897 [21:14:41] * Jasper_Deng welcomes in MF-W [21:15:04] DanielK_WMDE: do you have a list of all wb_ tables? [21:15:19] * addshore goes hunting [21:15:23] addshore: Reedy would. [21:15:30] indeed [21:15:41] *.sql in extension/Wikibase [21:15:42] "RESOLVED FIXED" [21:15:45] heh [21:16:03] | wb_changes | [21:16:03] | wb_changes_dispatch | [21:16:03] | wb_entity_per_page | [21:16:03] | wb_id_counters | [21:16:04] | wb_items_per_site | [21:16:07] | wb_terms | [21:16:07] DanielK_WMDE: thats as the list of tables that were needed were taken from toolserver (which was in turn missing one or two) :> [21:16:11] cheers Reedy [21:16:24] wb_studios? :p [21:16:44] FWIW, (for elaboration glance at my enwiki user page) I'm interested in using wikidata to 'automatically' update the infoboxes on asteroids and comets per the "Minor Planet Center" 'computer-formatted' updates....tho I gather it's not ready.... [21:17:06] * MF-W waves around [21:17:08] Revent likewise I am insterested in inputing membership dates [21:17:12] addshore, legoktm: http://pastebin.com/QBa1bpf5 [21:17:18] * ToAruShiroiNeko steals MF-W [21:17:20] 11.7M [21:17:30] hi MF-W [21:17:36] hi legoktm [21:17:41] Also many other 'authoritative' releases of astronomical data... [21:17:45] ty DanielK_WMDE Reedy [21:17:59] * ToAruShiroiNeko traps MF-W in a cardboard box [21:18:05] My 'essay' there doesn't address wikidata, tho... [21:18:06] MF-W do you want a challenge? :D\ [21:18:16] hey, remember, this channel is publicly logged [21:18:29] reopened https://bugzilla.wikimedia.org/show_bug.cgi?id=48897 [21:18:41] ToAruShiroiNeko: no? :P [21:18:55] it involves hot steaming editing [21:18:58] Jasper_Deng: I finally find it [21:19:00] meta.wikimedia.org/wiki/Polls_are_evil [21:19:10] Police are evil too [21:19:10] yeah yeah [21:19:13] they gas you [21:20:11] FWIW, I have 'pubeasy' access, so an 'isbn data' bot would be somewhat workable for me to run at some point (once I learn python some more) [21:20:36] https://jira.toolserver.org/browse/TS-1661 [21:23:05] I also poked DaB [21:30:09] addshore: Toolserver done. [21:30:21] :> [21:30:48] I also poked Coren ! [21:30:50] DanielK_WMDE: What do the values in the table mean? [21:31:11] oh i see [21:31:21] qid#, type, and page id [21:48:55] :> [22:03:57] 11.9M [22:04:17] Reedy: ? [22:04:42] Sky2042: see the site notice [22:05:05] Jasper_Deng: Well, I saw the site notice. What does 11.9M have to do with it? D: [22:05:20] the # of rows fixed [22:05:26] If you have to ask, you probably don't need to know ;) [22:08:07] Reedy: Psh. [22:08:24] Jasper_Deng: Dees make sense. [22:10:11] Did the RFD archiver die? [22:13:01] 12M [22:13:28] Maximum of 1.52M to go [22:13:42] Reedy: You're fixing the deleted rows also? [22:13:52] Also? [22:13:52] Yeah [22:13:52] ("deleted") [22:13:55] Same run doing both [22:13:59] or should be [22:14:03] if the script was written correctly ;) [22:14:09] lol [22:24:36] but Reedy wrote it, so who knows :P [22:31:34] 12.1M [22:37:56] addshore: lol [22:57:03] 12.2M! [22:58:48] 12.25M [22:59:03] 12250001 [22:59:05] 12250002 [22:59:31] * Reedy beats addshore [22:59:33] Don't be silly [22:59:42] 12259609 [22:59:43] just ran your query and the count is 2351054 [22:59:47] 12259908 [23:00:55] 2342080 [23:04:23] There should probably be a NS filter on that too [23:05:16] page_namespace = 0 [23:07:28] NamespaceUtils::getEntityNamespaces() [23:07:32] well, whatever that returns [23:07:39] 2246105 [23:07:51] should be done in 8 hours :> [23:07:56] just under [23:09:45] 12.31M [23:11:20] 2.222M [23:14:17] I'm now confused :p [23:14:51] addshore: replag? [23:14:58] *checks* [23:15:25] Reedy: that should return an array of 0, 120, and 122 [23:15:38] lol [23:15:44] Didn't I do 120 seperately? [23:15:57] heh legoktm replag at 2s so i doubt it :P [23:15:59] 12.31+2.2 = 14.51 :D [23:16:04] o.O [23:16:06] Reedy: yes [23:16:37] which was < 500 [23:16:42] mhm [23:18:32] 13.5M items, 12.6 not deleted :D [23:25:24] 12.4M [23:36:31] 12.45M [23:44:27] 12.5M [23:47:26] 1.02M to go [23:58:56] merged https://gerrit.wikimedia.org/r/#/c/69010