[mythtv-users] season and episode population from schedules direct json has been incomplete.
Tom Dexter
digitalaudiorock at gmail.com
Thu Jan 18 02:46:04 UTC 2024
On Wed, Jan 17, 2024 at 9:37 PM Tom Dexter <digitalaudiorock at gmail.com> wrote:
>
> On Wed, Jan 17, 2024 at 4:38 PM Tom Dexter <digitalaudiorock at gmail.com> wrote:
> >
> > I've just recently started noticing the same missing seasons and
> > episodes. I've never used anything except for the non-sqlite version.
> >
> > I suppose I may have to change to that sqlite one. On the whole,
> > Schedules Direct seems to do a good job, but on occasion they do some
> > really questionable stuff. There was that bizarre thing they did some
> > time back where they apparently replaced their backend stuff with some
> > new python version, which totally broke a lot of stuff. They ended up
> > having to roll that back, and I've never heard anything about it
> > since. It all makes me wonder what they might have done here.
> >
> > Tom
>
> Wow. Can someone clarify where those seasons and episodes are even stored?
>
> Tonight I have an episode of Family Law recording right now. MythTV
> and MythWeb bother show season 3 and episode 1 and an "Episode Number"
> of S3E1, but nothing I see in the database has that data. For example:
>
> --------------
> select * from recorded where title='family law' and
> starttime='2024-01-18 02:00:00'
> --------------
>
> *************************** 1. row ***************************
> chanid: 1111
> starttime: 2024-01-18 02:00:00
> endtime: 2024-01-18 03:00:00
> title: Family Law
> subtitle: What Came First?
> description: Still dealing with the aftermath of her own divorce,
> Abby represents a woman whose ex-husband left her for a man and now
> wants to use their last remaining embryo -- created when they were
> married -- to start a new family together.
> season: 0
> episode: 0
> category: Drama
> hostname: mythback
> bookmark: 0
> editing: 0
> cutlist: 0
> autoexpire: 1
> commflagged: 0
> recgroup: Default
> recordid: 11633
> seriesid: EP03905844
> programid: EP039058440021
> inetref:
> lastmodified: 2024-01-17 21:30:01
> filesize: 1309370180
> stars: 0
> previouslyshown: 1
> originalairdate: 2022-12-23
> preserve: 0
> findid: 0
> deletepending: 0
> transcoder: 0
> timestretch: 1
> recpriority: 0
> basename: 1111_20240118020000.ts
> progstart: 2024-01-18 02:00:00
> progend: 2024-01-18 03:00:00
> playgroup: Default
> profile: Default
> duplicate: 0
> transcoded: 0
> watched: 0
> storagegroup: Default
> bookmarkupdate: 0000-00-00 00:00:00
> recgroupid: 1
> recordedid: 20276
> inputname: HDHR 2-1 03
>
> Can't make any sense out of that.
>
> Tom
OK...Found that. That's all in the program table. It's interesting
that I have this data specifically for a case with an older original
airdate. Here's that data:
--------------
select * from program where title='family law' and
starttime='2024-01-18 02:00:00'
--------------
*************************** 1. row ***************************
chanid: 1111
starttime: 2024-01-18 02:00:00
endtime: 2024-01-18 03:00:00
title: Family Law
subtitle: What Came First?
description: Still dealing with the aftermath of her own
divorce, Abby represents a woman whose ex-husband left her for a man
and now wants to use their last remaining embryo -- created when they
were married -- to start a new family together.
category: Drama
category_type: series
airdate: 0000
stars: 0
previouslyshown: 1
title_pronounce:
stereo: 0
subtitled: 1
hdtv: 1
closecaptioned: 0
partnumber: 0
parttotal: 0
seriesid: EP03905844
originalairdate: 2022-12-23
showtype:
colorcode:
syndicatedepisodenumber: S3E1
programid: EP039058440021
manualid: 0
generic: 0
listingsource: 4
first: 1
last: 0
audioprop: DOLBY
subtitletypes: NORMAL
videoprop: HDTV
inetref:
season: 3
episode: 1
totalepisodes: 0
Tom
More information about the mythtv-users
mailing list