Page MenuHomePhabricator

ContentTranslation table details do not match the actual status in some cases
Open, Needs TriagePublic

Description

From the API query, I got a list of translations on Telugu Wikipedia. I found the details to be incorrect in some cases.

Example 1: Published article does not exist Link. As per the below information, the article does not exist.

{
    "translationId": "993034",
    "sourceTitle": "Typhoon Noru (2017)",
    "targetTitle": "టైఫూన్  నొరు (2017)",
    "sourceLanguage": "en",
    "sourceRevisionId": "970472642",
    "targetRevisionId": "3004130",
    "targetLanguage": "te",
    "sourceURL": "//en.wikipedia.org/wiki/Typhoon Noru (2017)",
    "targetURL": "//te.wikipedia.org/wiki/తుఫాన్ నొరు (2017)",
    "publishedDate": "20200802061615",
    "stats": {
        "any": 0.29411764705882354,
        "mt": 0.5555555555555556,
        "human": 0.4444444444444444
    }
},

Example 2: Published date is wrong. Actual published date is 2020-01-17 as per the link, but the published date is being shown as 2020-08-08

{
    "translationId": "824953",
    "sourceTitle": "Wikimedia Commons",
    "targetTitle": "వికీమీడియా కామన్స్",
    "sourceLanguage": "en",
    "sourceRevisionId": "968343727",
    "targetRevisionId": "2828198",
    "targetLanguage": "te",
    "sourceURL": "//en.wikipedia.org/wiki/Wikimedia Commons",
    "targetURL": "//te.wikipedia.org/wiki/వికీమీడియా కామన్స్",
    "publishedDate": "20200808121314",
    "stats": {
        "any": 0.9024390243902439,
        "mt": 0.9101796407185628,
        "human": 0.08982035928143717
    }
},

Example 3: Translation statistics do not make sense. In the following mt is 1, human is 0 and any is 0.16. With mt as 1, the translation would not have been published as the limit is set at 70%

{
    "translationId": "958678",
    "sourceTitle": "Ivanka Trump",
    "targetTitle": "ఇవాంకా ట్రంప్",
    "sourceLanguage": "en",
    "sourceRevisionId": "961583188",
    "targetRevisionId": "2965802",
    "targetLanguage": "te",
    "sourceURL": "//en.wikipedia.org/wiki/Ivanka Trump",
    "targetURL": "//te.wikipedia.org/wiki/ఇవాంకా ట్రంప్",
    "publishedDate": "20200619143129",
    "stats": {
        "any": 0.16129032258064516,
        "mt": 1,
        "human": 0
    }
},

Event Timeline

If I open my past translation in translation dashboard, the published date seems to be updating, even if I do not republish, as I got the published date as 2020-08-12 when I fetched the details today after experimentally opening my past translation from the dashboard