[mythtv-users] setup fails
Peter J. Blowers
pblowers at chartermi.net
Mon Apr 14 13:18:21 UTC 2003
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
More information about the mythtv-users
mailing list