[mythtv-users] Schedules Direct DataDirect replacement service testing

[Tom Dexter]

On Mon, Oct 6, 2014 at 7:43 PM, Tom Dexter <digitalaudiorock at gmail.com> wrote:
> On Mon, Oct 6, 2014 at 9:43 AM, Robert Eden <rmeden at gmail.com> wrote:
>> At this point, based on user comments, I now am considering the SD-DD
>> service only has 13 days of usable data.  Not the end of the world. :)
>>
>> Robert
>>
>
> That appears to be the case.  Today for the first time I didn't get
> any sort of warning about not inserting any new data, and I have 13
> days:
>
> Last mythfilldatabase run started on Mon Oct 6 2014, 9:07 AM and ended
> on Mon Oct 6 2014, 9:09 AM. Successful.
> There's guide data until 2014-10-19 02:00:00 (13 days).
>
> I just noticed something very unusual, and it may not have anything to
> do with any of this, but I'm sure I've never seen this behavior
> before:
>
> When I go into the listings in MythWeb for last night, none of the
> shows I recorded are showing as having been recorded.  With the
> default theme, those are usually displayed with a dotted outline, and
> the mouseover usually shows "Notes: This showing was recorded.".
> Everything recorded on prior nights does show as recoded.  This is NOT
> happening in the frontend however..it's displaying everything from
> last night as recorded.
>
> I'm sure I've never seen that before.  Can anyone else look for
> similar behavior?
>
> Tom

OK...I think I figured out what's causing this:

It looks like the seriesid being returned by the replacement server is
different from the one I was getting from the real DD server.  As a
result, mythweb isn't finding them properly...which may be a related
bug in mythweb.  However, that aside, I'm not even sure which is
correct.  Here's the data where I found this:

--------------
select chanid, seriesid, starttime, subtitle from oldrecorded where
title='madam secretary' and chanid=1021 and recstatus=-3 order by
starttime
--------------

+--------+------------+---------------------+------------------+
| chanid | seriesid   | starttime           | subtitle         |
+--------+------------+---------------------+------------------+
|   1021 | EP01922294 | 2014-09-22 00:30:00 | Pilot            |
|   1021 | EP01922294 | 2014-09-29 00:01:00 | Another Benghazi |
|   1021 | EP01922294 | 2014-10-06 00:30:00 | The Operative    |
+--------+------------+---------------------+------------------+

--------------
select chanid, seriesid, starttime, subtitle from program where
title='madam secretary' and chanid=1021 order by starttime
--------------

+--------+------------+---------------------+-------------------------+
| chanid | seriesid   | starttime           | subtitle                |
+--------+------------+---------------------+-------------------------+
|   1021 | EP01922294 | 2014-09-22 00:30:00 | Pilot                   |
|   1021 | EP01922294 | 2014-09-22 02:30:00 | Pilot                   |
|   1021 | EP01922294 | 2014-09-28 00:00:00 | Pilot                   |
|   1021 | EP01922294 | 2014-09-29 00:01:00 | Another Benghazi        |
|   1021 | SH01922294 | 2014-10-06 00:30:00 | The Operative           |
|   1021 | SH01922294 | 2014-10-13 00:01:00 | Just Another Normal Day |
+--------+------------+---------------------+-------------------------+

As you can see, my recording history in oldrecorded as well as the
programs from the DD server (older ones that were not overwritten by
the replacement server last night) have the seriesid of EP01922294
while the new programs have SH01922294.

Can anyone verify which is actually correct?

Thanks!
Tom