[mythtv-users] Recordings from nonexistent channels

[Jan Ceuleers]

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).