[mythtv-users] inconsistent inetref in recorded table

[Jeremy Jones]

On Jan 24, 2016 7:58 AM, "Brian J. Murrell" <brian at interlinx.bc.ca> wrote:
>
> On Sun, 2016-01-24 at 06:11 +0100, Hika van den Hoven wrote:
> > Hoi Brian,
> >
> > Sunday, January 24, 2016, 5:37:47 AM, you wrote:
> >
> > > I have a number of shows where the episodes have inconsistent
> > > inetrefs.
> > >  i.e.:
> >
> > > Criminal Minds  True Genius     2012-01-24 02:00:00
> > > Criminal Minds  Unknown Subject 2012-01-26 02:00:00
> > > Criminal Minds  Closing Time    2012-02-16 02:00:00     75710
> > > Criminal Minds  A Family Affair 2012-03-01 02:00:00     75710
> > > Criminal Minds  I Love You, Tommy Brown 2012-03-20
> > > 01:00:00     75710
> > > Criminal Minds  The Itch        2014-10-23
> > > 01:00:00     ttvdb.py_75710
> > > Criminal Minds  Boxed In        2014-10-30
> > > 01:00:00     ttvdb.py_75710
> > > Criminal Minds  If the Shoe Fits        2014-11-06
> > > 02:00:00     ttvdb.py_75710
> > > Criminal Minds  Hashtag 2014-11-13 02:00:00     ttvdb.py_75710
> > > Criminal Minds  The Boys of Sudworth Place      2014-11-20 02:00:00
> > > ttvdb.py_75710
> > > Criminal Minds  Fate    2014-11-27 02:00:00     ttvdb.py_75710
> > > Criminal Minds  Amelia Porter   2014-12-11
> > > 02:00:00     ttvdb.py_75710
> > > Criminal Minds  The Forever People      2015-01-15
> > > 02:00:00     ttvdb.py_75710
> > > Criminal Minds  Anonymous       2015-01-22
> > > 02:00:00     ttvdb.py_75710
> > > Criminal Minds  Scream  2015-02-12 02:00:00     ttvdb.py_75710
> > > Criminal Minds  Lockdown        2015-03-05
> > > 02:00:00     ttvdb.py_75710
> > > Criminal Minds  Breath Play     2015-03-12 01:00:00
> > > Criminal Minds  Rock Creek Park 2015-03-26
> > > 01:00:00     ttvdb.py_75710
> > > Criminal Minds          2015-04-06 05:04:00     tmdb3.py_15714
> > > Criminal Minds  Beyond Borders  2015-04-09
> > > 01:00:00     ttvdb.py_75710
> >
> > > As you can see for that one show, I have inetrefs of 75710,
> > > ttvdb.py_75710 and tmdb3.py_15714
> >
> > > Is this expected?
> >
> > > Cheers,
> > > b.
> >
> > The one jumping to tmdb3.py is probably because of missing episode
> > info!
>
> Yes.  That episode has the generic show data.  But that doesn't explain
> how it got a TMDB ID of 15714.  According to my (next to zero)
> knowledge of TMDB, 15714 is "Seaside Special" (https://www.themoviedb.o
> rg/tv/15714).
>
> But even that only answers half of the question.  Of the remaining
> entries why are some 75710 and others ttvdb.py_75710?  Given that the
> difference correlates to time, it seems that the format of the field
> was changed to include which scraper the ID is for.
>
> But then why didn't the database migration for whichever version that
> introduced that change update the existing inetrefs rather than leaving
> them inconsistent like this?
>
> >  I don't know the precise algorithm to determine which to use,
> > but that is part of it.
>
> If I had to guess it's based on an ordered list and the first one to
> return info wins.  ttvdb is probably higher in the list than tmdb3.
>

Interesting.  I think my post on X-rated fanart is related to this.

Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160124/82d3f21e/attachment.html>