[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!
Tom
More information about the mythtv-users
mailing list