Anonymous - 2012-09-21

Following sql can be used to find incorrect translations:
SELECT * FROM vocabulary n1, vocabulary n2 WHERE n1.`value` = n2.`value` AND n1.`langid` = 7 AND n2.`langid` = 11

The following sql can be used to delete the incorrect values:
DELETE n1 FROM vocabulary n1, vocabulary n2 WHERE n1.`value` = n2.`value` AND n1.`langid` = 7 AND n2.`langid` = 11

Note that this can take a few minuts to process and doesn't solve the issue of them getting imported in the first place, or the future.

 

Last edit: Anonymous 2013-11-20