[mythtv-users] Duplicate detection

[Jan Ceuleers]

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