[06:33:59] moin all, I'm going to organize a workshop at a festival soon about Wikidata, a bit about editing and a bit about SPARQL: https://www.wikidata.org/wiki/Wikidata:Events/FvT2018 [06:34:57] feedback most welcome, as well as tips about left-over outreach material from other events that I could "inherit" and share with participants [09:17:02] How long does it take for updated information on wikidata to be retrievable with the wikidata SPARQL api? [09:36:13] Seems it takes more than a few mins, at least 10 :) [09:36:18] Any way to speed that up? [10:16:07] deanc: it's usually shorter than that (about a few seconds) [10:16:18] I think it is tracked by this graph: https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?refresh=1m&panelId=8&fullscreen&orgId=1 [10:16:46] and it seems to be operating normally today [14:20:52] Where is documentation on the badges for sitelinks? I've looked at Help:Badges, Help:Sitelinks, and Special:SetSiteLink without success. [14:25:34] Daask: what kind of information do you want about them? [14:28:41] sjoerddebruin: I'm wondering how "Recommended article" is defined. [14:29:11] https://www.wikidata.org/wiki/Q17559452 [14:29:12] Although now I would also like to add links to documentation to all of the previously mentioned pages for the next person. :) [14:29:18] It differs per project. [14:29:43] sjoerddebruin: There's no definition there. [14:29:45] And I don't see any clear documentation about it. [14:32:08] Well, let's start with my first question. What does "Recommended article" mean to you? How do you use it? [14:33:04] It's to indicate to other projects that there is some article status project on it and that there was local consensus that this article meets the requirements. [14:35:12] For example, English Wikipedia: https://en.wikipedia.org/wiki/Wikipedia:WikiProject_assessment [14:36:08] sjoerddebruin: "some article status project on it"? Do you mean 1) a WikiProject is working on it? 2) It has been assessed at all 3) It has been assessed above a certain threshold, eg. B class 4) It has a higher assessment than any other language Wikipedia article on the topic. [14:37:04] For the English situation, yes. On the Dutch Wikipedia we only have one status that we can add and remove after voting. It's more a local thing. [14:39:56] sjoerddebruin: That was intended to be multiple choice, so I'm not sure how to interpret a yes/no response. [14:40:44] The yes is to the first question. I don't know how the process on the English Wikipedia works, sorry. [14:41:16] So more than one sitelink article can have the "Recommended" badge? [14:41:44] for a single Wikidata item, that is. [14:41:50] Yes, because it reflects something from the local project. [14:42:09] I understand. [14:56:04] Ehm... https://www.wikidata.org/w/index.php?title=Wikidata:Primary_sources_tool/URL_blacklist&curid=21363458&diff=625743230&oldid=578818686 [16:30:10] * Harmonia_Amanda weeps and weeps and weeps [16:31:57] Go Harmonia_Amanda! :D [16:32:13] I feel the same sometimes. [16:32:35] sjoerddebruin, someone did 300 000 wrong edits on your subject too? [16:32:50] 300k? :( [16:32:59] yah 300K [16:33:07] steve_carell_no.gif :( [16:33:23] things like that make me want to leave [16:34:50] you spent months cleaning up things painstakingly so everything is perfect [16:35:25] and then someone delete P31 massively (as if that will somehow correct the sitelinks too) and use bad items massively [16:35:38] I'm tempted to just revert everything >< [16:38:08] Why wouldn't you revert it? [16:38:29] 300k is just insane… was that some long-running thing that you just discovered, or the fastest bot of all time? [16:38:44] because there are approximatively 700K good edits intermingled with [16:38:59] Oh :( [16:39:11] Lucas_WMDE, someone running three or four QuickStatements non-stop for the last week [16:39:41] ugh [16:39:52] and I took time to discover it [16:40:05] because first he deleted all the P31:disambiguation [16:40:14] running multiple QS in parallel to get around the rate limit sounds extremely shifty [16:40:18] even though nearly all sitelinks were disambig [16:40:33] so I didn't spot them immediately [16:41:03] like, if you delete one correct P31 instead of splitting the item, suddenly it works fine! [16:41:08] (ahah, no ><) [16:41:36] I think I'll add again the P31:disambig using Petscan [16:41:48] since the sitelinks are still about disambiguation [16:43:12] I think I'll be able to clear this but it will take me weeks, provided he doesn't add them anymore [16:43:27] <= tired [16:44:09] Lovely. https://www.wikidata.org/wiki/Q20528560 [16:46:00] do you think I can delete all the Latin-script given names on items about Russian people? [16:47:15] I guess. [16:47:19] And this is... wow. https://www.wikidata.org/w/index.php?title=Q14617489&type=revision&diff=625770412&oldid=625770338 [16:47:21] there are so many wrong given names I think it would be actually easier to delete everything and start again [17:15:16] sjoerddebruin: :D [17:15:25] Hm? [17:15:44] The Estonian artists :D [17:15:53] Ah, indeed. [17:16:00] Did I fix it correctly? [17:16:17] Seems good to me [17:16:19] My Estonian is still a bit rusty. :P [17:16:31] Getting better, though, it seems :D [17:16:39] sjoerddebruin: you removed the “sex or gender” but kept the “occupation”? [17:17:10] Lucas_WMDE: removing that now as well, adjusted the constraint earlier [17:17:16] ah, ok [17:17:29] "occupation of a person" and then allowing groups of humans seems weird to me. [17:51:48] Did you saw this one, Harmonia? :P https://twitter.com/K_rho/status/959384124397154304 [17:53:59] we are actually missing so many given names it's crazy [17:54:09] I mostly work with family names though [20:25:06] Hiya and thanks for the awesome data repository [20:25:19] Haha, thanks :D [20:26:12] I want to install Wikibase Client Extension but I don't understand composer.. it confuses me and anyways is dangerous to use software which one doesn't understand what it does [20:27:06] You're following https://www.mediawiki.org/wiki/Wikibase/Installation? [20:27:16] I'm looking at it now [20:34:58] I'm looking at https://www.mediawiki.org/wiki/Composer [20:36:30] maybe I should install composer and install the dependencies with it [20:36:49] Yes :P [20:37:07] definitely :) [20:37:15] I gonna take a snapshot of the server now [20:37:25] and make traditional backups too [20:37:43] probably in the other order. first make backups and then snapshot the machine [21:00:11] Ok. Done with the prepwork made, verified and distributed backups and snapshot the system disk [21:11:10] I can't decide if I want latest snapshot of composer or the latest point release. I don't know what the up-and-downsides are and I don't know how I update composer [21:15:48] WikidataFacts: I answered on his talk page, is the issue more clear now? [21:16:10] Harmonia_Amanda: yes :/ [21:16:25] but he seems willing to help, at least :) [21:16:38] yeah, that’s great [21:16:44] discussion still sounds friendly at least [21:16:46] so that's a big up compared to the last time someone did it [21:17:08] (yes, it's 2018 and I'm still cleaning Yellowcard edits from 2013) [21:17:49] WikidataFacts: he spotted himself some of the errors and had started correcting these before my message [21:18:08] but I think he wasn't aware at all of the other issues [21:18:20] Harmonia_Amanda: I *think* I saw the talk page section before your first reply a few days ago already, it sounded familiar [21:18:26] but I’m not sure [21:18:58] well I wasn't aware of his edits before today [21:19:25] 'til I opened my list of disambig to split up and suddenly it was practically empty [21:19:46] which was a serious warning ^^ [21:19:52] yeah, Firefox History in my main profile says I visited his talk page on January 29th [21:20:02] but I’ll be damned if I can remember what prompted it… [21:20:10] “oh no, no more work to do!” ? [21:21:05] more like [21:21:36] maybe someone decided to clean up 30 00 items today but most probably someone made a QuickStatement without thinking ahead [21:21:45] yeah… [21:22:00] I'm wary when the lists of errors go down too quickly [21:22:15] especially when cleaning up the items is complicated [21:22:32] 30 000 in one week, correctly? that was very unlikely [21:22:41] It's only the second day of February and you. already edited for 17 hours :P [21:22:52] sjoerddebruin: I did? [21:23:00] According to http://wikidata.wikiscan.org/date/201802/users [21:23:12] sjoerddebruin: that's petscan [21:23:17] Still :P [21:23:32] it takes time since it does one edit per ten second [21:23:46] so you make one petscan and it turn for hours [21:24:09] Yeah, good old days back then when running tools for the night. [21:24:14] I have three petscans running right now [21:24:33] Because there was so much work to do :D [21:24:54] A Wikibase question if I may: If a wiki has the Wikibase Repository Extension installed. How difficult is it to move the repository to another wiki later on? [21:26:11] >< [21:26:17] Internet >< [21:26:22] (repairing the issue of the day, well, some of it) [21:26:22] but in fact I'm playing the Sims :p [21:26:34] jubo2: hm, not sure… [21:26:56] move just the Wikibase entities and keep other content pages on the same wiki, you mean? [21:27:33] WikidataFacts: [21:27:47] But for now I'm going to just install the Client extension [21:28:02] exporting all pages from the entity namespaces with Special:Export, and then reimporting them on the other wiki, could work [21:28:16] (you might need to adjust some counter afterwards so that new items and properties start counting at the right offset) [21:28:25] WikidataFacts: no one had an opinion after your crazy ontologies proposition :'( [21:29:37] Harmonia_Amanda1: perhaps you could ping a relevant WikiProject? :P [21:29:58] WikidataFacts: I wrote on all their talk pages the first day [21:30:15] Figure skating, sports, sports results, Olympics [21:30:29] ah, cool [21:30:33] I didn’t see that [21:30:40] you see a Wikiproject I would have missed? [21:31:05] I don't think we have a generic "winter sport" project [21:31:23] or it's not correctly categorized [21:31:31] no, I can’t think of any other WikiProject [21:31:46] but that brings up a good point regarding https://www.wikidata.org/wiki/Wikidata_talk:Property_proposal#Best_practice_suggestion – using the talk page instead of {{ping project}} [21:31:47] 10[1] 10https://www.wikidata.org/wiki/Template:ping_project [21:37:19] Now I have a broken wiki .. the step 'composer install --no-dev' did complain a lot about zip and unzip missing but seemed to do the job. Maybe I should rerun it [21:37:39] and naturally install the zip and unzip before that [21:41:44] Nope. 'composer install --no-dev' pretty much said "nothing to do" [21:46:23] Something broker something.. I'm getting a "Cannot access the database" error onwiki [21:46:27] *broke [21:46:57] WikidataFacts: ^ [21:47:59] jubo2: not sure how that could happen… was MediaWiki previously installed without composer? [21:49:02] of course it was, WikidataFacts [21:49:12] for many years it didn't need composer at all [21:49:39] WikidataFacts: yes, without composer [21:51:13] jubo2: I’m not sure if it’s supported to use composer with such an install [21:51:25] for my development wikis, I clone mediawiki and then do everything via composer [21:51:43] whereas in your install, I assume you downloaded a tarball from mediawiki.org which included not just mediawiki, but also its dependencies [21:51:56] so – wild guess – it’s possible that composer now got confused by that [21:52:03] I have no idea if that’s supposed to work or not [21:52:11] aha.. you may be on to something WikidataFacts [21:52:49] WikidataFacts: I remember some step saying the some things in composer are not up-to-date. [21:52:59] update.php? [21:53:06] update.php warns about that [21:53:06] some kind of picture of what is and what is not installed being messed up [21:53:41] you might need a `composer update` [21:53:45] but first, what’s the error message? [21:54:09] WikidataFacts: error message is "Your composer.lock file is up to date with current dependencies!" [21:54:23] hold on.. that is not an error message [21:54:49] nope :) [21:55:09] I don't get it.. why the wiki suddenly is not able to contact the database [21:55:37] can you access the database from the commandline (e. g. `mysql`)? using the username and password from LocalSettings.php? [21:55:47] lets try [21:56:19] WikidataFacts: Yes. [21:56:29] hm. [21:58:29] you could try asking on https://discourse-mediawiki.wmflabs.org/ … [21:58:39] I’m not sure how to troubleshoot this further, I’m afraid [22:01:06] https://www.mediawiki.org/wiki/Manual:DBError.php says to check /var/log/apache2/eror.log [22:01:10] s/eror/error/ [22:01:17] WikidataFacts: Ok. I'll look [22:01:52] It says [22:02:03] [Fri Feb 02 21:48:52.972045 2018] [:error] [pid 3395] [client 151.0.234.46:62118] script '/var/www/consumerium.org/develop/wp-login.php' not found or unable to stat [22:02:21] what the hell is wp-login.php ? [22:02:50] no hold on that is age-old [22:03:14] probably just some random thing checking if you’re a WordPress installation [22:03:20] and if yes, if you’re vulnerable to any issues [22:03:25] I get those all the time on my website too [22:03:44] just trying some common paths to wp-login.php [22:04:00] WikidataFacts: First thing you should do when helping to troubleshoot is to tell to look at the logs and if that doesn't help then turning on more verbose logging and looking again [22:06:09] …okay? [22:11:23] WikidataFacts: This is a pastebin of my notes of what I did to (try to) install Wikibase Client Extension -> https://pastebin.com/cht2F2Vi [22:11:55] wait [22:12:11] you’re installing only WikibaseClient? without Repo? [22:12:56] so have you configured some other wiki (database) as the repository for the client? [22:14:13] have you set up these settings? https://www.mediawiki.org/wiki/Wikibase/Installation/Advanced_configuration#Required_settings [22:14:24] the client needs *some* repo to connect to [22:21:24] I think that could explain the “cannot access the database” error, if $wgWBClientSettings['repoDatabase'] is set to some database (perhaps the default) that doesn’t exist [22:33:51] WikidataFacts: yeah.. that could be the problem [22:37:25] I added the "required" settings of Wikibase Client to LocalSettings.php [22:37:46] I probably need to run the populate database tables stuff again now [22:38:53] Nope. Didn't helå [22:38:55] *help [22:39:03] :( [23:28:03] Trying to install Wikibase Client Extension onto http://develop.consumerium.org/wiki/Main_Page I get "cannot connect to database" in the wiki. Here is the contents of $wgDebugLogFile https://pastebin.com/QxhnGtj2 (it shows what happens when 'php maintenance/update.php', 'php lib/maintenance/populateSitesTable.php' and 'php lib/maintenance/populateSitesTable.php' are run [23:34:24] Now I'm reading some threads and they are saying that using the WBC to access the Wikidata repo is not (was not?) possible [23:35:57] If this is correct now then the next question is that can I make a copy of the Wikidata repository data? [23:38:55] jubo2: that’s still correct as far as I know, the client needs direct access to the repo’s database [23:40:05] Ok so what I was thinking of doing (setting up a WBC that accesses Wikidata repository) is not doable [23:40:56] So is there a way to export the data from Wikidata and import it to a Wikibase repository? [23:50:27] So what is the best way to mirror Wikidata's knowledge so it is accessible to the local wikis? [23:51:06] there are wikidata dumps [23:51:38] but I also need a repository that is just for storing Consumerium-specific info [23:51:57] Can I access more then one repository from WBC ?