1311063 - Translations exist without English "parents", correlated with slug issues

Status: RESOLVED WONTFIX

(developer.mozilla.org Graveyard :: Wiki pages, defect, P3)

Description

[John Whitlock [:jwhitlock]]

What did you do?
================
This Spanish page has no English parent:

https://developer.mozilla.org/es/docs/IndexedDB

It appears to be a translation of this document, but has no link:

https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API

But the Spanish translation is:

https://developer.mozilla.org/es/docs/IndexedDB-840092-dup

What happened?
==============
I would expect this content at:

https://developer.mozilla.org/es/docs/Web/API/IndexedDB_API



What should have happened?
==========================
That "expected" URL redirects to the actual translation at:

https://developer.mozilla.org/es/docs/IndexedDB-840092-dup

This suggests a history of compromises around a page move.

Is there anything else we should know?
======================================
There are about 2000 non-English pages with no English parents found by Jeremie with the SQL:

SELECT
  id,
  parent_id,
  locale,
  slug

FROM
  wiki_document
  
WHERE
  locale <> 'en-US' AND
  isnull(parent_id) AND
  is_template <> 1 AND
  is_redirect <> 1 AND
  deleted <> 1;

Comment 1

[John Whitlock [:jwhitlock]]

Attachment: unlink-l10n-docs.csv

Results from executing the SQL

Comment 2

[John Whitlock [:jwhitlock]]

A live list of translations without parents can be requested for each locale:

https://developer.mozilla.org/es/docs/without-parent

Comment 3

[Kadir Topal [:atopal]]

If there are web platform articles that affect a significant amount of people, we should fix those specific articles

Comment 4

[Kadir Topal [:atopal]]

There are 320 web platform docs affected by this. Not sure about the traffic they are getting though.

Comment 5

[Kadir Topal [:atopal]]

List of items probably worth re-attaching (195):

SELECT
  id,
  parent_id,
  locale,
  slug

FROM
  wiki_document
  
WHERE
  locale <> 'en-US' AND
  isnull(parent_id) AND
  is_template <> 1 AND
  is_redirect <> 1 AND
  deleted <> 1 AND
  slug NOT LIKE "%Obsolete%" AND
  slug LIKE "Web%"


It's almost all Spanish and Japanese, and it needs to be manually checked by the communities. Might be a good task for a locale sprint.

Comment 6

[BMO Automation]

MDN Web Docs' bug reporting has now moved to GitHub. From now on, please file content bugs at https://github.com/mdn/sprints/issues/ and platform bugs at https://github.com/mdn/kuma/issues/.