Where did this come from

[malmazan]

I use other languages.

Sometimes the master phrase is in another language, though i have never changed.

I have imported several languages from this site. Could these have brought in those changes to the master language ?

Can i reset the master language ?

[Colin F]

Sometimes languages enter phrases into the languageid 0, which is valued higher than languageid 0.

Try this. Run this query:

So for MySQL 4.0.x use this query:

DELETE
FROM phrase
USING phrase AS p1
LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
AND p2.languageid = -1 )
WHERE p1.languageid =0
AND p2.languageid IS NOT NULL;

And for 4.1.x and higher, use this query:

DELETE
FROM phrase AS p1
USING phrase AS p1
LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
AND p2.languageid = -1 )
WHERE p1.languageid =0
AND p2.languageid IS NOT NULL;

Then run this now:

AdminCP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]

[malmazan]

Thanks.

The Run My SQL query on the vB Admin Panel did not let me run the query.

I am faily new to this sort of thing. (I think) i managed to run a query from PHPMyAdmin and got
Deleted rows: 476 (Query took 0.1936 sec)

[malmazan]

Well i am still seeing master language phrases in other languages