Last modified: 2014-10-24 19:15:10 UTC
In https://bugzilla.wikimedia.org/show_bug.cgi?id=46358 tracking of image usage on Wikidata was introduced. This seems to work quite well, but the imagelinks table is still lagging. According to https://www.wikidata.org/wiki/Special:MostLinkedPages , image (P18) has 574,947 links. We also have some other image properties. When I look at the imagelinks table: MariaDB [wikidatawiki_p]> SELECT COUNT(*) FROM imagelinks WHERE il_from_namespace=0 LIMIT 1; +----------+ | COUNT(*) | +----------+ | 217659 | +----------+ 1 row in set (0.22 sec) That's quite a few missing links. Can someone please run some sort of maintenance script to get this table up to date?
First we should run that query against prod and make sure that it's really a problem that needs a maint script. (vs. a problem of labs being out of date/corrupt) (see bug 72413 and its linked bugs)
it is a problem, since we introduced support for image links recently. I am not sure which script or solution is best for this but think this is possible somehow.
What action triggers an update Katie? https://commons.wikimedia.org/wiki/Special:GlobalUsage/Grote-Kerk-Haarlem.jpg still doesn't include https://www.wikidata.org/wiki/Q1545193 even after an update and an edit.
i see it there now: https://commons.wikimedia.org/w/index.php?title=Special:GlobalUsage&limit=50&from=Grote-Kerk-Haarlem.jpg%7Cukwiki%7C604749&target=Grote-Kerk-Haarlem.jpg I think the edit triggers a "links update" job that updates the tables, so it might not update instantaneously.