[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
1.3ver - Load a template Chart of Accounts section - errors
- Subject: 1.3ver - Load a template Chart of Accounts section - errors
- From: Joseph <..hidden..>
- Date: Tue, 22 Sep 2009 15:59:37 -0600
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