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".
---------------------------------------------------------------------------------