[mythtv-users] inconsistent inetref in recorded table

[Brian J. Murrell]

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.

Cheers,
b.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160124/e932a607/attachment.sig>