SQL error in language

Having a question about translating phpBB3? Want to discuss and collaborate with people currently translating phpBB3? Here would be the correct place to do so.
Scam Warning
omarreis
Registered User
Posts: 1
Joined: Fri Nov 12, 2010 1:31 pm

SQL error in language

Post by 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]
Registered User
Posts: 5
Joined: Mon Jan 31, 2011 8:41 am

Re: SQL error in language

Post by [email protected] »

i have the exact same error. and have tried several fixes inc php database updates and still no luck
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: SQL error in language

Post by 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.
Have you hugged someone today?
marcoblbr
Registered User
Posts: 17
Joined: Tue May 24, 2011 11:37 am

Re: SQL error in language

Post by marcoblbr »

[email protected] wrote: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!!
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: SQL error in language

Post by D¡cky »

marcoblbr wrote: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?
Have you hugged someone today?

Return to “[3.0.x] Translations”