Thanks Erik and Håvard! You were right.
This time I got some output.
aels=# SELECT * FROM defaults WHERE setting_key = 'version';
setting_key | value
-------------+-------
version | 1.3.0
(1 row)
id | username | notify_password | entity_id
----+----------+-----------------+-----------
1 | paul | 7 days | 2
(1 row)
user_id | role
---------+------------------------------------------
1 | lsmb_aels__account_all
1 | lsmb_aels__account_create
1 | lsmb_aels__account_edit
1 | lsmb_aels__ap_all
1 | lsmb_aels__ap_all_transactions
1 | lsmb_aels__ap_all_vouchers
1 | lsmb_aels__ap_invoice_create
1 | lsmb_aels__ap_invoice_create_voucher
1 | lsmb_aels__ap_transaction_create
1 | lsmb_aels__ap_transaction_create_voucher
1 | lsmb_aels__ap_transaction_list
1 | lsmb_aels__ar_all
1 | lsmb_aels__ar_invoice_create
1 | lsmb_aels__ar_transaction_all
1 | lsmb_aels__ar_transaction_create
1 | lsmb_aels__ar_transaction_create_voucher
1 | lsmb_aels__ar_transaction_list
1 | lsmb_aels__assembly_stock
1 | lsmb_aels__assets_administer
1 | lsmb_aels__assets_approve
1 | lsmb_aels__assets_depreciate
(stdin):
1 | lsmb_aels__assets_enter
1 | lsmb_aels__audit_trail_maintenance
1 | lsmb_aels__auditor
1 | lsmb_aels__backup
1 | lsmb_aels__batch_create
1 | lsmb_aels__batch_list
1 | lsmb_aels__batch_post
1 | lsmb_aels__business_type_all
1 | lsmb_aels__business_type_create
1 | lsmb_aels__business_type_edit
1 | lsmb_aels__cash_all
1 | lsmb_aels__close_till
1 | lsmb_aels__contact_all_rights
1 | lsmb_aels__contact_create
1 | lsmb_aels__contact_edit
1 | lsmb_aels__contact_read
1 | lsmb_aels__department_all
1 | lsmb_aels__department_create
1 | lsmb_aels__department_edit
1 | lsmb_aels__draft_edit
1 | lsmb_aels__file_attach_order
1 | lsmb_aels__file_attach_part
:
this continues for many pages and ends with
1 | lsmb_aels__warehouse_edit
1 | lsmb_aels__yearend_run
(113 rows)
(END):
Thanks again!
Billy
hi Billy,On Sun, Mar 18, 2012 at 10:37 PM, billy akazawa <..hidden..> wrote:
Hi,Thanks for the ideas everyone!
Erik,
I entered the
SELECT * FROM defaults WHERE setting_key = 'version';
you gave me and got:
postgres=# SELECT * FROM defaults WHERE setting_key = 'version';
ERROR: relation "defaults" does not exist
LINE 1: SELECT * FROM defaults WHERE setting_key = 'version';Ok. This and the other errors indicate that the database wasn't of the expected structure. How did you connect? Did you use the command line program:$ psql -d aels?If you didn't use the -d argument option, that'd explain most of your errors. Maybe you can retry with the -d parameter, if that's the case?Logging in at setup.pl gives the database as 'postgres'
That doesn't seem correct. Can you tell us which parameters you enter into the 'setup.pl' login page? Did you enter 'aels' in the 'database' field? (the third one?)Bye,Erik.
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users