Re: [SL] Data migration...

[Paul T. <pt...@wa...>]

Jersey schreef:
> Hello all,
>
> I installed sql-ledger on a new machine with Debian testing. The current
> version of sql-ledger supplied is 2.6.22. I restored my data created in
> version 2.4.4 and update the dataset. This is what I am getting:
>
> **************************
> Upgrading to Version 2.6.22 ... 
> Error!
> create table recurring (id int, reference text, startdate date, nextdate
> date, enddate date, repeat int2, unit varchar(6), howmany int, payment
> bool default 'f')
> ERROR: relation "recurring" already exists
> **************************
>
> Any help will be highly appreciated
>
> Best regards
> "Jersey"
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition. 
> Version: 7.5.467 / Virus Database: 269.6.5/793 - Release Date:
> 2007/05/07 02:55 PM
>  
>
>
> -------------------------------------------------------------------------
> 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/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   
Try installing the corrct older version, restore backup and then uodate 
would seem logical.
Otherwise: run the various update scripts in the \sql-ledger\sql\ 
directory, starting with Update_2.44 >2.xx might do the trick.

Hth
Paul