Jump to content

How to remove obsolete language strings?


Recommended Posts

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 by Sonya*
Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...