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

Re: Problem with Upgrading from 1.1.12 to 1.2.4



Hello:

thank you for your advice......
but it still in the same condition, it doesnt work
Well, about the sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql, the script was done with commit,my versions; i have postgres 8.2.3 and perl 5.8.7, ....

++++++++My message when i try to login:
LedgerSMB/User.pm:205
SELECT value FROM defaults
WHERE setting_key ='version'
ERROR: column "value" does not exist
LINE 2: SELECT value from defaults

+++++++++++smb-ledger user configuration:
mos:
Driver:pg            Host:localhost
dataset:rfrd         port:4532
user:ledgersmb   pass:xxx

+++++++++++ the parameters:
ledgersmb.conf
[globaldb]
DBname = ledgersmb
DBhost   = localhost
DBport    = 5432
BDUserName = ledgersmb
DBPassword = xxx

+++++++but, the table exists and the column too:
$ psql -U ledgersmb -d ledgersmb
ledgersmb=> SELECT value FROM defaults WHERE setting_key ='version';
value
--------
1.2.0
(1 row)

++++++ so what's wrong??
i wish, you could help me

Best regards!!


Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.