[mythtv-users] Multiple duplicated recordings

[Alex Tomlins]

On 12/08/13 21:29, Michael T. Dean wrote:
> On 08/12/2013 04:21 PM, Alex Tomlins wrote:
>> I'm have an 'any time on any channel' rule set up to record Top 
>> Gear.  At the moment there are one or 2 episodes of this where all 6+ 
>> showings of it are recorded (Dave likes to repeat things a lot).
>>
>> I'm using xmltv (UK Radio Times) for listing data, and the episodes 
>> with the problems are the ones with no series/episode information 
>> that therefore don't have a programid in Myth.  If I understand 
>> http://www.mythtv.org/wiki/Duplicate_matching correctly, this should 
>> fall back to the duplicate detection method in this case, which I've 
>> set to Subtitle and Description.
>>
>> Looking in the database, the subtitles are all blank, and they all 
>> have exactly the same description
>
> Blank actually means NULL and, in MySQL, NULL != NULL (i.e. you can't 
> compare subtitle for equality if there is no subtitle--else it will 
> /always/ compare as different).
>
In the database, the subtitles are all set to '' (i.e. empty string), 
and not to NULL:

mysql> select generic, chanid, starttime, subtitle, description from 
program where title = 'Top Gear' AND programid = '' and starttime > 
now() and endtime < '2013-08-15' and subtitle IS NULL order by starttime;
Empty set (0.00 sec)

mysql> select generic, chanid, starttime, subtitle, description from 
program where title = 'Top Gear' AND programid = '' and starttime > 
now() and endtime < '2013-08-15' and subtitle = '' order by starttime;
+---------+--------+---------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------+
| generic | chanid | starttime           | subtitle | description |
+---------+--------+---------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------+
|       0 |   1012 | 2013-08-13 17:00:00 |          | Jeremy Clarkson, 
James May and Richard Hammond put three cars at home on both the race 
track and the streets of suburbia to the test. |
|       0 |   1025 | 2013-08-13 18:00:00 |          | Jeremy Clarkson, 
James May and Richard Hammond put three cars at home on both the race 
track and the streets of suburbia to the test. |
|       0 |   1012 | 2013-08-14 08:00:00 |          | Jeremy Clarkson, 
James May and Richard Hammond put three cars at home on both the race 
track and the streets of suburbia to the test. |
|       0 |   1025 | 2013-08-14 09:00:00 |          | Jeremy Clarkson, 
James May and Richard Hammond put three cars at home on both the race 
track and the streets of suburbia to the test. |
|       0 |   1012 | 2013-08-14 13:00:00 |          | Jeremy Clarkson, 
James May and Richard Hammond put three cars at home on both the race 
track and the streets of suburbia to the test. |
|       0 |   1025 | 2013-08-14 14:00:00 |          | Jeremy Clarkson, 
James May and Richard Hammond put three cars at home on both the race 
track and the streets of suburbia to the test. |
+---------+--------+---------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------+
6 rows in set (0.01 sec)

> Therefore, change your duplicate detection mechanism to "subtitle then 
> description", which will use subtitle if it's available, otherwise it 
> will use description.
>
>
I'd switched from "subtitle then description" in the past because some 
of the listings had very generic subtitles (e.g. 'Motoring show') which 
led to false matches, and missed showings.  I'd like to avoid switching 
back if possible...


thanks,
Alex

-- 
Alex Tomlins
Email/Jabber: alex at tomlins.org.uk

There are two kinds of people in the world: those who finish what they started