XF 2.0 Import / Create missing phrases

[S Thomas]

I have a translation which contains more phrases than the master data, for example trophy titles. Master data contains only title 1-9 whereas the translation contains way more. How can I add these additional phrases to master? They are probably missing because I imported the trophies table manually.

 

[S Thomas]

Solved it.

INSERT INTO xf_phrase (language_id, title, phrase_text)
SELECT 0 AS language_id, title, phrase_text FROM xf_phrase WHERE title IN
(SELECT title FROM xf_phrase GROUP BY title HAVING count(title) = 1)
AND language_id = X

Rebuild phrases afterwards.