Mailing List Archive

Chris Petersen wrote:

>I have a number of channels listed with the same number
>(eg. channel 57 is both SHOP and TNN). As far as I can tell, there is
>no easy way to tell them apart.
>
>Does myth have anything to help locate duplicate channels? It really
>behaves weirdly in this instance...
>
The (eh, my) long-term idea is to use chanids instead of channums to
reference channels, and that's what you should do in mythweb. There
can't be 2 channels with chanid 1015 (unless I am missing something),
because chanid is a primary key.

> The (eh, my) long-term idea is to use chanids instead of channums to
> reference channels, and that's what you should do in mythweb. There
> can't be 2 channels with chanid 1015 (unless I am missing something),
> because chanid is a primary key.

well, that's what I *was* doing. but for some reason, I was still only
getting one channel worth of information for duplicates in my list
(really weird - too sleepy to debug it at the moment - thinking it was
an issue with how the data was entered into the database since my sql
queries really look like they're fine).

on that note, is there an easy way to get myth to update its
channel/program data with new information from xmltv? I've commented
out a bunch of channels and would like to get myth to acknowledge that
fact. Or is wiping it and regrabbing everything the simplest way?

-Chris

Chris Petersen wrote:

>>use chanids instead of channums to reference channels
>>
>>
>well, that's what I *was* doing. but for some reason, I was still only
>getting one channel worth of information for duplicates in my list
>
sure, if you use chanid, there is always at most one channel (row) with
that id.

>on that note, is there an easy way to get myth to update its
>channel/program data with new information from xmltv? I've commented
>out a bunch of channels and would like to get myth to acknowledge that
>fact. Or is wiping it and regrabbing everything the simplest way?
>
I don't think that update removes anything (apart from outdated stuff),
so yes, wiping or manually deleting some rows would be the way.

BTW: Wiping the program table will lose non-recoverable information, if
the program.overridesomething column from that 'don't supress' patch is
added.

> sure, if you use chanid, there is always at most one channel (row) with
> that id.

yeah, I'm aware of that. But I'm wondering (still need to check) if
mythfilldatabase bothers to check that or not. I wiped my table data
before I could see if there were separate program entries for both
same-number channels.

-Chris

Chris Petersen wrote:

>yeah, I'm aware of that. But I'm wondering (still need to check) if
>mythfilldatabase bothers to check that or not.
>
MySQL does, to my knowledge. It won't allow you to add another row with
the same chanid, it will bail, if you try to.

>>yeah, I'm aware of that. But I'm wondering (still need to check) if
>>mythfilldatabase bothers to check that or not.
> MySQL does, to my knowledge. It won't allow you to add another row with
> the same chanid, it will bail, if you try to.

right. but if mythfilldatabase is adding based on a non-unique entry
(which channum is in the channel table), it could mess things up. I'll
check on it when I get home.

On Monday 02 June 2003 02:56 am, Chris Petersen wrote:
> during my rewrite of mythweb, I started noticing some interesting
> discrepancies in my database. I then checked the Cable.xmltv file and
> noticed that I have a number of channels listed with the same number
> (eg. channel 57 is both SHOP and TNN). As far as I can tell, there is
> no easy way to tell them apart.
>
> Does myth have anything to help locate duplicate channels? It really
> behaves weirdly in this instance...

Ah, no, it doesn't. I went through quite a long time ago and removed those
dupes from my channel lineup -- they're really channels that 'switch' at like
3 am or whatnot to the more ad-based one, from what I can tell. There's
nothing indicating this in the xmltv data, though.

Isaac

> Ah, no, it doesn't. I went through quite a long time ago and removed
> those dupes from my channel lineup -- they're really channels that
> 'switch' at like 3 am or whatnot to the more ad-based one, from what I
can
> tell. There's nothing indicating this in the xmltv data, though.

actually, in my case, it seems to be a mini-region kind of thing. the
channels are different numbers in different areas of the city (seattle)
or suburbs.

maybe if I get bored I'll write a check into mythfilldatabase that
queries about duplicate channels numbers (though as I understand it, Ben
has duplicate numbers that are actually different channels, so maybe
something special will need to be done for this).

-Chris

Chris Petersen wrote:

>though as I understand it, Ben has duplicate numbers that are actually different channels, so maybe something special will need to be done for this
>
Nope, I don't have duplicate channels. :-)

Ben