While translating my website i discovered that some of my entries in the locale-table (db)are duplicated.. Maybe it's a good idea to check first if the string already exists in the db and if it's not there, then insert it...

Teh locale improvements in Marco's sandbox are much promising, but as far as my little PHP-knowledge goes this isn't implemented in his patches too..

Comments

dries’s picture

dries commented

Can you try the following two queries:

select count(distinct(string)) from locales;
select count(string) from locales;

What results do these yield?

Stefan Nagtegaal’s picture

Stefan Nagtegaal commented

There's nothing happening on my db when I do that... It only says 'Query finished succesfully'... Should I do anything more than you wrote here?

dries’s picture

dries commented

Yes, each query should "return" a number. For example:

mysql > select count(string) from locales;
+---------------+
| count(string) |
+---------------+
|          1000 |
+---------------+
1 row in set (0.00 sec)
claybutterfly’s picture

claybutterfly commented

It isn't working Dries.. I do not get any numbers..

Maybe it's because I use MySQLAdmin?

killes@www.drop.org’s picture

killes@www.drop.org commented

The new locale module does the suggested checking.

Anonymous’s picture

(not verified) commented