How to remove obsolete language strings?

[MMXII]

Over the years (since version 4.0) so many language strings have become obsolete. However they still show up in the translation tools. How can these be removed?

Just an example:

[Sonya*]

I run a SQL query that picks language strings from non-English packs:

select * from (SELECT lang_id, word_key, word_default, COUNT(word_key) FROM `core_sys_lang_words` GROUP BY word_key HAVING (COUNT(word_key) = 1) ) garbage where lang_id = 2

The query assumes you have two languages installed and the second language has an ID=2. Otherwise you have to adjust it. The output will contain the language strings that only exist in the language with ID=2. You can run DELETE query on the selection above or delete them manually through language center in AdminCP.

Edited September 25, 2020 by Sonya*

[MMXII]

Thank you very much. That seemed to work on my test installation.

I wonder though why IPS is not offering such functionality in the AdminCP? 🤔 Some button to remove orphaned language strings, or even better: Just remove them within the update process.