[Pkg-sql-ledger-discussion] Bug#675816: ledgersmb: Unable to upgrade from 1.2 db to 1.3 db

[Robert James Clay]

(Forwarding to the bug.)
On Wed, 2012-06-06 at 10:47 -0400, Robert James Clay wrote:
> On Wed, 2012-06-06 at 10:01 -0400, Moshe Yudkowsky wrote:
> > 
> > I can convert the db and there are no errors; bu the db is not 
> > populated. I enclose /tmp/ledgersmb/dblog_stderr.
> 
>     You can get an idea of what the error is by starting at the end of
> that file and then going up until the first one before the "ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block" lines.  In this case, it is this one:  
> 
> psql:/tmp/ledgersmb/1.2-1.3-upgrade.sql:356: ERROR:  new row for
> relation "entity" violates check constraint "entity_name_check"
> 
>    Quoting one of the authors about it (in a message he posted to the
> LedgerSMB user list): "This probably happens if there is a customer or
> vendor which doesn't have a valid name (i.e., at least one alphanumeric
> character in the name)."