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

[Stephen Worthington]

On Tue, 23 Oct 2012 20:44:30 +1300, you wrote:

>>> 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?
>
>Why would he lose recording rules?

All but one of his recording rules was based on a channel associated
with a source that was deleted.  I do not know if the rules are
deleted along with a source, but it seems that channels are.  Worik
will now be able to tell us if the deleting of a source's channels
also automatically deletes recording rules based on those channels. If
the programmers of this code were good, I would say the rules will
also be gone.