445562 - en (or some other locale) articles missing from some translation tables

Status: RESOLVED WORKSFORME

(support.mozilla.org :: Localization, task)

Description

[Chris Ilias [:cilias]]

Probably a continuation of bug 428998.
1. Go to <http://support.mozilla.com/en-US/kb/Windows+Media+Player>.
2. At the bottom right, use the language selector to switch to Italian. You should be taken to <http://support.mozilla.com/it/kb/Il%20plugin%20Windows%20Media%20Player>.
3. In the Actions box, click "Traduci questa pagina". You should be taken to <http://support.mozilla.com/tiki-edit_translation.php?locale=it&page=Il+plugin+Windows+Media+Player>.

Result: The English article does not appear in the list of translations.

Comment 1

[Nelson Ko [:nkoth]]

It appears always to be n-1 articles in the translation table, rather than the full n number of translations.

Comment 2

[Nelson Ko [:nkoth]]

Another example:

This article: 
http://support.mozilla.com/fr/kb/Modules+incompatibles+avec+Firefox+3

Is a translation of: 
http://support.mozilla.com/en-US/kb/Add-ons+are+incompatible+with+Firefox+3

But they are not connected, and it's not possible to connect them from 
any of the two articles.

Comment 3

[Paul Craciunoiu [:paulc]]

The fact that they're not connected may have happened long ago. What stops one from creating their own article instead of translating an existing one?

Is there a current way to "connect" translations? If not, maybe we should make that into a bug for 1.0.

I'll look into the n-1 (one always missing) issue.

Comment 4

[David Tenser [:djst]]

(In reply to comment #3)
> I'll look into the n-1 (one always missing) issue.

Any updates, Paul?

Comment 5

[Paul Craciunoiu [:paulc]]

Sorry, no. No time...

Comment 6

[Chris Ilias [:cilias]]

I don't know if you want each case listed. But here's another:
<https://support.mozilla.com/tiki-edit_translation.php?page=ActiveX+%28Polski%2C+pl%29>
The English article is listed as nl, and as a result the nl team cannot create a translation of that page.

Comment 7

[Paul Craciunoiu [:paulc]]

Tips on reproducing it, such as the history of how it got to be like that would be helpful... I'll play around with it this week and see if I can reproduce it. Those pages should be temporarily fixable by changing their language (edit page for admins allows that). So maybe try to edit the English article and change its language?

Comment 8

[Paul Craciunoiu [:paulc]]

(In reply to comment #2)
> Another example:
> 
> This article: 
> http://support.mozilla.com/fr/kb/Modules+incompatibles+avec+Firefox+3
> 
> Is a translation of: 
> http://support.mozilla.com/en-US/kb/Add-ons+are+incompatible+with+Firefox+3
> 
> But they are not connected, and it's not possible to connect them from 
> any of the two articles.
The equivalent translation from the English version seems to be:
http://support.mozilla.com/en-US/kb/Des+modules+sont+incompatibles+avec+Firefox+3?bl=n
not the one you provided.

Comment 9

[Paul Craciunoiu [:paulc]]

(In reply to comment #0)
> Probably a continuation of bug 428998.
> 1. Go to <http://support.mozilla.com/en-US/kb/Windows+Media+Player>.
> 2. At the bottom right, use the language selector to switch to Italian. You
> should be taken to
> <http://support.mozilla.com/it/kb/Il%20plugin%20Windows%20Media%20Player>.
> 3. In the Actions box, click "Traduci questa pagina". You should be taken to
> <http://support.mozilla.com/tiki-edit_translation.php?locale=it&page=Il+plugin+Windows+Media+Player>.
> 
> Result: The English article does not appear in the list of translations.

I can't see this anymore. On:
http://support.mozilla.com/tiki-edit_translation.php?locale=it&page=Il+plugin+Windows+Media+Player
I see the English translation listed under "Ingles".

Comment 10

[Paul Craciunoiu [:paulc]]

(In reply to comment #6)
> I don't know if you want each case listed. But here's another:
> <https://support.mozilla.com/tiki-edit_translation.php?page=ActiveX+%28Polski%2C+pl%29>
> The English article is listed as nl, and as a result the nl team cannot create
> a translation of that page.
It seems that
https://support.mozilla.com/kb/ActiveX-nl?bl=n
is the translation for nl and English is listed correctly.

Comment 11

[Paul Craciunoiu [:paulc]]

WORKSFORME until I get some valid examples to test...

Comment 12

[Chris Ilias [:cilias]]

(In reply to comment #10)
> It seems that
> https://support.mozilla.com/kb/ActiveX-nl?bl=n
> is the translation for nl and English is listed correctly.

For that case, I worked with the locale leader (Tonnes) on working around this bug, and he found that removing the English article from the translation table allowed him to add the nl translation.

Sorry I don't have info on how to reproduce.

Comment 13

[Paul Craciunoiu [:paulc]]

Well, I'd need that, or I can't really see how to fix it..

Comment 14

[Underpass]

It seems that this error happens with that page:

https://support.mozilla.com/it/kb/Mozilla+Crash+Reporter?bl=n

I'm trying to translate it to Italian, and I always get warned that a page already exists for that language.

Comment 15

[Paul Craciunoiu [:paulc]]

Simone: yes, I see the problem now. However, my local environment doesn't seem to reproduce this problem for page you linked to. I may need a copy of the current DB on production to reproduce this.

Comment 16

[Underpass]

Paul: contacted Cww in #sumodev in the past days, he told me of errors in the db for that page.
Thanks.

Comment 17

[Underpass]

Paul: I would like to publish that page about Mozilla Crash Reporter.
Is there a way to fix those errors in the db?

Thanks in advance.

Comment 18

[Chris Ilias [:cilias]]

We recently did a db sync, when pushing newsearch. This bug can now be seen on stage:
<https://support-stage.mozilla.org/tiki-edit_translation.php?locale=it&page=Mozilla+Absturz-Melder>
"Mozilla Crash Reporter" is listed as "Italiano", even though it's English.

Simone, go ahead and fix the Mozilla Crash Reporter assignment on support.mozilla.com.

Some more freaky weirdness to this:
The English inproduct start page is listed as nl. I noticed it when the l10n dashboard told me that "Firefox Help" "Needs translation".
<https://support.mozilla.com/en-US/kb/Localization+Dashboard>
AFAIK, no new start pages were created or edit, but I'm not sure.

Comment 19

[Paul Craciunoiu [:paulc]]

So this seems to be an inconsistency between the actual article language and the language displayed in the translation table (or somewhere...). Since both of the articles you just linked, Chris, are actually in English.

What steps do you currently take to fix these problems (Simone?)? Maybe I can set the bug up locally and trace through.

(In reply to comment #16)
> Paul: contacted Cww in #sumodev in the past days, he told me of errors in the
> db for that page.
> Thanks.
Cheng, what db tables have the inconsistency? (I imagine a response like "article listed in <locale1> vs <locale2> in tables 1 and 2")

Comment 20

[Underpass]

(In reply to comment #18)
> Simone, go ahead and fix the Mozilla Crash Reporter assignment on
> support.mozilla.com.

Ok, had to detach the en-us one from the others, adding the Italian one, and finally adding the en-us one again.

It seems to be fixed.

Comment 21

[David Tenser [:djst]]

What's the status of this bug? Simone, did you explain a workaround in comment 20, or do you mean that this bug is actually fixed (or, not a bug)?

Comment 22

[Underpass]

Sorry David, I simply "detached" the en-us page from the rest, assigned it the correct language id and join the page again to the group.

The bug - I think - is not solved, but I did not find another page with that problem.

Comment 23

[Paul Craciunoiu [:paulc]]

Cheng has investigated translation tables this week, maybe he has some ideas for why this bug may occur.

Comment 24

[Paul Craciunoiu [:paulc]]

It's been about a month with nothing on this. I'm marking it WFM for now. Please reopen and comment in the bug when it happens, and try to be detailed.

Comment 25

[Paul Craciunoiu [:paulc]]

I found a potential source for this:
From bug 447903, fix:
http://viewvc.svn.mozilla.org/vc/projects/sumo/trunk/webroot/tiki-editpage.php?r1=16566&r2=17379
Likely if timeouts occur between certain lines then articles end up not being connected to their translations. To fix this, really, the best solution is to optimize tiki-editpage so it doesn't time out.