[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Error when upgrading 1.2 db to 1.3 db
- Subject: Re: Error when upgrading 1.2 db to 1.3 db
- From: Chris Travers <..hidden..>
- Date: Tue, 10 Jan 2012 22:14:08 -0800
On Tue, Jan 10, 2012 at 2:56 PM, Nigel Titley <..hidden..> wrote:
> On 10/01/12 22:02, Erik Huelsmann wrote:
>> Hi Nigel,
>>> I'm about to add a header at the start, dump a new test copy of the
>>> database and try again.
>> That should do it. Please let us know about your outcome.
> OK, I'm now getting a little further on
> psql:1.2-1.3-upgrade.sql:38: ERROR: null value in column "country_id"
> violates not-null constraint
> Looking at the upgrade script this seems to be caused by my using
> "United Kingdom" rather than "UK" for the default country.
> Fixing this then takes us a lot further on to
> psql:1.2-1.3-upgrade.sql:157: ERROR: duplicate key value violates
> unique constraint "eca_to_contact_pkey"
> and here I get a bit bogged down in the SQL and it would help to have a
> pointer to look for.
You have a contact where you have a duplicate email address (email,
bcc, cc). Is there a legitimate use case where you would want to send
an email to someone and at the same time cc/bcc the same address (or
cc and bcc)?