[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