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]