[mythtv-users] Fwd: Re: failing upgrade from 0.21-fixes to 0.23-fixes using mysql 5.1 / Ubuntu 10.4

[Michael T. Dean]

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