[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Debian Squeeze - 1.3.1 - en_GB error
- Subject: Re: Debian Squeeze - 1.3.1 - en_GB error
- From: Chris Travers <..hidden..>
- Date: Thu, 20 Oct 2011 15:19:39 -0700
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:
> 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.