Thanks again, Erik! Unfortunately, still not quite there yet... but we're
getting closer!
Here are my current errors:
psql:sql/modules/EndOfYear.sql:28: ERROR: function eoy_reopen_books(date)
does not exist
LINE 6: SELECT eoy_reopen_books(end_date)
---------------------------------------------------------------------------------
psql:sql/modules/Inventory_Report.sql:44: ERROR: column l.report_id does
not exist
LINE 9: JOIN inventory_report_line l ON l.report_id = r.id
---------------------------------------------------------------------------------
psql:sql/modules/Transaction_Templates.sql:70: NOTICE: type
"journal_search_result" does not exist, skipping
DROP TYPE
psql:sql/modules/Transaction_Templates.sql:83: ERROR: syntax error at or
near ")"
LINE 13: );
---------------------------------------------------------------------------------
psql:sql/modules/Goods.sql:372: ERROR: column "id" does not exist
LINE 4: SELECT * FROM inventory_report_line l WHERE id = $1
---------------------------------------------------------------------------------
psql:/tmp/ledgersmb/lsmb_roles.sql:1423: ERROR: function
admin__list_roles(text) does not exist
---------------------------------------------------------------------------------
Then there's still a few more role id issues:
psql:/tmp/ledgersmb/lsmb_roles.sql:523: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(28) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:525: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(29) is not present in table "menu_node".
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".
psql:/tmp/ledgersmb/lsmb_roles.sql:824: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(87) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:826: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(88) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:828: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(89) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:830: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(90) is not present in table "menu_node".
INSERT 0 1
psql:/tmp/ledgersmb/lsmb_roles.sql:834: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(93) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:849: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(94) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:1428: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(220) is not present in table "menu_node".
psql:/tmp/ledgersmb/lsmb_roles.sql:1430: ERROR: insert or update on table
"menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
DETAIL: Key (node_id)=(221) is not present in table "menu_node".
---------------------------------------------------------------------------------
Sorry, I guess that grew into kind of a long list, but that's all of them.
On Wed, May 15, 2013 at 3:04 PM, Erik Huelsmann <[email protected]> wrote:
>
> On Wed, May 15, 2013 at 11:58 PM, Chris Calef <[email protected]>wrote:
>
>> Ah, I get it now... all those errors are references to menu_node entries
>> that don't exist.
>>
>
> Yea, that's it indeed.
>
>
> Were you able to get the database to work with the fixed Roles.sql file?
>
>
> 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
>
>
------------------------------------------------------------------------------
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
