John,

John Ralls <jra...@ceridwen.us> writes:

> Everyone using a SQL backend who started with data saved from XML with a 
> Gnucash version before 2.3.16 should re-save from XML with 2.3.17 and 
> re-enter any intervening transactions.
>
> I just fixed 635967 [1], which complained that scheduled transactions didn't 
> work in 2.3.17 from a database created with 2.3.15.
>
> That's true, and r19911 fixes it. It was caused by a change in the way that 
> KVP data are saved and retrieved by the SQL backend in r19729 which fixed 
> 627831 [2], a much worse data loss: All online banking and some transaction 
> data for transactions that have more than one KVP slot; perhaps other data as 
> well.

Do you think there may have been some SQL you could have used to clean
this up?  Going forward (after 2.4.0) we will NOT be able to ask people
to save to XML and reload the Database.  *ANY* Schema changes or data
corrections we need to make will need to be done in-place within the
SQL.

C.f. MythTV for a reference on how to do this.

> Regards,
> John Ralls

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warl...@mit.edu                        PGP key available
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Reply via email to