[mythtv-users] Problem with duplicate checking - new episode will not record

Stephen Worthington stephen_agent at jsw.gen.nz
Mon Aug 1 09:11:42 UTC 2016


On Mon, 1 Aug 2016 10:45:31 +0200, you wrote:

>Hoi Stephen,
>
>Monday, August 1, 2016, 9:48:56 AM, you wrote:
>
>> MythTV Version : v0.28-46-ge5ce273
>> MythTV Branch : fixes/0.28
>> Network Protocol : 88
>> Library API : 0.28.20160309-1
>> QT Version : 5.2.1
>
>> My mother's MythTV box is recording a series called "Expedition Burma"
>> for her from the ChoiceTV channel.  It has successfully recorded the
>> first episode, but now is saying it will not record the second
>> episode, despite there being different descriptions and programid
>> values in the database for the two episodes.  I have tried all the
>> available options in the recording rule for duplicate matching, but
>> only when I tell it not to match duplicates at all does it say it will
>> record the next episode.  And then, since each episode is repeated
>> three times in a week on that channel, it says it will record all
>> three copies of that episode.
>
>> I thought that if there was a programid value in the EPG that it would
>> always be used to determine if an episode was a duplicate or not, and
>> only after that would the other options be used.  That is not
>> happening.
>
>> But even if it was not using the programid values, the description
>> text for the second episode differs from the description for the first
>> episode.  So when I set the recording rule to match on descriptions
>> only, it should say it will record the second episode.  But it does
>> not.
>
>> So does anyone have any idea what is going wrong here?
>
>> Here is the database for the already recorded first episode:
>
>mysql>> select * from recorded where title like '%burma'\G
>> *************************** 1. row ***************************
>>          chanid: 1012
>>       starttime: 2016-07-28 09:33:00
>>         endtime: 2016-07-28 10:43:00
>>           title: Expedition Burma
>>        subtitle:
>>     description: Across Southeast Asia wildlife is in dramatic decline
>> but, with almost half the country still covered in thick forest, Burma
>> may hold the key to saving these species from extinction.
>>          season: 0
>>         episode: 0
>>        category:
>>        hostname: crw-pvr
>>        bookmark: 0
>>         editing: 0
>>         cutlist: 0
>>      autoexpire: 1
>>     commflagged: 1
>>        recgroup: Default
>>        recordid: 1247
>>        seriesid: 201173617
>>       programid: EXPB01Ep1
>>         inetref:
>>    lastmodified: 2016-07-28 22:43:09
>>        filesize: 1554212920
>>           stars: 0
>> previouslyshown: 0
>> originalairdate: 0000-00-00
>>        preserve: 0
>>          findid: 0
>>   deletepending: 0
>>      transcoder: 0
>>     timestretch: 1
>>     recpriority: 0
>>        basename: 1012_20160728093300.ts
>>       progstart: 2016-07-28 09:35:00
>>         progend: 2016-07-28 10:35:00
>>       playgroup: Default
>>         profile: Default
>>       duplicate: 1
>>      transcoded: 0
>>         watched: 0
>>    storagegroup: Default
>>  bookmarkupdate: 0000-00-00 00:00:00
>>      recgroupid: 1
>>      recordedid: 1181
>>       inputname: DVB-T 2
>> 1 row in set (0.01 sec)
>
>> And here are the database entries for the EPG from both the recorded
>> episode and the upcoming second episode:
>
>mysql>> select * from program where title like '%burma'\G
>> *************************** 1. row ***************************
>>                  chanid: 1012
>>               starttime: 2016-07-28 09:35:00
>>                 endtime: 2016-07-28 10:35:00
>>                   title: Expedition Burma
>>                subtitle:
>>             description: Across Southeast Asia wildlife is in dramatic
>> decline but, with almost half the country still covered in thick
>> forest, Burma may hold the key to saving these species from
>> extinction.
>>                category:
>>           category_type:
>>                 airdate: 2016
>>                   stars: 0
>>         previouslyshown: 0
>>         title_pronounce:
>>                  stereo: 0
>>               subtitled: 0
>>                    hdtv: 0
>>          closecaptioned: 0
>>              partnumber: 0
>>               parttotal: 0
>>                seriesid: 201173617
>>         originalairdate: NULL
>>                showtype:
>>               colorcode:
>> syndicatedepisodenumber:
>>               programid: EXPB01Ep1
>>                manualid: 0
>>                 generic: 0
>>           listingsource: 4
>>                   first: 1
>>                    last: 0
>>               audioprop:
>>           subtitletypes:
>>               videoprop:
>>                 inetref:
>>                  season: 0
>>                 episode: 0
>>           totalepisodes: 0
>> *************************** 2. row ***************************
>>                  chanid: 1012
>>               starttime: 2016-07-28 16:00:00
>>                 endtime: 2016-07-28 17:00:00
>>                   title: Expedition Burma
>>                subtitle:
>>             description: Across Southeast Asia wildlife is in dramatic
>> decline but, with almost half the country still covered in thick
>> forest, Burma may hold the key to saving these species from
>> extinction.
>>                category:
>>           category_type:
>>                 airdate: 2016
>>                   stars: 0
>>         previouslyshown: 0
>>         title_pronounce:
>>                  stereo: 0
>>               subtitled: 0
>>                    hdtv: 0
>>          closecaptioned: 0
>>              partnumber: 0
>>               parttotal: 0
>>                seriesid: 201173617
>>         originalairdate: NULL
>>                showtype:
>>               colorcode:
>> syndicatedepisodenumber:
>>               programid: EXPB01Ep1
>>                manualid: 0
>>                 generic: 0
>>           listingsource: 4
>>                   first: 0
>>                    last: 0
>>               audioprop:
>>           subtitletypes:
>>               videoprop:
>>                 inetref:
>>                  season: 0
>>                 episode: 0
>>           totalepisodes: 0
>> *************************** 3. row ***************************
>>                  chanid: 1012
>>               starttime: 2016-07-29 02:00:00
>>                 endtime: 2016-07-29 03:00:00
>>                   title: Expedition Burma
>>                subtitle:
>>             description: Across Southeast Asia wildlife is in dramatic
>> decline but, with almost half the country still covered in thick
>> forest, Burma may hold the key to saving these species from
>> extinction.
>>                category:
>>           category_type:
>>                 airdate: 2016
>>                   stars: 0
>>         previouslyshown: 0
>>         title_pronounce:
>>                  stereo: 0
>>               subtitled: 0
>>                    hdtv: 0
>>          closecaptioned: 0
>>              partnumber: 0
>>               parttotal: 0
>>                seriesid: 201173617
>>         originalairdate: NULL
>>                showtype:
>>               colorcode:
>> syndicatedepisodenumber:
>>               programid: EXPB01Ep1
>>                manualid: 0
>>                 generic: 0
>>           listingsource: 4
>>                   first: 0
>>                    last: 1
>>               audioprop:
>>           subtitletypes:
>>               videoprop:
>>                 inetref:
>>                  season: 0
>>                 episode: 0
>>           totalepisodes: 0
>> *************************** 4. row ***************************
>>                  chanid: 1012
>>               starttime: 2016-08-04 09:35:00
>>                 endtime: 2016-08-04 10:30:00
>>                   title: Expedition Burma
>>                subtitle:
>>             description: A team of scientists and wildlife filmmakers
>> find out whether Burma's vast forests could be the last stronghold for
>> iconic species already lost in the rest of the world.
>>                category:
>>           category_type:
>>                 airdate: 2016
>>                   stars: 0
>>         previouslyshown: 0
>>         title_pronounce:
>>                  stereo: 0
>>               subtitled: 0
>>                    hdtv: 0
>>          closecaptioned: 0
>>              partnumber: 0
>>               parttotal: 0
>>                seriesid: 201173617
>>         originalairdate: NULL
>>                showtype:
>>               colorcode:
>> syndicatedepisodenumber:
>>               programid: EXPB01Ep2
>>                manualid: 0
>>                 generic: 0
>>           listingsource: 4
>>                   first: 1
>>                    last: 0
>>               audioprop:
>>           subtitletypes:
>>               videoprop:
>>                 inetref:
>>                  season: 0
>>                 episode: 0
>>           totalepisodes: 0
>> *************************** 5. row ***************************
>>                  chanid: 1012
>>               starttime: 2016-08-04 16:00:00
>>                 endtime: 2016-08-04 17:00:00
>>                   title: Expedition Burma
>>                subtitle:
>>             description: A team of scientists and wildlife filmmakers
>> find out whether Burma's vast forests could be the last stronghold for
>> iconic species already lost in the rest of the world.
>>                category:
>>           category_type:
>>                 airdate: 2016
>>                   stars: 0
>>         previouslyshown: 0
>>         title_pronounce:
>>                  stereo: 0
>>               subtitled: 0
>>                    hdtv: 0
>>          closecaptioned: 0
>>              partnumber: 0
>>               parttotal: 0
>>                seriesid: 201173617
>>         originalairdate: NULL
>>                showtype:
>>               colorcode:
>> syndicatedepisodenumber:
>>               programid: EXPB01Ep2
>>                manualid: 0
>>                 generic: 0
>>           listingsource: 4
>>                   first: 0
>>                    last: 0
>>               audioprop:
>>           subtitletypes:
>>               videoprop:
>>                 inetref:
>>                  season: 0
>>                 episode: 0
>>           totalepisodes: 0
>> *************************** 6. row ***************************
>>                  chanid: 1012
>>               starttime: 2016-08-05 02:00:00
>>                 endtime: 2016-08-05 03:00:00
>>                   title: Expedition Burma
>>                subtitle:
>>             description: A team of scientists and wildlife filmmakers
>> find out whether Burma's vast forests could be the last stronghold for
>> iconic species already lost in the rest of the world.
>>                category:
>>           category_type:
>>                 airdate: 2016
>>                   stars: 0
>>         previouslyshown: 0
>>         title_pronounce:
>>                  stereo: 0
>>               subtitled: 0
>>                    hdtv: 0
>>          closecaptioned: 0
>>              partnumber: 0
>>               parttotal: 0
>>                seriesid: 201173617
>>         originalairdate: NULL
>>                showtype:
>>               colorcode:
>> syndicatedepisodenumber:
>>               programid: EXPB01Ep2
>>                manualid: 0
>>                 generic: 0
>>           listingsource: 4
>>                   first: 0
>>                    last: 1
>>               audioprop:
>>           subtitletypes:
>>               videoprop:
>>                 inetref:
>>                  season: 0
>>                 episode: 0
>>           totalepisodes: 0
>> 6 rows in set (0.02 sec)
>
>
>> This is the recording rule:
>
>mysql>> select * from record where title like '%burma'\G
>> *************************** 1. row ***************************
>>      recordid: 1247
>>          type: 4
>>        chanid: 1012
>>     starttime: 09:35:00
>>     startdate: 2016-07-28
>>       endtime: 10:35:00
>>       enddate: 2016-07-28
>>         title: Expedition Burma
>>      subtitle:
>>   description: Across Southeast Asia wildlife is in dramatic decline
>> but, with almost half the country still covered in thick forest, Burma
>> may hold the key to saving these species from extinction.
>>        season: 0
>>       episode: 0
>>      category:
>>       profile: Default
>>   recpriority: 0
>>    autoexpire: 1
>>   maxepisodes: 0
>>     maxnewest: 0
>>   startoffset: 1
>>     endoffset: 4
>>      recgroup: Default
>>     dupmethod: 4
>>         dupin: 15
>>       station: ChoiceTV
>>      seriesid: 201173617
>>     programid: EXPB01Ep1
>>       inetref:
>>        search: 0
>> autotranscode: 0
>>  autocommflag: 1
>>  autouserjob1: 0
>>  autouserjob2: 0
>>  autouserjob3: 0
>>  autouserjob4: 0
>>  autometadata: 0
>>       findday: 5
>>      findtime: 21:35:00
>>        findid: 0
>>      inactive: 0
>>      parentid: 0
>>    transcoder: 0
>>     playgroup: Default
>>     prefinput: 0
>>   next_record: NULL
>>   last_record: 2016-07-28 09:33:00
>>   last_delete: NULL
>>  storagegroup: Default
>>     avg_delay: 100
>>        filter: 0
>>    recgroupid: 1
>> 1 row in set (0.00 sec)
>
>
>> And this is the first entry for the upcoming second episode in the
>> xmltv file from today's EPG update:
>
>>   <programme channel="choice.freeviewnz.tv" start="20160804213500
>> +1200" stop="20160804223000 +1200">
>>     <title>Expedition Burma</title>
>>     <desc>A team of scientists and wildlife filmmakers find out
>> whether Burma's vast forests could be the last stronghold for
>> iconic species already lost in the rest of the world.</desc>
>>     <episode-num system="dd_progid">EXPB01Ep2</episode-num>
>>     <rating system="Freeview">
>>       <value>G</value>
>>     </rating>
>>   </programme>
>
>> The timezone for New Zealand is 12 hours ahead of UTC.
>> _______________________________________________
>
>Have you checked whether the programids for the other episodes do
>differ. I anyhow find it a weird programid. Is it supplied by your
>provider?

Yes, the programids are different: EXPB01Ep1 for the first episode and
EXPB01Ep2 for the second episode.  See the above database records. And
yes, it is a dd_progid format programid provided directly by ChoiceTV
- it comes to me via the MHEG5 EPG transmitted along with the DVB-T
channels.  ChoiceTV are actually one of the better channels here in
New Zealand for providing proper EPG data.  Some of the DVB-S channels
have nothing at all - no programid, no subtitles and a generic
description that does change sometimes, but not with every episode.


More information about the mythtv-users mailing list