Re: A little trouble installing 1.4.

Hi Chris,

On Wed, May 15, 2013 at 9:02 PM, Chris Calef <..hidden..> wrote:

Hi again,

Sorry, got distracted away from keys for a day or two, but I just updated and tried my setup.pl again, and _almost_ all my errors went away with the recent changes to Reconciliation.sql. (Yay!)

The main one that is still shows up repeatedly looks like this:

psql:/tmp/ledgersmb/lsmb_roles.sql:635: ERROR: insert or update on table "menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(17) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:637: ERROR: insert or update on table "menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(18) is not present in table "menu_node".

I'm hoping Chris Travers can have a quick look, but I'm imagining menu entries have been renumbered or deleted and these are remnants left behind.

Which seems a little weird, I'm no SQL expert but menu_node and menu_acl in my database both have the same foreign key definition for "menu_acl_node_id_fkey": "FOREIGN KEY (node_id) REFERENCES menu_node(id)". Unless it's trying to refer to the entire string "(node_id)=(17)" as a key(??)

Well, you're right, but the error is that the node_id value (which is 17) doesn't occur in the menu_node table.

Also, my dblog concludes with this error, I don't know if it's related to the other one or an independent problem:

psql:/tmp/ledgersmb/lsmb_roles.sql:1651: ERROR: syntax error at or near "END"
LINE 10: END IF;
^
psql:/tmp/ledgersmb/lsmb_roles.sql:1655: ERROR: function tg_enforce_perms_eclass() does not exist
psql:/tmp/ledgersmb/lsmb_roles.sql:1659: ERROR: function tg_enforce_perms_eclass() does not exist

Ok. This is a bug. Just committed a terminating semicolon to tg_enforce_perms_eclass() in r5792. You should be able to update and not see this error anymore.

Please provide your further feedback! And if you have more questions, please don't hesitate to ask.

Bye,

Erik.