[mythtv-users] Fwd: Re: failing upgrade from 0.21-fixes to 0.23-fixes using mysql 5.1 / Ubuntu 10.4
Michael T. Dean
mtdean at thirdcontact.com
Wed Jun 23 18:23:14 UTC 2010
I sent this to you yesterday shortly after I got the DB. It seems your
mail system ate that one. This time I'm sending a copy to the list,
too, just in case.
Don't you just love spammers and how they've made e-mail so unreliable.
Mike
-------- Original Message --------
Subject: Re: [mythtv-users] failing upgrade from 0.21-fixes to
0.23-fixes using mysql 5.1 / Ubuntu 10.4
Date: Tue, 22 Jun 2010 17:35:13 -0400
From: Michael T. Dean
To: Alain Brossard
On 06/22/2010 04:21 PM, Alain Brossard wrote:
> Here is the link, thanks in advance,
You have 2 invalid values for subtitles from a long time ago:
| ven aoû 15 06:00:00 2008 |
| jeu déc 25 07:45:00 2008 |
(where special characters may be corrupted by this e-mail, but basically
they contain a u with caret and e with accent that are encoded in
Latin1, not UTF-8, so they couldn't be converted).
So, to fix the database, run the following in a shell and change the
username and database name, if necessary (it will prompt for password):
cat<< "EOF" | mysql -umythtv -p mythconverg
UPDATE oldrecorded
SET subtitle = 'jeu dec 25 07:45:00 2008'
WHERE HEX(subtitle) = '6A65752064E9632032352030373A34353A30302032303038';
UPDATE oldrecorded
SET subtitle = 'ven aou 15 06:00:00 2008'
WHERE HEX(subtitle) = '76656E20616FFB2031352030363A30303A30302032303038';
EOF
(If you paste the copy/paste the above, the mail client may insert a
space after EOF, which will prevent it from working properly. So, the
best approach is probably to copy everything except the EOF line, then
paste it into a shell, then hit Enter, type EOF, then Enter.) If you're
concerned about my American-izing the characters, you can edit the
values and put the accents in /after/ the upgrade to 0.23 (when
character encoding will not be an issue).
After you've run the above command, your database should upgrade without
issues. I would recommend, though, that you ensure you've enabled
Mythbuntu auto-builds and updated to current 0.23-fixes before
attempting the upgrade. There's a bug in the pre-release version of
MythTV that ships with *buntu 10.04 that may cause a database upgrade
failure even with valid data. In other words, if you don't upgrade,
you'll likely have other problems on upgrade since you do have a lot of
non-ASCII characters in your data, but I can guarantee that the backup
you gave me upgrades fine if you're using current 0.23-fixes on Qt 4.6.2.
http://www.mythbuntu.org/auto-builds and then Activate Auto Builds and
select the 0.23-fixes auto builds, then update MythTV.
Enjoy, and good luck with the rest of the upgrade.
Mike
More information about the mythtv-users
mailing list