SQL Databases from before 2.3.16

[Derek Atkins]

John,

John Ralls <jralls at 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
       warlord at MIT.EDU                        PGP key available