Re: Error when upgrading 1.2 db to 1.3 db

[Chris Travers <..hidden..>]

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)?


Best Wishes,
Chris Travers