Re: Problem with Upgrading from 1.1.12 to 1.2.4

["Chris Travers" <..hidden..>]

On 7/4/07, Rodolfo Rodriguez <..hidden..> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users