[mythtvnz] Channel id to name tables: Where are they?

[Steve Hodge]

On Tue, Oct 23, 2012 at 3:18 PM, Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:

> On Tue, 23 Oct 2012 10:16:29 +1300, you wrote:
>
> >On 23/10/12 02:56, Steve Hodge wrote:
> >> Before you do any of the stuff that Stephen has suggested you should
> post a
> >> dump of your channel table that includes the sourceid and useronairguide
> >> columns:
> >> select chanid, channum, freqid, sourceid, callsign, name, xmltvid,
> visible,
> >> useonairguide, mplexid, serviceid from channel;
> >
> >Okidoki.
> >
> >Here it is.
>
> Good call, Steve.  There are two sources.  So now we need to see how
> the two sources are set up.  The sourceid field is used in only three
> tables: channel, videosource and dtv_multiplex.  So please post the
> results of these:
>
> select * from videosource;
> select * from dtv_multiplex;
>
> I think this is all still the result of two scans, and that one source
> can be deleted, along with all the related channel records.
>
> To safely delete one duplicate set of channel records, we also need to
> know where the chanid values in those records are being used, and
> whether they will then need to be changed from 1xxx to 3xxx and vice
> versus.


The downloaded guide data is being loaded against sourceid 1 - we can tell
because that's the one with the channels with xmltvid and one of those
channels had data for "Get Smart". So to avoid having to change that
process it'll be easier if Worik deletes sourceid 3. However, checking to
see what's been used is a good idea as it'd probably be better to keep the
sourceid with the channels that the recording rules are setup up against.
So the "record" table is the most important one to check out.

Cheers,
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20121023/b4ad6c62/attachment-0001.html>