[mythtv-users] Recordings from nonexistent channels

[Mike Perkins]

On 31/07/12 13:19, Jan Ceuleers wrote:
> On 07/31/2012 01:39 AM, Another Sillyname wrote:
>
>>> select * from channel where channum = '2019';
>>
>> As an afterthought.......
>>
>> select * from record;
>>
>> and see if any of the recording rules were setup pointing at an old
>> chanid, if you've rebuilt the box since the original scan some of your
>> recording rules may have become orphaned.
>
> mysql> select * from channel where chanid='2019';
> Empty set (0.00 sec)
>
> mysql> select * from record where chanid <> 0 and chanid not in (select chanid from channel);
> Empty set (0.00 sec)
>
> I have lots of recording rules with chanid=0 (i.e. matching all channels).
>
Try looking for channum instead of chanid. chanid is an arbitrary record key 
which may or may not correspond to some channel. channum is what your provider 
thinks is the channel number.

-- 

Mike Perkins