Page MenuHomePhabricator

Both 'no' and 'nb' are stored in translation_target_language in the cx shared database
Open, NormalPublic

Description

Both 'no' and 'nb' are stored in translation_target_language in the cx shared database.

It confuses the statistics. It must be normalized to a single code.

Event Timeline

Amire80 created this task.Dec 28 2015, 9:08 AM
Amire80 raised the priority of this task from to Normal.
Amire80 updated the task description. (Show Details)
Amire80 added subscribers: Nemo_bis, santhosh, jeblad and 4 others.

It's easy to do replace in SQL, but what are the dates for newest entries, i.e. do we need to fix that issue first?

They keep appearing:

mysql:wikiadmin@db1029 [wikishared]> SELECT
    -> translation_target_language,
    -> COUNT(*)
    -> FROM
    -> cx_translations
    -> WHERE
    -> (translation_status = 'published' OR translation_target_url IS NOT NULL) AND
    -> translation_last_updated_timestamp LIKE '201511%' AND
    -> translation_target_language in ('no', 'nb')
    -> GROUP BY
    -> translation_target_language;
+-----------------------------+----------+
| translation_target_language | COUNT(*) |
+-----------------------------+----------+
| nb                          |      110 |
| no                          |       18 |
+-----------------------------+----------+
2 rows in set (0.10 sec)

So yes, the underlying issue must be fixed - we must only store 'nb'.

Nemo_bis removed a subscriber: Nemo_bis.Jan 18 2016, 2:29 PM
Amire80 set Security to None.
Amire80 moved this task from CX8 to Bugs on the ContentTranslation board.Apr 20 2016, 1:07 PM

Old codes are no longer appearing in the database. Now we could see if we can map the codes and whether there are conflicts.