[mythtvnz] Still getting the wrong channel - log weirdness

[Worik Stanton]

On 31/10/12 16:19, Steve Hodge wrote:
>> > select chanid, sourceid, callsign, name, mplexid, serviceid, xmltvid,
>> > last_record from channel;
>> >
> 2302    1    TV3 PLUS1    TV3 PLUS1    1    1302    four.freeviewnz.tv
> 0000-00-00 00:00:00
> 2418    1    TV3PL    TV3Plus1    NULL    0    tv3-plus1.freeviewnz.tv
> 2012-10-29 21:33:02
> 
> Here's your problem. You've still got screwed up channel data. Channel 2302
> is the correct "TV3 + 1" but it has the wrong xmltvid, as noted by Tony.
> You need to fix that - do it in Mythweb.

mythweb is talks channum not chanid, but that is OK I can sort that out.
 Why is there a channum and chanid?

I notice that RNZ (rnz-national.freeviewnz.tv) has no channum.  Should I
add one?

I removed xmltvid from the channel with chanid == 2418 (it had no channum)

I've checked all my other xmltvid and they seem t make sense.

update channel set visible = 0 where mplexid is null and serviceid = 0;
commit;

Done that.  But what does the 'visible' field control?

cheers
W

-- 
it does not matter                      I think that I shall never see
how much I dig and dig                    A billboard lovely as a tree
this hole just                      Indeed, unless the billboards fall
keeps getting deeper                      I'll never see a tree at all

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 551 bytes
Desc: OpenPGP digital signature
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20121031/fb3bffcf/attachment.pgp>