MMXII Posted September 25, 2020 Share Posted September 25, 2020 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: Link to comment Share on other sites More sharing options...
Sonya* Posted September 25, 2020 Share Posted September 25, 2020 (edited) 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* Meddysong, Runar, MMXII and 1 other 2 2 Link to comment Share on other sites More sharing options...
MMXII Posted September 27, 2020 Author Share Posted September 27, 2020 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. Sonya* and Meddysong 2 Link to comment Share on other sites More sharing options...
Recommended Posts