Wikipedia talk:Database reports/Articles containing links to the user space

Slight Fix
This is really useful, there is one slight problem with it though, a numbers of the pages are ones with translation in progress tags, which include a link to the requesting user, for example, Veronese Easters. Anyway to exclude these? —Preceding unsigned comment added by Jac16888 (talk • contribs)
 * As far as I'm aware, that template should not be on articles at all. It looks like shit and is meant for talk pages.... And why is it even on that page? That page is in English. --MZMcBride (talk) 19:00, 5 December 2008 (UTC)
 * Follow-up: "The person requesting the translation should then add the banner to the Translation Requests of this month and to the talk page of the article." So, if you come across these, please move the template to the talk page. :-)  --MZMcBride (talk) 21:30, 5 December 2008 (UTC)
 * I've moved all the templates to talkspace - if its not too much trouble, please could you run this report again to clear out the list of them, there was well over a hundred--Jac16888 (talk) 20:25, 13 December 2008 (UTC)
 * List updated, though the dramatic drop in entries makes me think something is likely broken. I'll poke at this tomorrow. --MZMcBride (talk) 06:24, 14 December 2008 (UTC)
 * Wow, yes probably, I mean there was 100-150 translation requests and I removed userpage links from 50-75 pages but there's surely no way it dropped from 900 to 80. On the plus side, I can at least try and clear these for now--Jac16888 (talk) 06:41, 14 December 2008 (UTC)

I've gone through and fixed about 20 of them. Kingturtle (talk) 07:30, 14 December 2008 (UTC)
 * From what I saw, we got all of them that needed doing. Nice job kingturtle--Jac16888 (talk) 07:38, 14 December 2008 (UTC)

Page updated again. I think the issue before was not running it logged in which limited how much data it could pull from the API. --MZMcBride (talk) 07:47, 28 December 2008 (UTC)

run please
Can you run this one again please, there should be a pretty large proportion cleared, i've checked them all except for the l's so far. Cheers-- Jac 16888 Talk 23:18, 15 February 2009 (UTC)
 * There were two typos in the code causing it to fail when it ran on February 9. Both have been fixed and I started it manually. It's currently checked about 1 million pages. Another 1.5 million or so left to check. Cheers. --MZMcBride (talk) 03:18, 16 February 2009 (UTC)
 * great, cheers-- Jac 16888 Talk 03:28, 16 February 2009 (UTC)

And again if that's ok, hopefully this time it was done quick enough to actually make a difference in the numbers-- Jac 16888 Talk 02:12, 22 February 2009 (UTC)
 * Run and done. :-) --MZMcBride (talk) 22:02, 22 February 2009 (UTC)
 * thanks. now thats the kind of improvement i like to see, a drop by 10,000 kb, as opposed to an increase-- Jac 16888 Talk 13:59, 23 February 2009 (UTC)
 * Hi MZMcBride, could you run the list again? PhilKnight (talk) 20:18, 23 February 2009 (UTC)
 * done and cleared of those that need clearing. Finally-- Jac 16888 Talk 02:33, 25 February 2009 (UTC)

False positives
There are quite a few false positives from speedy deletion tags and similar things in this report. Pretty much unavoidable unfortunately. Though it may make sense to re-evaluate including the links in the templates. --MZMcBride (talk) 07:17, 3 April 2009 (UTC)


 * Perhaps, to start with, filter out any pages that contain Under construction. --R'n'B (call me Russ) 18:51, 22 September 2009 (UTC)
 * And db-meta - this should catch all speedy deletion templates. עוד מישהו Od Mishehu 07:16, 23 September 2009 (UTC)
 * Done. Running now. --MZMcBride (talk) 07:34, 23 September 2009 (UTC)

Standard wikilinks
I think that this database report would be greatly improved if it used standard wikilinks (like are used in Database reports/Potential biographies of dead people (2), in stead of "external links". This is because pages in this list are frequently speedy deletable (even though not yet tagged as such), and the use of wikilinks makes it clearly visible which pages still exist. עוד מישהו Od Mishehu 07:00, 10 February 2010 (UTC)

Taxobot causing false positives
Many (two picked at random from the ones that are obviously species names) of these articles contain User:Taxobot/children/template, and no other userspace links. Can this be remedied? DS (talk) 18:27, 28 December 2010 (UTC)
 * Is that what causes it? I have a list that reprocesses this one to very direct links: User:TedderBot/Database reports/Articles containing links to the user space version 2. It's very derivative and dependent on this version, and simply looks for links with "User:" (or similar) in them. tedder (talk) 01:57, 29 December 2010 (UTC)
 * Should be fixed in the next update. --MZMcBride (talk) 20:15, 29 December 2010 (UTC)

Recommendation to mark acceptable uses of article-to-userspace wikilinks
Several types of templates including those used to identify bio-article subjects as Wikipedians and those used to flag pages as "newly created" intentionally link to user-space. Perhaps the bot can flag articles whose only user-space links are in these templates so those of us reviewing the list can focus on the rest. davidwr/ (talk)/(contribs)  21:38, 3 July 2015 (UTC)

Exclude Prod
Hi, would it be possible for this report to exclude any page that has a prod template, since that template now has a userlink on it?-- Jac 16888 Talk 16:02, 20 November 2020 (UTC)
 * A technical solution, can be implemented for other templates:
 * Create a blank template to use for exclusion.
 * Have the bot generating the list leave out any pages which transclude this template.
 * Transclude the template in the basic PROD and CSD templates.
 * Use the edit filter to disallow direct use outside the template namespace.
 * 147.161.9.41 (talk) 10:28, 4 January 2021 (UTC)