[00:09:51] Hi guys! I'm trying to clone this https://exploringdata.github.io/vis/programming-languages-influence-network/, which uses freebase as its data source. It seems that I have to use Wikidata's service instead, since the freebase API is not working anymore. But I checked several entity pages and found that many of the influenced/influenced-by relationships between languages are missing. So does it mean Wikidata contains only part of fre [00:11:22] Hi all, can someone make a quick query for me? "Items with P31:Q16521, but no P225" [00:21:22] nvm, figuredit out :D [00:23:02] Josve05a http://tinyurl.com/hocubrz [00:23:28] hmm....that's smarter than my query xD [00:23:49] what I tried: http://tinyurl.com/gulghta [00:25:34] 2158946 instances of Q16521, 2119228 instances of Q16521 with P225, so there's 39718 instances of Q16521 without P225 [00:26:14] and it times out if you pick more than roughly 800 items [00:27:07] huh...my query which I tried didn't timeout, and generated 40804 rows... [00:27:18] yours may seem less smart, but doesn't timeout :/ [00:28:25] but it gives more than expected ^^' [00:30:00] can't get everything here in life :/ [00:30:15] https://www.wikidata.org/w/index.php?title=Q1391863&action=history I'm finding merge candidates :D [00:30:26] the optional + filter(!bound()) instead of filter not exists seems useful [00:30:32] weird though [00:31:18] (i'd expect filter not exists to be somewhat faster than attempting to bind, then check if bound) [00:31:33] on that note, it's way past my bed time :D [00:32:58] I just copied CLAIM[31:16521] AND NOCLAIM[225] and pasted it on http://tools.wmflabs.org/wdq2sparql/w2s.php to convert to sparql... [03:32:36] Why am I still awake editing WIkidata at 5:30 am [10:39:56] so some Wikibase php55 job segfault [10:39:58] the bug is https://phabricator.wikimedia.org/T142158 [10:40:02] and I get a PHP stacktrace there :} [10:40:12] no idea how to narrow the root cause / reproduce etc though :( [10:56:30] I was playing with the new sparql thing for the number of statements... I thought there was a mistake in my query but no, some items really do have huge numbers of statements... http://tinyurl.com/jkd8svk [10:57:07] (don't blame me if you click an item link and your browser hates you for it :P) [10:57:27] nikki: we can always find a reason to blame you [10:57:31] if we try enough [10:57:33] :p [10:57:50] I'll just blame you back! :P [10:58:22] that's fair [11:00:26] not everything is indexed already, right? [11:00:41] Hello, based on what the posts on wikidata project chat get deleted ? [11:00:42] right [11:00:59] and there's a problem with items showing up as having no statements even though they do [11:01:13] GhassanMas: hm? [11:02:11] sjoerddebruin: I have start a discussion a month ago on wikidata project chat. it's deleted now [11:02:46] It gets automatically archived after 7 days since the last comment. [11:02:46] I am interested to know why, did I post in the wrong page? [11:03:04] we very rarely delete discussions [11:03:12] but we archive frequently [11:03:23] https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2016/08#Wikipedia_corpus_to_Wikidata [11:05:10] Ooh I thought I would get a notification once anybody comment on it! [11:06:00] No, that only happens when a page uses flow, a new experimental discussion system. [11:06:28] * harmonia loves flow [11:07:06] I'm missing some features, the inactive development worries me [11:07:56] sjoerddebruin: there was a sondage last week [11:08:04] hmm, is "sondage" an English word? [11:08:18] it's not one I know [11:08:20] survey? [11:08:30] survey yes! [11:08:45] so, there was a survey last week [11:08:57] to ask Flow users what we want [11:09:17] so maybe some features will come:) [11:09:45] some simple search, filter for sections created by you... [11:11:48] sjoerddebruin: https://wikimedia.qualtrics.com/jfe/form/SV_cHm4YCZ4AaoAOr3 [11:12:06] Yeah, I saw it briefly. [11:12:06] languages available top right [11:12:21] Very confusing that screenshots are from the French Wikipedia, that uses extra CSS for discussions. [11:14:42] I don't like flow :( [11:14:56] Care to explain? [11:15:17] (I like the system, but I don't want to enable something that doesn't show active development) [11:15:28] it seems like it's designed for a very specific way of working and if that doesn't work for you, tough [11:15:49] like I don't like getting notifications for every single thing I'm watching. I find it really stressful [11:16:04] I turned off the notifications, but now I get *no* notifications at all, not even pings [11:16:35] that's not flow, that's echo [11:16:46] not the same thing [11:17:02] flow presumably determines when it's going to generate a notification though [11:17:34] So you don't get mentions for flow if you have disabled notifications for Flow but have enabled notifications for mentions? [11:17:36] I prefer to use my watchlist if I want to follow stuff, but that doesn't work either because pages show up as already read when I haven't even looked at them [11:17:40] right [11:17:55] unless they've fixed that, but as far as I can tell, nothing has changed for a long time [11:18:00] that sounds confusing to me yeah [11:18:39] nikki: you should speak to Trizek [11:18:57] there are already tickets for the issues [11:21:14] meh [11:21:42] * sjoerddebruin hits nikki with his Wikidata-mug [11:21:48] I hate when I misclick :( [11:22:01] sorry about that [11:23:58] I was quite happy when someone accidentally rollbacked an edit of mine, it's nice to know it sometimes happens to other people too :P [11:49:39] Concerning Notifications nikki, you can turn off just Flow notifications into your preferences. [11:50:15] you will still receive mentions, afak. [11:50:22] has that been changed recently then? [11:50:44] because I turned that option off ages ago and didn't get mentions [11:51:04] (I don't know whether I'm still not getting mentions or if nobody's mentioned me on a flow page lately :P) [12:47:48] I'll run some tests, nikki [14:15:06] i need help in creating wikidata on a particular article [14:17:09] !admin [14:22:27] how to create a wikidata [14:31:51] will there be anyone here who could assist me? [14:33:21] !admin please help [15:12:45] Niknik_ what article would that be ? [15:13:00] Crisanto Rances [15:14:46] then you'll need to create a new item ( https://www.wikidata.org/wiki/Special:NewItem ), give it the relevant properties (at least P31:Q5), and add a sitelink to enwiki:Crisanto Rances [15:18:49] Im on "create a new item" page, i dont know what put on every field [15:21:45] now what? [15:25:12] What label and description shall I enter [15:25:31] at "language", give it "en" (for "english"), then at label give "Crisanto Rances", and as a description "politician from the Philippines" for instance [15:25:45] and as an alias, "Cris Rances" [15:25:51] how about the alias? [15:26:15] [17:25:43] and as an alias, "Cris Rances" [15:27:51] Done. whats next? [15:28:33] what else do you see in that form ? [15:29:20] if you see something, fill it with your best knowledge, if you don't, what more do you expect to have to add ? submit the form already ! :) [15:29:23] It says statements [15:30:08] did you create it yet ? [15:30:48] ah right, now i see it [15:31:18] so you'll need to add statements. statements help describe the item, and they're of the form "property" : "value" [15:31:29] Im done. but when i click on the edit link on the statement it says "By clicking "save", you agree to the terms of use, and you irrevocably agree to release your contribution under the Creative Commons CC0 License. [15:31:42] you should see a +add [15:32:10] well yes, much like wikipedia is under CC-BY-SA, wikidata is under CC-0 [15:32:18] yes. what will i do then with that +add [15:33:02] it seems you've already clicked on it, since you're seing "you irrevocably agree to release your contribution under the Creative Commons CC0 License" [15:33:15] so for instance, you could mention the fact the item is about a human being [15:33:24] which is what P31:Q5 says [15:34:05] P31 is the property "instance of", Q5 means "human" [15:34:09] I'm on the +add sign part [15:34:32] ... [15:35:35] so after I'm done with the +add what will I do next? [15:37:14] refresh the page, i've given you a push [15:38:16] when you click "+add", the first thing it asks is what property you want to add. pick one that suits your need (for instance "date of birth" - just type it), then it'll ask for a value (just input the relevant date of birth) [15:44:41] Niknik_ : have fun :) [15:45:34] I'm done with it. but how can I arrange them in the order I want to put them? [15:49:03] not that i know of, but it doesn't matter anyway ;-) [15:51:02] So are done creating a wikidata? [15:51:54] pretty much [15:52:56] By the way, what's the main purpose of creating a wikidata? [15:53:49] you can still add lots of info, such as position held, a category on Commons, parents and children, etc... [15:54:12] the goal is to get easily queriable data [15:54:20] Will that then link on my article now? [15:54:54] it does since i added the sitelink to enwiki https://www.wikidata.org/w/index.php?title=Q26898092&diff=376587266&oldid=376587240 [15:56:06] the article is confused written though, the person died according to the infobox but that isn't reflected in the text itself [15:56:14] ok then. thank you so much for your help. :) [15:56:23] you're welcome [15:57:53] Niknik_ there are lots of properties applicable to people, have a look at https://www.wikidata.org/wiki/Wikidata:List_of_properties/Person [15:59:09] yes, i can see that. I'll edit it if I would have enough time [15:59:47] By the way, what about adding a reference? how can i do that [16:04:36] on each statement, you'll see "+ add reference". just click it, and fill what's requested [16:05:07] will there be a dropdown menu to choose from? [16:05:08] "reference URL" expects an URL, "stated in" expects another wikidata item [16:12:59] thanks for the added infomation [17:03:01] It's great to see so much support already. <3 https://www.wikidata.org/wiki/Wikidata:Property_proposal/KvK_company_ID [17:50:14] hi - people helped me yesterday with questions around the calendar model, I have another problem - the date I am pulling through year() in SPARQL is off by one when it is a b.c.e. date [17:50:20] https://query.wikidata.org/#%23%20query%20for%20www.dageshify.com%2FautoMath%20%0A%23%20%22do%22%20stands%20for%20%22date%20of%22%2C%20as%20in%20%22date%20of%20birth%22%20or%20%22date%20of%20death%22.%0ASELECT%0A%2a%0AWHERE%20%7B%0A%20%20wd%3AQ8747%20p%3AP569%20%3Fdo_statement%20.%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%3Fdo_statement%20psv%3AP569%20%3Fdo_value%20.%0A%20%20%20%20%3Fdo_value%20wikibase%3AtimeCalendarModel%20%3Fd [17:50:31] shows the issue [17:51:05] Guest94140: you’ll have to use a link shortener, IRC cuts off messages after a certain length (at least I hope it’s not just my client) [17:51:11] see the chain icon in the upper right corner of the query editor [17:51:37] you can click that to get a tinyurl link to the query [17:51:49] http://tinyurl.com/zqak9m2 [17:51:55] thanks! [17:52:51] in the query, ?do has a year of 401 bce, but ?do_year is 400 bce [17:53:01] and all my bce years are like that [17:53:07] off by one [17:53:22] it may be related to the calendarModel, but I'm not sure [17:53:46] WikidataFacts: good evening <3 [17:54:33] sjoerddebruin: hi :) [17:54:56] Guest94140: not sure why that’s the case… I think we need a calendar expert here [17:55:14] perhaps 1 BCE is intentionally year 0, so that you can subtract years without problems [17:55:24] because there’s no year 0 in the Gregorian calendar afaik [17:55:49] oh - subtracting years for duration - clever [17:57:03] SMalyshev helped me yesterday - should I wait for them to show up again or is there someone else? [17:57:19] I'm here [17:57:36] hi! I'm back with more questions [17:57:54] yes? [17:58:18] can you take a look at http://tinyurl.com/zqak9m2 [17:59:02] ok, what's up with it? [17:59:03] you will see that ?do binds to 401 bce, but ?do_year binds to 400 bce [17:59:28] this is what I'm seeing across the board - my bce years are all off by one [17:59:36] -400 is not 400 bce, it's 401 bce [18:00:10] ok - thanks! all I needed to know [18:01:13] new iso standard has year 0, but bce notation does not [18:01:44] thus the difference [18:01:47] got it [18:02:02] thanks again [18:02:09] no problem [19:29:11] PROBLEM - wikidata.org dispatch lag is higher than 300s on wikidata is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1733 bytes in 0.745 second response time [19:29:43] no clue what ^^^ could mean :( [19:30:15] wikidata is slowing down though [19:34:39] some "dispatch" thing is stall https://grafana.wikimedia.org/dashboard/db/wikidata-dispatch [19:40:29] is master broken? [19:40:34] https://integration.wikimedia.org/ci/job/mwext-testextension-php55-composer/5005/console [20:01:42] RECOVERY - wikidata.org dispatch lag is higher than 300s on wikidata is OK: HTTP OK: HTTP/1.1 200 OK - 1723 bytes in 0.240 second response time [21:04:21] Amir1: ? *looks* [21:05:06] Amir1: looks like core has changed and now wikibase things are broken? )(at least I saw lots of core things like that changing recently..) [21:05:16] but thats odd, as wikibase tests should run with core.. [21:05:41] and hashar dispatch fixed itself I see? :P [21:06:13] it looks like the script hit a buck load of exceptions https://grafana.wikimedia.org/dashboard/db/wikidata-dispatch-script (i'll go take a look) [21:20:19] addshore: I got wikidatawiki back to .18 :D [21:20:25] addshore: your dashboard is super nice [21:20:34] :) which? ;) [21:20:42] and okay, im looking for the logs now [21:20:42] ALL of them ! [21:20:45] addshore: lets catch up tomorrow. I really need to sleep [21:20:49] okay! [21:20:52] there is a task filled somewhere [21:20:58] okay! [21:21:01] 21:10:49 ...............................PHP Fatal error: Call to undefined method LBFactory::singleton() in /mnt/jenkins-workspace/workspace/mwext-testextension-php55-composer/src/extensions/Wikibase/client/includes/Hooks/ChangesListSpecialPageHookHandlers.php on line 93 [21:21:06] 21:10:49 Fatal error: Call to undefined method LBFactory::singleton() in /mnt/jenkins-workspace/workspace/mwext-testextension-php55-composer/src/extensions/Wikibase/client/includes/Hooks/ChangesListSpecialPageHookHandlers.php on line 93 [21:21:12] Reedy: LBFactory is gone [21:21:15] Yeah [21:21:26] Did no one bother cleaning up usages first? [21:21:31] Reedy: recent change in mediawiki core, and I am not sure why it is not back compatible / raising a deprecation [21:21:41] so might want to revert it in core :]]]]]] [21:21:48] mmm [21:22:08] | * | | 0e5cd18 - Rename LBFactory => LBFactoryMW and make LBFactory in /libs (4 hours ago) [21:22:11] Reedy: CI should have broken anyway, as wikibase tests are run for core... [21:22:23] so something else [21:22:30] anyway sleep time for me sorry [21:22:30] the change should have been unmergable.... [21:22:34] night hashar ! [21:24:22] Reedy: Amir1 https://gerrit.wikimedia.org/r/#/c/310536/ was the change, just added a comment [21:43:25] Probably there are necessary changes in wikibase master [21:44:07] But we don't update wikibase every week and not aware it was necessary to do so or backport changes [21:44:54] And not sure why this wasn't caught on the mediawiki core deployment branch [21:47:29] Hello, on the archive project chat page there is a statement that says "don't edit this page, make the edition on the typical project page" but how do I do that if the discussion I want to add comment to is on the archive page ? [21:47:52] Just start a new discussion, pointing to the old. [21:49:19] Seems legit, so the system would automatically detects the overwritten discussion ? [21:49:57] No. [21:52:15] It should detect it and delete the old discussion, don't you think so? [21:52:32] That would make the system very complicated. [21:52:36] audephone: are you talking of the LB things or the dispatch thing? [21:53:46] So do you agree that I should do that manually? [21:54:53] "As [[projectchat archive#section|previously noted]], et cetra." [21:54:54] 10[1] 04https://www.wikidata.org/wiki/projectchat_archive%23section [21:55:52] audephone: are you talking about the LB thing or the dispatch thing? [21:59:13] bah lags [22:06:31] Addshore maybe both [22:06:35] Might be related [22:10:08] the Failed to run getConfiguration.php that seemed to kill dispatch is happening in other places too [22:11:40] What other places? [22:13:33] other wikis, ill give you a logstash link in a sec, but im guessing its a general wmf19 issue, that our dispatch script just hit and stoped totally, hence it was noticed [22:15:31] audephone: goo.gl/2hMRjT [22:15:34] http://goo.gl/2hMRjT [22:19:02] I added a comment to https://phabricator.wikimedia.org/T145819 [22:19:08] but now I think I will go to bed.. [22:20:16] Ok [22:20:40] I should be home maybe 3-4 hours from now [22:21:10] speak tommorrow! (though I'm at a conference so will be fairly busy!) :D