[mythtv-users] Recordings from nonexistent channels

Jan Ceuleers jan.ceuleers at gmail.com
Tue Jul 31 12:19:28 UTC 2012

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

More information about the mythtv-users mailing list