[mythtv-users] Duplicate detection

[Michael T. Dean]

On 09/19/2016 11:41 AM, Jan Ceuleers wrote:
> Hi Karl, thanks for replying.
>
> On 19/09/16 15:56, Karl Newman wrote:
>> Here are some mysql queries that might start to shed some light:
>> Show upcoming programs:
>> SELECT programid, channum, callsign, listingsource, starttime, title,
>> subtitle, description FROM program, channel WHERE
>> program.chanid=channel.chanid AND title='Escape From Alcatraz';
> The result of this query is 2 rows, both corresponding with the same
> upcoming program. This is because I have two video sources and because
> the channel on which the upcoming showing is going to be broadcast is
> available from both sources.
>
>> Show previously recorded programs:
>> SELECT programid, channum, callsign, starttime, recstatus, title,
>> subtitle, description FROM oldrecorded, channel WHERE
>> oldrecorded.chanid=channel.chanid AND title='Escape From Alcatraz';
> The result here is three rows: one for a recording in 2014, another for
> a recording in 2015 and also an entry for the upcoming recording.
>
>> The recstatus field may be interesting there. Here's the enumeration of
>> that value:
>> https://github.com/MythTV/mythtv/blob/v0.27.3/mythtv/libs/libmyth/programtypes.h#L210
> The first two rows in oldrecorded have a recstatus value of -3
> (rsRecorded), whereas the third has a recstatus value of -1 (rsWillRecord).
>
> I have uploaded the mysql output here in case you are interested:
>
> https://www.dropbox.com/s/0i7i65244yq5d7r/Alcatraz%20duplicates.txt?dl=0
>
> How can we find out why the upcoming recording is not being regarded as
> a duplicate?
>
> Many thanks, Jan

Use the UI in mythfrontend, as I mentioned in my other response. You can 
go into Upcoming Recordings, find the showing, and hit SELECT to edit 
the recording rule.  That will show you exactly which recording rule is 
being used/matching the episode.  That will help you identify what's 
wrong/why it's recording.

Are you using subtitle /and/ description or subtitle /then/ 
description?  If the latter, because the movies have no subtitle, it 
compares the descriptions, which definitely differ.

Mike