[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