mtdean at thirdcontact
Nov 5, 2009, 8:32 PM
Post #2 of 2
(265 views)
Permalink
|
|
Re: Possible bug in database schema upgrade (0.21 -> 0.22)
[In reply to]
|
|
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
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
|
