[mythtv-users] Problem with duplicate checking - new episode will not record
Hika van den Hoven
hikavdh at gmail.com
Mon Aug 1 18:40:48 UTC 2016
Hoi Mark,
Monday, August 1, 2016, 12:51:24 PM, you wrote:
> 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.
>>_______________________________________________
> 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";
I also found out recently that forget old in Mythweb does work
nowadays in 0.27
Tot mails,
Hika mailto:hikavdh at gmail.com
"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"
De lerende Mens
More information about the mythtv-users
mailing list