Re: Debian Squeeze - 1.3.1 - en_GB error

[Chris Travers <..hidden..>]

On Thu, Oct 20, 2011 at 9:48 AM, Laurence Southon <..hidden..> wrote:
> Hi all,
>
> Managed to getting running on Debian Squeeze, but I get an error when
> trying to set language to en_GB in user prefs:
>
> Error!
>
> 23503:ERROR: insert or update on table "user_preference" violates
> foreign key constraint "user_preference_language_fkey"
> DETAIL: Key (language)=(en_GB) is not present in table "language".
> CONTEXT: SQL statement "UPDATE user_preference SET dateformat = $1 ,
> numberformat = $2 , language = $3 , stylesheet = $4 , printer = $5 WHERE
> id = (select id from users where username = SESSION_USER)" PL/pgSQL
> function "user__save_preferences" line 2 at SQL statement
>
> The database was created with Country Code UK.
>
> Does en_GB need to be enabled somewhere?
>
Ok, this was apparently omitted in the language table.

Go ahead and add it under System/Language/Add Language.

I will fix this in the db creation/upgrade scripts so this won't be
necessary for users who start using 1.3 on 1.3.2 and higher.

Best Wishes,
Chris Travers