Can't install official Mandarin language pack

[monkeybb]

Dear all,

I'm getting a similar error. I downloaded the official mandarin language package, upload it and I'm trying to install it. Every time I click the install button I get the following error:

Code: Select all

SQL ERROR [ mysql4 ]

Incorrect string value: '\xE7\xAE\x80\xE4\xBD\x93...' for column 'lang_local_name' at row 1 [1366]

SQL

INSERT INTO phpbb_lang (lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES ('zh_cmn_hans', 'zh_cmn_hans', 'Mandarin Chinese (Simplified script)', '简体中文', 'phpBB China Group')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_language.php
LINE: 851
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()

What am I doing wrong?

[D¡cky]

You evidently didn't use the Download Package form here at phpbb.com. Fantastico, and possibly other one-click installs, create a non-standard database which causes problems such as yours.

To fix, follow the instructions from [kb=doesnt-have-a-default-value-errors] ... rrors[/kb].

[monkeybb]

Exactly, I used Fantastico Deluxe in order to install the phpbb forum. I had PHP 4 when I installed it. I've already upgraded to PHP 5.2. I have phpbb 5.0.8. I'll try to upgrade to 5.0.9 and see if I can get it fixed.

Thank you.