On Wed, Dec 28, 2011 at 7:59 PM, Michael Richardson <[email protected]> wrote: > > I'm trying to fix prepare-company-database.sh for postgresql 9.1. > I'm finding a few foreign key violations in Roles.sql, for instance: > > ledgersmb_development=# INSERT INTO menu_acl (node_id, acl_type, role_name) > ledgersmb_development-# values (134, 'allow', 'lsmb_bigcocom__backup'); > ERROR: insert or update on table "menu_acl" violates foreign key constraint > "menu_acl_node_id_fkey" > DETAIL: Key (node_id)=(134) is not present in table "menu_node". > > The node_id refers into menu_node(id), and as far as I can see, this is > inserted by the function "menu_insert" in Pg-database.sql (line 3413). > > It seems to me that the number, "134" is rather magic, and may depend > heavily upon the order in which the menu items are loaded? > > sql/upgrade/svn/3470-asset-menu.sql seems to be where it is loaded. > > I'm unclear why/how this would get loaded by prepare-company-database.sh. > > ==== Testing skaffolding. BELOW is not relevant to question, unless you > want to reproduce the problem. > > Awhile ago I wanted to hack on ledgersmb, but wanted to make some unit > tests. I started to build some testing skaffolding using the "can-o-pg" > RoR plugin I built. This is what I'm doing for testing. I'll be > pushing my ./prepare-test-database.sh changes back out once I figure > them all out. > > To run it: > git clone git://github.com/credil/ledgersmb-skaffold.git > cd ledgersmb-skaffold > git submodule init > git submodule update > tests/01-prepare/tests.sh > > (there is only one test so far. Yes, I imported via git-svn. You could > do an SVN clone to subdir ledgersmb if you preferred) > > -- > ] He who is tired of Weird Al is tired of life! | firewalls > [ > ] Michael Richardson, Sandelman Software Works, Ottawa, ON |net > architect[ > ] [email protected] http://www.sandelman.ottawa.on.ca/ |device > driver[ > Kyoto Plus: watch the video <http://www.youtube.com/watch?v=kzx1ycLXQSE> > then sign the petition. > > > > > > ------------------------------------------------------------------------------ > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex > infrastructure or vast IT resources to deliver seamless, secure access to > virtual desktops. With this all-in-one solution, easily deploy virtual > desktops for less than the cost of PCs and save 60% on VDI infrastructure > costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox > _______________________________________________ > Ledger-smb-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel >
The nodes referenced there should be inserted in the COPY menu_node statement in the Pg-database. If the menu node is truly missing, we should delete the statement. It could refer to a node that was deleted for one reason or another. Best Wishes, Chris Travers ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
