[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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




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