Hi,
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)
aels=# select * from USERS;
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
On Mon, Mar 19, 2012 at 7:06 AM, Erik Huelsmann <[email protected]> wrote:
> hi Billy,
>
> On Sun, Mar 18, 2012 at 10:37 PM, billy akazawa <[email protected]>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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
