Re: unexpected version error

[billy akazawa <..hidden..>]

	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';

and also with the “greater than (>) symbol in your mail

postgres=# > SELECT * FROM defaults WHERE setting_key = 'version';

ERROR:  syntax error at or near ">"
LINE 1: > SELECT * FROM defaults
WHERE  setting_key = 'version';

select * from USERS;

gives

select * from USERS;

ERROR:  relation "users" does
not exist
LINE 1: select * from USERS;

SELECT * FROM lsmb_roles;

gives

postgres=# SELECT * FROM lsmb_roles;

ERROR: relation "lsmb_roles" does not exist

LINE 1: SELECT * FROM lsmb_roles;

postgres-# \l

gives:

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+-----------+-----------+---------+-------+-----------------------

aels | postgres | UTF8 | C | C |

ledgersmb | ledgersmb | SQL_ASCII | C | C |

mytestdb | postgres | SQL_ASCII | C | C |

postgres | postgres | SQL_ASCII | C | C |

template0 | postgres | SQL_ASCII | C | C | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | SQL_ASCII | C | C | =c/postgres +

| | | | | postgres=CTc/postgres

(6 rows)

I deleted the other ledgersmb databases and now the only database created by ledgersmb is 'aels'

Håvard,

Logging in at setup.pl gives the
database as 'postgres'

Thanks in advance.

Billy

On Sun, Mar 18, 2012 at 8:21 PM, Håvard Sørli <..hidden..> wrote:

On 17. mars 2012 23:51, billy akazawa wrote:
> All ideas and advice are greatly appreciated.

When you login with setup.pl what does it read on the
"Logged in as" line ?


============================
Database Management Console

Confirm Operation
Logged in as ledgersmbadm
LedgerSMB 1.3 found
Rebuild/Upgrade?
===========================

H


------------------------------------------------------------------------------
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