[mythtv-users] XMLTV setup can't run mythtv-setup as user mythtv

[DryHeat122]

On Mon, Jul 27, 2020 at 10:41 AM Bill Meek <keemllib at gmail.com> wrote:

> On 7/27/20 10:02 AM, Jim Abernathy wrote:
> >
> > On 7/27/20 10:44 AM, DryHeat122 wrote:
> >>
> >> On Sun, Jul 26, 2020 at 7:16 PM Bill Meek <keemllib at gmail.com <mailto:
> keemllib at gmail.com>> wrote:
> >>
> >>
> >>     I didn't do that and put everything in SchedulesDirect.DB. Truth be
> told, if I can carve
> >>     out some time, I always meant to do it the way you did.
> >>
> >>
> >> I don't get how you did that.  When I tried using the same DB name for
> the second grabber, it overwrote the DB rather than appending.  TBH
> >> that seems like a better solution to have just one DB, but I will try
> it like you suggested with different DB names if that's a solution.
>
> Unfortunately, I didn't save the complete terminal session from when I did
> the setup.
>
> Originally, you followed the Wiki exactly and ended up with two DBs.
>
> Best guess is that if only one DB is used, then the 1st step that
> initialized the DB should be omitted. I think the Wiki method
> should stand.
>
> --
> Bill
>
>
Having spent the morning dicking around with this, here is what I learned.
I tried following the steps in the wiki twice with different .xmltv
configurations but using the same DB.  After I added the first one I
checked the channels with a sqlite3 query, and they were all there.  After
adding the second .xmltv config and checking the channels, all the channels
from the second lineup were there but some (not all) of the channels from
the first lineup/config were gone.  Bill, I wonder if this happened to you
and you just don't care about the channels removed.

I suspect this is a bug in tv_grab_zz_sdjson_sqlite because the db has the
structure to keep lineups separate and I can see no reason why adding a
lineup should remove entries from the first one.  I posted a query about it
on the Schedules Direct forum
<https://forums.schedulesdirect.org/viewtopic.php?f=15&t=3103>.  We will
see if anyone responds.

Meanwhile, I re-did everything with separate DBs, ran mythfilldatabase (as
mythtv!) and everything seems to have worked.  So for now, it seems the
best thing to do is have separate DBs.  When/if I get a response from
Schedules Direct I will edit the wiki to make note of this stuff.

Thanks for the advice guys.  On to the next roadblock :-/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200727/0c3fbae2/attachment.htm>