[mythtv-users] setup fails

[Peter J. Blowers]

Joel Feenstra wrote:
> I had to goto my -/.mythtv/Source.xmltv that had a list of channels, I 
> commented out some of them, then I used phpmyadmin to delete the program 
> entries. All is now good, I think. I haven't done a filldatabase yet, so 
> they might come back. The whole point of it was to get rid of the 
> listings of movies on those channels in the program finder, I don't know 
> if myth does an database house keeping but they would probably still 
> show-up there if you only got rid of their mention in the channels table.

You are correct that it is the <sourcename>.xmltv file
that needs to be edited. If you comment out a channel
(leading "#") mythfilldatabase won't grab the listings
for that channel. For any channel that is grabbed but
not in the the mysql "channel" table, mythfilldatabase
INSERTs a new entry. Therefore, you need to do this before
you delete it from the channel table or else it will be
re-added the next time mythfilldatabase runs. The EPG will
show all channels that are in the channel table even if
there are no listings.

So, to get rid of a channel, first comment it out of the
<sourcename>.xmltv file then delete the unwanted item
from the channel table:

mysql> delete from channel where chanid = '<number>';

To get rid of current the current listings:

mysql> delete from program where chanid = '<number>';

Hope this helps,

--  bjm