[mythtv-users] Cleaning phantom tuners from DB

Brad DerManouelian myth at dermanouelian.com
Wed Aug 13 15:23:59 UTC 2008


On Aug 13, 2008, at 7:46 AM, Steve Heistand wrote:

>> Apparently I dorked around enough when I first set up my myth system
>> that I have a couple "phantom" tuners somewhere in the database.
>>
>> My active tuners are labeled "1" and "2" in various places in the
>> frontend interface and the mythweb interface. Whenever I go into
>> mythtv-setup, and exit, it tells me that "non-existent tuner "0" is
>> set to channel 2, do you want to fix this?"
>>
>> I've been telling it "no, I know what I'm doing", and things are
>> working, but how do I clean this up?  I'd like to surgically remove
>> anything pertaining to tuner "0".  If it would make things happier,
>> I'd like to remove all the 0 stuff, and then update the db so that  
>> 1 -
>>> 0 and then 2 -> 1, so the DB looks like it was set up right the
>> first time.
>
> bring up your favorite sql database editor (mysqlnavigator is mine)  
> and
> go into the table database->mythconverg->capturecard and delete the
> entries you dont want.
> with mythbackend not running at the time of course.

That won't renumber what's already there or set the cardinality if you  
add more tuners in the future.


More information about the mythtv-users mailing list