Wikipedia talk:Dead-end pages/1

From Wikipedia, the free encyclopedia

SpecialPage	Other versions
Short pages	User:Zorglbot/Shortpages
DoubleRedirects	Double redirects
Uncategorized	Category needed
Uncategorized cats	Orphaned cats
Long pages	Long pages
Wanted pages	Most wanted
Lonely pages	Orphaned articles
Dead-end pages	Dead-end pages
Dormant pages	n/a
New pages	n/a
Cross-namespace links
Broken redirects	+/-
See also Maintenance Reports

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)