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

1.3ver - Load a template Chart of Accounts section - errors



I'm following the instructions from: INSTALL file.
I've loaded English_General.sql accounts


When following section: Generate A Custom Roles SQL Statement File
running:
sed -e 's/<?lsmb dbname ?>/sysconcept_smb/g' /usr/local/ledgersmb/sql/modules/Roles.sql >
/usr/local/ledgersmb/sysconcept_smb_roles.sql
completed OK

but
psql -U postgres -d sysconcept_smb -f /usr/local/ledgersmb/sysconcept_smb_roles.sql

I got few errors:
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:63: ERROR:  syntax error at or near "note_id_seq" at character 23
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:63: LINE 1: GRANT ALL ON SEQUENCE note_id_seq TO "lsmb_sysconcept_smb__c...
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:63:

Line 63 is:
GRANT ALL ON SEQUENCE note_id_seq TO "lsmb_sysconcept_smb__create_contact";



The errors below I think have something to do with admin.sql security.sql templates.

psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1082: ERROR:  relation "chart_id_seq" does not exist

psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1390: ERROR:  function admin__add_user_to_role(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1392: ERROR:  function admin__remove_user_from_role(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1394: ERROR:  function admin__add_function_to_group(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1396: ERROR:  function admin__remove_function_from_group(text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1398: ERROR:  function admin__get_roles_for_user(integer) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1400: ERROR:  function admin__save_user(integer, integer, text, text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1402: ERROR:  function admin__create_group(text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1404: ERROR:  function admin__delete_user(text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1406: ERROR:  function admin__list_roles(text) does not exist
psql:/usr/local/ledgersmb/sysconcept_smb_roles.sql:1408: ERROR:  function admin__delete_group(text) does not exist

How to go about it?
How to proceed with installation?
--
Joseph