[mythtv-users] How to delete a non-existent encoder from a non-existent machine?

Tom Lichti tom at redpepperracing.com
Wed Aug 27 00:31:27 UTC 2008

Allen Edwards wrote:
>> I just went through both these exercises myself, I manually cleaned the
>> database. I won't post the details unless asked.
>> Tom
> Hi Tom,
> Thank you so much for the reply.  It looks like I will need to do this
> to get the multiple names out and perhaps this will also be a way to
> get the phantom tuner removed.  Can I please see your details?
Delete phantom tuners:

In mythweb -> backend status, find the cardid (encoder number on that 
page) of the cards you want to remove and then run the following sql, 
replacing xx with the encoder number:

delete from cardinput where cardid=xx;

then run:
delete from capturecard where cardid=xx;

using the same encoder number from above. For multiple cards, run the 
two commands multiple times, substituting the different encoder numbers.

To clean out the settings table run:

delete from settings where hostname = 'xxhostnamexx';

replacing xxhostnamexx with the hostname from mythweb.

As was mentioned, make backups of the database before starting. I am not 
responsible for you screwing up your database!


More information about the mythtv-users mailing list