[13:15:51] tricky proble: https://nl.wikipedia.org/wiki/Producent got disconnected from a Wikidata item. How do I find out which item that was? [13:17:16] multichill https://www.wikidata.org/w/index.php?title=Q12332406&action=history [13:17:55] i tried the easy way : typing "Producent" in the search box ^^' [13:18:03] Alphos: In this case I can find it by looking for producer, but how do we have any log ? [13:18:09] Same problem for https://nl.wikipedia.org/wiki/Push-upbeha [13:18:26] And looking at the history I can find the bot entry when it was first moved to Wikidata [13:18:46] But also ran into some other items which were vandalized and extremely difficult to locate [13:19:15] well, if it's not too old and the vandal did a lot of it, RollBot is here for you :p [13:19:32] (if it's too old, RollBot is here as well, but might not be as effective) [13:19:56] One of the reasons a wiki functions is because every change is very visible [13:20:11] Removing a sitelink isn't visible at all, that's *bad* [13:20:21] indeed [13:20:38] I would expect something in the recentchanges table [13:21:51] Hmm, indeed, it's in the recentchanges table [13:22:16] on wikipedia ? [13:22:20] Yup [13:22:29] 83271137 | 20160731162619 | | 0 | DimiTalen | 0 | Push-upbeha | Deze pagina is ontkoppeld van het item van Wikidata. De taalkoppelingen zijn verwijderd. | 1 | 0 | 0 | 288549 | 46954684 | 46954684 | 5 | wb [13:23:27] no reason why it shouldn't also be more closely related to the page history then :/ [13:23:45] How do I see that log entry on the article... [13:23:52] ikr [13:31:55] Ok. I think I figured it out [13:41:24] Alphos: https://nl.wikipedia.org/wiki/Gebruiker:Multichill/Zandbak [13:42:37] multichill stop using serialize(), use json_encode() >_< [13:43:05] Alphos: Where did I use that? [13:43:43] a:1:{s:20:"wikibase-repo-change";a:13: <-- that's php's "serialize" format [13:43:59] I pulled this directly from the database [13:44:22] It seems to be fast enough to just do it live on the database so I might do that later [13:47:28] hey DanielK_WMDE [14:10:24] multichill: hi! [14:20:35] multichill http://alphos.fr/wikidata/multichill/rc.txt ;) [14:21:47] little under 9 seconds on labs [14:25:42] Alphos: Same query right? Probably still cached. Commandline was 0m17.467s [14:25:57] quite possible, yes [14:26:12] Did you try bigger wiki like frwiki? [14:26:12] though not exactly the same query [14:26:22] let me have a look [14:28:16] a minute and counting [14:29:13] What did you change in the query besides the layout? [14:29:29] You should probably put a limit on it Alphos [14:29:42] Dutch has less than 500 unconnected articles [14:30:02] durnit, putty hung >_< [14:30:22] I hope you have a screen running [14:30:49] nah, it's just it won't budge to Ctrl-C [14:31:08] other putty windows work just fine though :/ [14:31:29] let's try this again ^^' [14:32:07] oh, i see what happened [14:32:10] i'm just dumb [14:32:34] nano rc.php > frwikirc.txt # didn't work as expected, FOR SOME REASON [14:33:41] trying again with `time php rc.php > frwikirc.txt` :D [14:35:00] real 1m24.274s user 0m0.037s sys 0m0.047s [14:35:25] and 294 items [14:37:29] Hmm, that's a bit too long for a web based tool I guess Alphos [14:37:45] yah [14:38:14] 10 seconds i could bear with, 90 seconds is a bit too much [14:38:43] although you could technically produce a report every day at