Wikipedia talk:Database reports/Articles containing red-linked files

Commons

I might be mistake, but I'm fairly sure that this report counts commons image links as red-linked files, for example, see this article, House of Stuart, according to Wikipedia:Database reports/Articles containing red-linked files/5, 5 of the images are apparently red-linked when they are actually on commons, although oddly not all images on that page are listed, yet are all on commons--Jac16888 ^Talk 05:22, 30 January 2009 (UTC)[reply]

Re-running the report manually right now. Between the replag issues and the data now being about a month old, it's hard to tell what's what. The script definitely should be checking against Commons, but if you find a case where there's (still) a bug after the report updates, please let me know. :-) Cheers. --MZMcBride (talk) 05:40, 30 January 2009 (UTC)[reply]

Hmm, fuck. The replag for S3 (which holds Commons' database) is really high. I thought it wouldn't affect this script because we hit S1, but apparently the replag applies to both.

mzmcbride@bert:~$ mysql -h sql-s1 commonswiki_p -e "SELECT max(rc_timestamp) FROM recentchanges;"
+-------------------+
| max(rc_timestamp) |
+-------------------+
| 20081230151855    | 
+-------------------+

So I just created 44 subpages full of images that have been uploaded since December 30, 2008 on Commons that the database thinks don't exist. :-/ --MZMcBride (talk) 06:16, 30 January 2009 (UTC)[reply]

Is this report now accurate?

I mentioned this database report here when reporting a Commons delinker issue, but am not sure whether this database report is now fixed following the above comments. It looks like it is OK now, but if anyone is watching the page, could they confirm that? Carcharoth (talk) 15:21, 10 July 2010 (UTC)[reply]

Distinguish between Commons and local files?

Is it possible to split the report to distinguish between Commons and local files? Local files will have a local deletion log, but Commons ones won't have a local log (unless the page already existed for some reason)? Maybe provide links to the Commons log and local log for convenience? Carcharoth (talk) 15:24, 10 July 2010 (UTC)[reply]