[mythtv] [mythtv-commits] Ticket #2705: Duplicate Check method "subtitle" not working

Michael T. Dean mtdean at thirdcontact.com
Wed Dec 13 02:16:33 UTC 2006


On 12/12/2006 07:03 AM, MythTV wrote:
> #2705: Duplicate Check method "subtitle" not working
>
>  Ok,
>  I backed up my DB...
>  Deleted mythconverg and started from scratch with a new DB (A bit
>  frustrating because I am now re recording shows I have seen before). The
>  net result is all is well now. It seems somehow during the upgrade process
>  My db became corrupt.
>
>  If needed I think I still have a copy of the corrupt DB.
>   

Most likely--for both (all?) of you (Chris/fales, jellono (and Dave if 
he's not jellono)--during the upgrade the programid column of 
oldrecorded or program table(s) got "truncated"--turned into a 
VARCHAR(6) rather than the intended VARCHAR(20).  This generally happens 
because your database is set to use the wrong character set (i.e. 
you--or something on your system--changed it from latin1 after the 
database was initially created with mc.sql) and the "re-conversion" to 
the proper encoding that occurs during the database upgrade causes MySQL 
to do other automatic "fixes" (like changing that VARCHAR(20) to a 
VARCHAR(6)).  This truncation will cause all episodes of a given program 
to appear as previously recorded since the first 6 characters of the 
programid will be identical for any particular series.

If this is the case, I would /not/ trust the post-upgrade database (or 
any backups you made after the upgrade).  The SQL backup ( 
http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 ) of the pre-upgrade 
database should import into a MySQL installation that's configured to 
use latin1 character set and allow a successful upgrade.

Mike


More information about the mythtv-dev mailing list