[00:36:07] Disaster? I think multichill means opportunity! ;-) [08:33:20] why does https://quarry.wmflabs.org/query/14628 return two rows? [10:40:28] Question regarding tool development: I want to work on Wikidata edits in which German descriptions have been modified (created, changed, or deleted). I guess it would be the best to query wikidatawiki_p at Tool Labs (I have access and understand SQL), but I am not used to Wikidata’s database layout and find it difficult to learn about it at mediawiki.org. Any suggestions, or hints which databases/fields are relevant and useful to ident [10:44:47] https://www.mediawiki.org/wiki/Wikibase/Schema/wb_terms [10:45:37] Hm, https://www.mediawiki.org/wiki/Wikibase/Schema/wb_changes isn't much helping... [10:46:47] that's why I'm asking [10:47:32] looks like that: https://quarry.wmflabs.org/query/14632 [10:47:53] but some documentation would be nice, or someone with experience in that field [10:48:01] true, true [10:50:07] maybe I should ask Yair rand, whose DiffLists.js filters watchlist or recent changes similarly [10:50:43] you could maybe try looking at rev_comment in the revision table, but it wouldn't find everything, only the edits where the summary mentions that the german description changed [10:52:18] correct, edits with tools such as nameGuzzler would not be found; DiffLists.js still manages to filter them [10:53:48] Might the incremental XML dumps be something then> [10:56:00] Oh, that's summaries too... [10:57:17] could be a fallback solution if the database can't help me, since I am particularly interested in not-so-recent edits of the pre-ORES time; I would still have to find out how to identify de-desc modifications then [11:00:08] I just tried to see what difflists does, but I just get a syntax error from it :/ [11:01:32] works here [11:03:01] did you ever use it before? [11:05:47] nikki: you used importScript() which is at least deprecated to my knowledge. try instead: mw.loader.load('//www.wikidata.org/w/index.php?title=User:Yair_rand/DiffLists.js&action=raw&ctype=text/javascript'); [11:06:10] I copied it from https://www.wikidata.org/wiki/Wikidata:Tools/User_scripts#DiffLists.js :/ [11:07:05] this old importScript() is still around everywhere unfortunately [11:09:06] didn't help though :/ [11:09:23] do you have LocalStorage enabled? [11:09:40] this was a problem when I started to use it [11:09:50] it's saying "SyntaxError: missing ) after argument list" for line 78 (the one with msgNameArray) [11:10:34] and yes, I don't even know how I would disable localstorage if I wanted to [11:11:00] ah, okay [11:14:00] try to find that error as well, but my browser console is swamped with ReferenceErrors and SyntaxErrors --- still DiffLists.js works^^ [11:15:54] anyway looking at the code, it seems to do a query similar to https://www.wikidata.org/w/api.php?action=query&prop=revisions&titles=Q4115189&rvstartid=414298232&rvdiffto=414298461&rvlimit=1 [11:16:56] (and then parse the html) [11:18:12] good idea [11:18:42] do you know whether the diff view html is cached and accessible on Tool Labs? [11:20:49] no idea :/ [11:21:03] k thnx [11:21:26] what are you actually trying to do anyway? [11:22:00] it probably isn't, because you can open diffs between arbitrary versions and they are definitely not holding all possible diffs available. I guess it's generated on the fly when I open a diff page [11:27:15] recently the app and the mobile frontend started to show de-descriptions in dewiki. I'd like to have a look at older (pre-ORES, pre-DiffLists) edits (maybe even filtered for IPs, new users, only unpatrolled edits, ...) to identify vandalism, maybe also by enabling other users to look at this list. meanwhile we have good countervandalism activity at wikidata, but this was not the case at all times, and there are some older vandalized desc [11:37:57] I see [11:41:43] I think most vandalism would come from normal edits rather than tools [11:43:27] correct, I meanwhile try to look at rev_comment in the revisions table [13:02:01] multichill: some twat made empty items for a lot of pages on nlwiki again [16:59:27] What can be the reason that the {{Label|Qnr}}-Template does not output anything in our Wikibase-installation? [16:59:27] * can it be that some sort of index has to be generated? [16:59:27] * can it be that we are am using the "Item:"-namespace for entities and not the main namespace like Wikidata? [16:59:28] 10[1] 10https://www.wikidata.org/wiki/Template:Label [19:03:46] i'm asking semi-protection for Q15975 [19:04:19] looking [19:04:57] 1 month [19:05:51] Who's the people to add to RevisionSlider patches for review? :) [19:06:05] * andre__ realizes that this might be offtopic in #wikidata - sorry [19:06:20] Yeah, I don't think the Wikidata team is working on that. [19:06:30] And it's Saturday evening here. [19:06:42] https://github.com/wikimedia/mediawiki-extensions-RevisionSlider/commits/master suggests otherwise ;) [19:08:20] Maybe addshore will see this message despite being idle for 1 day, 4 hours, 40 minutes and 43 seconds? :) [19:08:38] I can snap chat him [19:09:14] I'm jealous. [19:09:56] Well, I say that... He's definitely sent me them before [19:42:37] andre__: Reedy sjoerddebruin I can look at it when I get home :) (which will be shortly) [19:47:49] addshore: awesome. Thank you. [19:48:20] addshore: you know the GCI drill - 36h of time to push either "Approve task" or "Needs more work" on the GCI site, hence I'm sorry for nagging :-/ [23:48:04] sjoerddebruin: Yah! Who was it this time? Usually we can blame BotMultichilllT. [23:50:21] multichill: Nikosguard [23:54:37] sjoerddebruin: In my experience honey works much better than vinegar [23:55:01] I should wait until the anger went away... [23:55:40] Or just leave him a better message tomorrow explaning him why you appreciate his effort and why it's not having it's intended result