~/INSTALL mistakes to be confirmed and changed:

[blck shp]

While working on setting up ledger 1.2.99 from trunk, I came across a
few mistakes in the INSTALL text file in ledgersmb root directory. :

Line 330 missing country_id:

$ psql -U postgres -d mycompany -t -c "INSERT INTO entity (name,
entity_class, created) VALUES ('myuser', 3, NOW()) RETURNING name,
entity_class, created;"

Should be:
$ psql -U postgres -d mycompany -t -c "INSERT INTO entity (name,
entity_class, created, country_id) VALUES ('myuser', 3, NOW())
RETURNING name, entity_class, created, country_id;"



Line 341 had extra country_id:

$ psql -U postgres -d mycompany -t -c "INSERT INTO person (entity_id,
first_name, last_name, created,country_id) VALUES (2, 'Firstname',
'Lastname', NOW(),'232') RETURNING entity_id, first_name, last_name,
created;"

Should be:
$ psql -U postgres -d mycompany -t -c "INSERT INTO person (entity_id,
first_name, last_name, created) VALUES (2, 'Firstname', 'Lastname',
NOW(),'232') RETURNING entity_id, first_name, last_name, created;"



Line 352 was returing person_id instead of manager_id.

$ psql -U postgres -d mycompany -t -c "INSERT INTO entity_employee
(manager_id, entity_id, startdate, role) VALUES (1, 2, NOW(),
'myuser') RETURNING person_id, entity_id, startdate, role;"

Should be:

$ psql -U postgres -d mycompany -t -c "INSERT INTO entity_employee
(manager_id, entity_id, startdate, role) VALUES (1, 2, NOW(),
'myuser') RETURNING manager_id, entity_id, startdate, role;"

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

Will get this committed shortly.

Best Wishes,
Chris Travers

On Mon, Oct 26, 2009 at 9:40 AM, blck shp <blckshp.sp@...> wrote:

While working on setting up ledger 1.2.99 from trunk, I came across a
few mistakes in the INSTALL text file in ledgersmb root directory. :

Line 330 missing country_id:

$ psql -U postgres -d mycompany -t -c "INSERT INTO entity (name,
entity_class, created) VALUES ('myuser', 3, NOW()) RETURNING name,
entity_class, created;"

Should be:
$ psql -U postgres -d mycompany -t -c "INSERT INTO entity (name,
entity_class, created, country_id) VALUES ('myuser', 3, NOW())
RETURNING name, entity_class, created, country_id;"



Line 341 had extra country_id:

$ psql -U postgres -d mycompany -t -c "INSERT INTO person (entity_id,
first_name, last_name, created,country_id) VALUES (2, 'Firstname',
'Lastname', NOW(),'232') RETURNING entity_id, first_name, last_name,
created;"

Should be:
$ psql -U postgres -d mycompany -t -c "INSERT INTO person (entity_id,
first_name, last_name, created) VALUES (2, 'Firstname', 'Lastname',
NOW(),'232') RETURNING entity_id, first_name, last_name, created;"



Line 352 was returing person_id instead of manager_id.

$ psql -U postgres -d mycompany -t -c "INSERT INTO entity_employee
(manager_id, entity_id, startdate, role) VALUES (1, 2, NOW(),
'myuser') RETURNING person_id, entity_id, startdate, role;"

Should be:

$ psql -U postgres -d mycompany -t -c "INSERT INTO entity_employee
(manager_id, entity_id, startdate, role) VALUES (1, 2, NOW(),
'myuser') RETURNING manager_id, entity_id, startdate, role;"

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel