[mythtv-users] Possible bug in database schema upgrade (0.21 -> 0.22)

[Michael T. Dean]

On 11/05/2009 06:30 PM, Michael T. Dean wrote:
> On 11/05/2009 05:27 PM, Lars Michael Jogbäck wrote:
>> I've found problem when I was trying to upgrade my database
>>
>> When I ran mythtv-setup, it spitted out the infamous "Database
>> corruption detected. Unable to proceed with database upgrade. (Table:
>> oldrecorded, Warnings: 157)"
>>   
>
>> After more carefully examining those it turns out, that when changing
>> the datatype of description from TEXT to VARBINARY(255) it got
>> truncated just between the two bytes in an existing utf8 character and
>> by that causing an false positive.
>
> Thanks.  I'll get this fixed. 

Lars, do you by any chance still have a copy of the pre-upgrade backup 
that I could get for a test-run with the fix.  We'd like to run a sanity 
check on the fix with real data versus generated data.  If you still 
have it, I'd appreciate your posting a bzip2'ed or gzip'ed copy of the 
backup file at http://filebin.ca/ (or anywhere else you'd like) and 
sending me an e-mail (direct to my address and with the same subject, if 
you don't want it on the list) with the link so I can download it and do 
a test run.

Thanks,
Mike