[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