What's the link to the exact pack that caused this? (There are several French language packs.) I think it's time to remove this until the author fixes these problems.
To fix this try running one of these queries:
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;
Or for MySQL 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:
AdminCP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]
To fix this try running one of these queries:
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;
Or for MySQL 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:
AdminCP -> Languages & Phrases -> Language Manager -> [Rebuild All Languages]
Comment