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

Mark Perkins perkins1724 at hotmail.com
Mon Aug 1 10:51:24 UTC 2016


On 1 August 2016 5:18:56 PM ACST, Stephen Worthington <stephen_agent at jsw.gen.nz> 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.
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://lists.mythtv.org/mailman/listinfo/mythtv-users
>http://wiki.mythtv.org/Mailing_List_etiquette
>MythTV Forums: https://forum.mythtv.org

As i understand it, if there is a programid in both the current episode and the previously recorded episode then duplicate detection will *never* progress past comparing the programid values.

So at face value its only a matter of understanding the programid value comparisons.

What do the following sql queries return:
select * from recordedprogram where programid="EXPB01Ep2";
select * from recorded where programid="EXPB01Ep2";



More information about the mythtv-users mailing list