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

Stephen Worthington stephen_agent at jsw.gen.nz
Mon Aug 1 07:48:56 UTC 2016


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.


More information about the mythtv-users mailing list