[mythtv-users] Broadening Record Duplicates?

[Aran Cox]

On Wed, Nov 12, 2003 at 01:31:45PM -0500, Ben Curtis wrote:
> 
> >From what I can tell, "don't record duplicates" works by comparing title,
> episode, and description.  If the recording has all of these, it's added
> to the oldrecordings table, and matched against later.  If either of these
> fields is blank, it is not added and recorded, even if it may be a
> duplicate.  Right?
> 
> So, many shows get left out because they leave the description field 
> blank.  You can't compare without description because many other shows set 
> the Episode name to the same value for every episode, so you would miss 
> shows.
> 

I have the same problem with Inuyasha.  This solution is a bit kludgy but works
fine, I think.  If you have a show that has unique subtitle for every episode
but has a blank description, you can just copy the subtitle to the description
and MythTV will suddenly start doing exactly as you expected it to. 

First you need to update your oldrecorded table with something like:

update oldrecorded set starttime=starttime,description=subtitle where description = '' and title='Inuyasha';

You only need to run the above once. 

Now, run the following every day right after mythfilldatabase runs.  I put the following
line in a file and run it with mysql from the same cron entry as mythfilldatabase.

update program set starttime=starttime,description=subtitle where description = '' and title='Inuyasha';

If you exchange Inuyasha for your program title AND your program never has
two different episodes with the same subtitle, this should work.

Aran


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20031112/e1b58a3d/attachment.pgp