SQL Databases from before 2.3.16

[John Ralls]

On Dec 8, 2010, at 5:23 AM, Derek Atkins wrote:

> 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.

Derek,

Actually any "save-as" would have cleaned it up, because the abandoned slots entries weren't being loaded into qof; they
were essentially unreachable.

I probably could cook up a query that selected only the abandoned slots for deletion, but it would take several tries to get right.

Regards,
John Ralls