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

Re: unexpected version error



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 <..hidden..> wrote:
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