[mythtv-users] delete channels from listing with no data

Dan Littlejohn dan.littlejohn at gmail.com
Tue Jan 6 17:04:15 UTC 2009


The mythweb interface is what I was looking for.  I have been through the
interface before, but missed it.  Works great.

Thanks Brad!

Dan


On Tue, Jan 6, 2009 at 10:29 AM, Jan Ceuleers <jan.ceuleers at computer.org>wrote:

> Dan Littlejohn wrote:
> > Is there an easy sql command to delete channels from the database?
> >
> > Channels keep getting added to my schedules direct feed (new channels)
> and
> > most of them are junk like music or pay per view so I disable them, but
> the
> > channels don't disappear from the listings so there are all these entries
> > that just show "NO DATA".
>
> See Brad's reply for how to do it properly, but I also have a method.
>
> My schedules grabbing script (not using SchedulesDirect) results in
> phantom channels being created(*), which I delete using the following
> SQL snippet:
>
> delete from program where chanid not in (select chanid from channel);
> delete from programrating where chanid not in (select chanid from channel);
>
> HTH, Jan
>
>
>
> (*) The reason is that in my case I use a range of grabbers to create
> one listings file, that I then apply to both of my video sources. One of
> these video sources is better quality than the other but has only a
> subset of channels available (DVB-T versus cable). So phantom channels
> are created, complete with listings, on the DVB-T source. I could avoid
> this by creating separate listings files for each video source but that
> would take longer and impose a higher load on the (probably already
> reluctant) listings websites being scraped by the grabbers.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20090106/6fef43e5/attachment.htm 


More information about the mythtv-users mailing list