The mythweb interface is what I was looking for. I have been through the interface before, but missed it. Works great. <br><br>Thanks Brad!<br><br>Dan<br><br><br><div class="gmail_quote">On Tue, Jan 6, 2009 at 10:29 AM, Jan Ceuleers <span dir="ltr"><<a href="mailto:jan.ceuleers@computer.org">jan.ceuleers@computer.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c">Dan Littlejohn wrote:<br>
> Is there an easy sql command to delete channels from the database?<br>
><br>
> Channels keep getting added to my schedules direct feed (new channels) and<br>
> most of them are junk like music or pay per view so I disable them, but the<br>
> channels don't disappear from the listings so there are all these entries<br>
> that just show "NO DATA".<br>
<br>
</div></div>See Brad's reply for how to do it properly, but I also have a method.<br>
<br>
My schedules grabbing script (not using SchedulesDirect) results in<br>
phantom channels being created(*), which I delete using the following<br>
SQL snippet:<br>
<br>
delete from program where chanid not in (select chanid from channel);<br>
delete from programrating where chanid not in (select chanid from channel);<br>
<br>
HTH, Jan<br>
<br>
<br>
<br>
(*) The reason is that in my case I use a range of grabbers to create<br>
one listings file, that I then apply to both of my video sources. One of<br>
these video sources is better quality than the other but has only a<br>
subset of channels available (DVB-T versus cable). So phantom channels<br>
are created, complete with listings, on the DVB-T source. I could avoid<br>
this by creating separate listings files for each video source but that<br>
would take longer and impose a higher load on the (probably already<br>
reluctant) listings websites being scraped by the grabbers.<br>
<div><div></div><div class="Wj3C7c"><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>