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

[Steve Hodge]

On Tue, Oct 23, 2012 at 5:35 PM, Worik Stanton <worik.stanton at gmail.com>wrote:

> On 23/10/12 15:19, Steve Hodge wrote:
> > better check before proceeding. So run the sql again:
> > select chanid, channum, freqid, sourceid, callsign, name, xmltvid,
> visible,
> > useonairguide, mplexid, serviceid from channel;
>
> Attached.
>
> Now none have have xmltvid
>

This will add xmltvids for the channels you had xmltvids before:
update channel set xmltvid = 'basefm.freeviewnz.tv' where channid = 3071;
update channel set xmltvid = 'c4.freeviewnz.tv' where channid = 3009;
update channel set xmltvid = 'four.freeviewnz.tv' where channid = 3004;
update channel set xmltvid = 'maori-tv.freeviewnz.tv' where channid = 3005;
update channel set xmltvid = 'parliament.freeviewnz.tv' where channid =
3022;
update channel set xmltvid = 'prime.freeviewnz.tv' where channid = 3010;
update channel set xmltvid = 'rnz-concert.freeviewnz.tv' where channid =
3051;
update channel set xmltvid = 'rnz-national.freeviewnz.tv' where channid =
3050;
update channel set xmltvid = 'tv1.freeviewnz.tv' where channid = 3001;
update channel set xmltvid = 'tv2.freeviewnz.tv' where channid = 3002;
update channel set xmltvid = 'tv3.freeviewnz.tv' where channid = 3033;
update channel set xmltvid = 'tv3-plus1.freeviewnz.tv' where channid = 3008;
update channel set xmltvid = 'u.freeviewnz.tv' where channid = 3006;
commit;

Probably you have lost all you recording rules. Did you make a backup of
the database?

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