Tagalog and Tajik language codes are mixed up

[szc126]

Website (required)

VocaDB

Describe the bug (required)

tg is Tagalog/Filipino in the short languages list and Tajik in the full languages list. (It should be tl Tagalog/Filipino and tg Tajik.)

To Reproduce (optional)

Steps to reproduce the behavior:

1. Open the edit window of https://vocadb.net/S/161777
2. Navigate to the Lyrics tab; open Original
3. Click on More language options; Filipino will change to Tajik

Expected behavior (optional)

The language codes are used correctly and consistently.

Screenshots (optional)

Desktop (optional)

Smartphone (optional)

Additional context (optional)

Encountered while running the script to migrate from language tags to the new entry/lyrics language system.

Checklist (required)

Fill out the checklist. Use strikethroughs or leave fields empty if you don't know or are unable to check/test.

• [x] Searched VocaDB/vocadb for duplicate issues.
• [ ] Tested on the beta site.
• [ ] Tested on different browsers (e.g. Firefox, Chrome, Safari, Edge).
• [ ] Checked in private mode.
• [ ] Cleared browser cache and cookies.
• [ ] Checked the DevTools console.
• [ ] Checked the syslog (mods+ only).

[Susko3]

Official list of IETF language tags from https://www.iana.org/assignments/language-subtag-registry/language-subtag-registry:

%%
Type: language
Subtag: tg
Description: Tajik
Added: 2005-10-16
%%
// ...
%%
Type: language
Subtag: tl
Description: Tagalog
Added: 2005-10-16
Suppress-Script: Latn
%%
// ...
%%
Type: language
Subtag: fil
Description: Filipino
Description: Pilipino
Added: 2005-10-16
%%

---

There are also some other issues with the way language names are displayed. The names of languages don't match across UI elements (all of these elements first show tg, then tl):

Lyrics page languages Filipino, Wikang Tagalog https://beta.vocadb.net/S/472573/lyrics?lyricsId=123231

Limited language picker Filipino (Filipino), Other/Unknown

Full language picker Тоҷикӣ (Tajik), Wikang Tagalog (Filipino)

Artist page Filipino, Filipino https://beta.vocadb.net/Ar/104460