[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: A little trouble installing 1.4.



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 <..hidden..> wrote:

On Wed, May 15, 2013 at 11:58 PM, Chris Calef <..hidden..> 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel