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.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T102107 Enable Content Translation in Catalan Wikipedia for all logged-in users | |||
| Open | None | T116533 ContentTranslation issues that affect people who aren't editors or translators (tracking) | |||
| Open | None | T126916 ContentTranslation gray interlanguage links issues (tracking) | |||
| Declined | None | T105577 use geolocation to show the gray interlanguage link in ContentTranslation | |||
| Invalid | None | T105578 Incorrect language code handling in ContentTranslation (tracking) | |||
| Open | None | T122497 Both 'no' and 'nb' are stored in translation_target_language in the cx shared database |
Event Timeline
Comment Actions
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?
Comment Actions
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'.
Comment Actions
Old codes are no longer appearing in the database. Now we could see if we can map the codes and whether there are conflicts.
Comment Actions
wikiadmin2023@10.64.16.208(wikishared)> SELECT
-> translation_last_updated_timestamp
-> FROM
-> cx_translations
-> WHERE
-> translation_target_language = 'no';
+------------------------------------+
| translation_last_updated_timestamp |
+------------------------------------+
| 20150405180527 |
| 20170413192949 |
| 20170413192959 |
| 20150120192610 |
| 20150119182956 |
| 20150119184307 |
| 20150119205636 |
| 20150119200608 |
| 20150119214144 |
| 20170413115354 |
| 20150120122112 |
| 20151011091825 |
| 20150824090018 |
| 20150122184025 |
| 20160920053215 |
| 20150308193346 |
| 20150319163658 |
| 20150804152623 |
| 20150404103821 |
| 20150406125739 |
| 20150411120642 |
| 20150415224436 |
| 20150419203329 |
| 20150419232646 |
| 20150421113950 |
| 20150505072132 |
| 20150507091148 |
| 20150518002132 |
| 20150523090003 |
| 20150702091027 |
| 20150702124838 |
| 20150805081521 |
| 20150806131907 |
| 20150806143545 |
| 20150810235004 |
| 20150810235902 |
| 20150811105840 |
| 20150811164017 |
| 20150825143618 |
| 20150901090058 |
| 20150925201201 |
| 20151013152929 |
| 20151023110436 |
| 20151024221217 |
| 20151104174256 |
| 20151104175524 |
| 20151104183236 |
| 20151104183733 |
| 20151104184004 |
| 20151104184318 |
| 20151104184556 |
| 20151105135518 |
| 20151105140135 |
| 20151105141445 |
| 20151105152108 |
| 20151105162025 |
| 20151105184405 |
| 20151105184745 |
| 20151105185218 |
| 20151105185630 |
| 20151105185955 |
| 20151105190233 |
| 20151105190620 |
| 20151115205031 |
| 20151117131102 |
| 20151205221814 |
| 20151213230324 |
| 20160104065940 |
| 20160129151922 |
| 20160206154118 |
| 20160210225716 |
| 20160212170445 |
| 20160222150359 |
| 20160303093824 |
| 20160306153225 |
| 20160308143507 |
| 20160308153050 |
| 20160308163910 |
| 20160308164304 |
| 20160308164841 |
| 20160308222314 |
| 20160308222640 |
| 20160308223025 |
| 20160308223307 |
| 20160309212105 |
| 20160313134724 |
| 20160313135150 |
| 20160404163031 |
| 20160409070836 |
| 20160415220623 |
| 20160420091949 |
| 20160428092059 |
| 20160506010352 |
| 20160507184143 |
| 20160509073930 |
| 20160509075034 |
| 20160510131932 |
| 20160510140125 |
| 20160510142339 |
| 20160525161429 |
| 20170303093209 |
| 20180607220807 |
| 20190322133725 |
| 20190331125357 |
| 20230329190402 |
| 20230410073005 |
| 20230429035255 |
| 20230502093641 |
| 20230507101624 |
| 20230605131054 |
| 20230611174819 |
| 20230611174940 |
| 20230611175339 |
| 20230611175410 |
| 20230611180437 |
| 20230614055424 |
| 20230614060221 |
| 20230614072001 |
| 20230614093422 |
| 20230711170704 |
| 20230711215148 |
| 20230714080631 |
| 20230830101346 |
| 20230831062232 |
| 20230831175750 |
| 20230907072440 |
| 20230910000126 |
| 20230923162935 |
| 20231023110856 |
| 20231025155406 |
| 20231102191858 |
| 20231116071932 |
| 20250328162007 |
| 20250329152607 |
| 20250329153412 |
| 20250329155145 |
| 20250329162608 |
| 20250329164652 |
+------------------------------------+
138 rows in set (0.981 sec)