[mythtv-users] Cleaning phantom tuners from DB

Michael T. Dean mtdean at thirdcontact.com
Wed Aug 13 16:13:21 UTC 2008


On 08/13/2008 11:23 AM, Brad DerManouelian wrote:
> 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.

And direct editing of the DB data is always a recipe for 
disaster--unless you know everything about all the data you're changing 
and all the data that references the data you're changing.  There's a 
user interface for fixing this stuff for a reason, you know.

And that approach will also leave garbage in other tables of the 
database which will--if not now, eventually--cause major problems.  So, 
you'll eventually have to do it right...

http://www.gossamer-threads.com/lists/mythtv/users/264034#264034

Which, BTW, is the right way to clean up the DB data in the first place 
(so, please, don't edit the data directly).

And, if you don't like the "names" you're seeing (Tuner 0, etc.), then 
tell Myth you want to use real names:

Display Name (optional)
This name is displayed on screen when live TV begins and when changing 
the selected input or card. If you use this, make sure the information 
is unique for each input.

in mythtv-setup when connecting inputs.  Any other "names" are meant to 
be used only internally, so shouldn't be a problem for you.

Mike


More information about the mythtv-users mailing list