SQL error in language

[omarreis]

Hello

I'm using phpbb 3.0.7-PL1 on Windows 2003 server.
I tried to install a second language.
But when I go to the ACP, select "System" tab and click "language packs",
I get the error below.

I tried to repair user table (as suggested in some posts)
but MySQL says the database engine does not support repairs.
Phpbb works, but I cannot install the new language.
What can I do ?

Thanks
Omar

SQL ERROR [ mysql4 ]
Duplicate entry 'en' for key 1 [1062]
SQL
SELECT user_lang, COUNT(user_lang) AS lang_count FROM users GROUP BY user_lang
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_language.php
LINE: 1081
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_language->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

[[email protected]]

i have the exact same error. and have tried several fixes inc php database updates and still no luck

[D¡cky]

InnoDB tables do not support REPAIR TABLE. You can do OPTIMIZE TABLE instead. You will get the "Table does not support optimize, doing recreate + analyze instead" which is basically the same as repairing the table. Another method to repair the table is to dump the table and restore it.

[marcoblbr]

i have the exact same error. and have tried several fixes inc php database updates and still no luck

Me too!! Still trying to figure it out, although I could see a new language running by loggin in with a new user!!

[D¡cky]

Me too!! Still trying to figure it out, although I could see a new language running by loggin in with a new user!!

Installing a new language does not change any user's language settings. If you go to your User Control Panel -> Board Preferences, do you see the new language in the language dropdown and are you able to change to that language?