Hi Chris,
On Wed, May 15, 2013 at 9:02 PM, Chris Calef <[email protected]> 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.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
