[mythtv-users] season and episode population from schedules direct json has been incomplete.

[Tom Dexter]

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