[mythtv-users] Can't delete channels without a channel number from the editor

[Nick Morrott]

On 16/10/2007, James Telfer <jameswtelfer at googlemail.com> wrote:
> I have about half a dozen channels with no associated channel number
> (I believe because of the changes that have occurred over the last few
> months on UK DVB-T).  I have tried deleting these from the channel
> editor in mythtv-setup, but they reappear when I exit and re-start the
> tool.  Is there any other way of permanently removing these from the
> DB?

You could delete the video source that these channels are attached too
- this should remove them from the database *if* they are still linked
to the video source. If there is only one video source on your system,
opting to "Delete all video sources" will truncate the channels table
and will definitely remove them. This method would require you to
recreate/rescan your video source, but should only contain good
channels afterwards.

Alternatively, you could manually remove the offending channels from
the DB directly, using a tool such as phpMyAdmin, or directly from the
mysql> prompt. This should only remove the bad channels, but cannot be
carried out from within the MythTV UI.

Whichever method you choose, take a backup of the DB before making any
changes, and remember to restart mythbackend afterwards.

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin