Wikipedia talk:Dead-end pages/Archive 1

Wikipedia talk:!Dead-end pages is the raw HTML source for the lower part of Special:Deadendpages when the function is disabled. -- User:Docu

---

In the current version of "SpecialDeadendpages.php" redirects aren't excluded:

    function getSQL( $offset, $limit ) {
	return "SELECT cur_title " . 
	  "FROM cur LEFT JOIN links ON cur_title = l_from " .
	  "WHERE l_from IS NULL " .
	  "AND cur_namespace = 0 " .
	  "ORDER BY cur_title " . 
	  "LIMIT {$offset}, {$limit}";

Adding "AND cur_is_redirect = 0" should filter them. -- User:Docu

That shouldn't be necessary as redirects contain a link, therefore they are not dead-end pages. The only reason those dates were showing up in the list yesterday was because the redirects were broken (they didn't include the final bracket). Now these have been fixed, they are not showing up. Angela. 10:13, Mar 6, 2004 (UTC)

Why are Aerospatiale Gazelle and Amaliáda showing up? -- User:Docu

In fact, it appears to be a problem with the links table. It might be fixed once that table is updated. -- User:Docu

I assume it must be as both of those contain a link, so they shouldn't be listed. Angela. 10:51, Mar 6, 2004 (UTC)

I ran "SELECT * FROM links WHERE l_from = 'Aerospatiale_Gazelle' LIMIT 10" and it didn't return anything. -- User:Docu

---

BTW should we place the results on Wikipedia:Deadend pages so they can be easily edited? -- User:Docu

Yeah, I was just about to. :) Angela.

I updated it. Is there any easy way to transfer the listings to Wikipedia:Deadend pages? --Jiang 08:13, 9 Mar 2004 (UTC)

Could this please be updated? Most entries have been resolved by now (and the rest will be by the time someone reads this ;) ) Radiant! 18:13, Feb 14, 2005 (UTC)

---

Can someone update Wikipedia:Deadend pages? It's linked on mediawiki:opentask and all entries have all been resolved. --Jiang 19:43, 3 Mar 2004 (UTC)

All done except for Ammunition for infantry and Angelwings and Finerthings. I did my best but there's only so much time :-( Help would be much appreciated. --Phil 10:52, Mar 4, 2004 (UTC)

I have now added some sort of annotation to these last remaining entries. When this page is re-created, do the comments get carried through, or do we have to go through the whole things again? --Phil 10:57, Mar 4, 2004 (UTC)

If they've been fixed, theyre no longer "dead end" so they would no longer be listed. --Jiang 19:00, 4 Mar 2004 (UTC)

Someone should run the script for Special:Deadendpages. I don't know how to do it. --Jiang 19:00, 4 Mar 2004 (UTC)

I updated it, but it's fairly useless as it's just showing a load of misformed date redirects. It will only display 50 at a time, so until those are deleted or fixed, the list doesn't contain any actual articles. Angela. 17:17, Mar 5, 2004 (UTC)

What script is used to generate the list? It should be done again. --Jiang 02:45, 6 Mar 2004 (UTC)

Brion says the script is not to be overused or it will be taken away and Eloquence said the script should not be made public. Angela. 10:19, Mar 6, 2004 (UTC)

I've recreated the list from a local copy of the last database dump. Lots of stubs in there, but also many true dead-ends. Happy to try and produce a more precise list if anyone has better criteria than "a page in the main en namespace with no internal links". - TB 11:09, 14 May 2004 (UTC)

Great, I was just about to do the same!

I suppose in any stub there are a couple of words that can be wikified. If you want to expand the definition, maybe "any page in article namespace without at least two links to other pages in article namespace" could expand the list. -- User:Docu

---

See Wikipedia talk:!Dead-end pages about the redirects in the results. -- User:Docu

Relationship to "This_page_contains_no_links"?

Four weeks ago I posted a query on Wikipedia_talk:Offline_reports/This_page_contains_no_links suggesting that it has a lot in common with "Deadend pages". No response. What is the difference and what, if any, are the functional relationships users might like to know about? Robin Patterson 05:45, 12 Aug 2004 (UTC)

The "Offline Reports" are generated periodically from database dumps. Special:Deadendpages is generated (normally) on demand from the live database. Wikipedia:Deadend pages is generated periodcally by copying information from either of the first two pages, or by following the instructions in Wikipedia:Deadend_pages/How_to_update, and may omit pages with no links that are otherwise wikified (perhaps with '''bolding''' for example), depending on how it has been updated and by whom.

Lots of redundancy? You're right. I can only speak as to motivation for generating Wikipedia_talk:Offline_reports/This_page_contains_no_links, but:

• Special:Deadendpages is taken offline if the database server load gets too high.
• The live database sometimes has problems with the 'links' table needed to determine the articles which have wikilinks to and from them. A new version of the links table is regenerated from scratch during the generation of the offline reports.
• "This page contains no links" in an articles "what links here" page is more informative (IMHO) than "Deadend pages"

Happy to discuss. - TB 10:14, Aug 12, 2004 (UTC)

I have merged that page here. -- Beland 00:57, 24 July 2005 (UTC)

Problem fixed

Partial self-duplication of Wikipedia:Deadend pages occurred Dec 15, 2004. Now cured (hopefully). --FvdP 21:02, 16 Dec 2004 (UTC)

html comments

We've been putting HTML comments about VFD in the list. Other than the fact that the comments would need to be removed if it survived VFD does anyone object to in the future making the comments visible rather than hidnign them in HTML comments?

I think I may have been the one who started that. Regardless, having them visible seems like a good plan. --TheParanoidOne 05:34, 12 July 2005 (UTC)

All the aforementioned comments seem to have been made visible by now. -- Beland 01:04, 24 July 2005 (UTC)