Re: First upgrade attempt from 1.2.21 -> 1.3.0RC4 == Fail

[..hidden..]

Well made it a little further:

INSERT INTO users (entity_id, username)
     SELECT entity_id, login FROM lsmb12.employee em;

psql:sql/upgrade/1.2-1.3-manual.sql:385: ERROR:  null value in column 
"username" violates not-null constraint

I figured out a fix for this one and tried again making it to



INSERT INTO invoice (id, trans_id, parts_id, description, qty, allocated,
            sellprice, fxsellprice, discount, assemblyitem, unit, project_id,
            deliverydate, serialnumber, notes)
    SELECT  id, trans_id, parts_id, description, qty, allocated,
            sellprice, fxsellprice, discount, assemblyitem, unit, project_id,
            deliverydate, serialnumber, notes
       FROM lsmb12.invoice;


psql:sql/upgrade/1.2-1.3-manual.sql:474: ERROR:  insert or update on table 
"invoice" violates foreign key constraint "invoice_trans_id_fkey"
DETAIL:  Key (trans_id)=(16796) is not present in table "transactions".

Which I can't quite figure out since it seems transactions is empty.

Louis



On Thu, 6 Oct 2011, Chris Travers wrote:

> Hmmmm.....  Ok, so we have found another failure case.
>
> Adding the following to the 1.2-pre-upgrade-check:
>
> SELECT * FROM employee WHERE employeenumber IN
>       (SELECT employeenumber FROM employee GROUP BY employeenumber
>        HAVING count(*) > 1);
>
> And to the automated checks in setup.pl......
>
> If you correct those issues, the setup should go more smoothly.
>
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel