On 7/4/07, Rodolfo Rodriguez <[EMAIL PROTECTED]> wrote: > 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
The most likely case is that the user is set up to use a different database (rdrd) and that database is still in an older version. That is the database you need to run the upgrade script against :-). Best Wishes, Chris Travers > > Best regards!! > > > > ________________________________ > Be a better Heartthrob. Get better relationship answers from someone who > knows. > Yahoo! Answers - Check it out. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
