[mythtv-users] Unable to add channels

[Michael T. Dean]

On 10/06/2013 03:10 PM, Monkey Pet wrote:
> On Sat, Oct 5, 2013 at 10:34 PM, Monkey Pet wrote:
>
>> On Wed, Oct 2, 2013 at 7:33 PM, Monkey Pet wrote:
>>
>>> Running mythtv 0.26.x, I scan for channels, it says it found some, but
>>> refuses to add them.  I am not sure what I am doing wrong.  I am in the US
>>> and using broadcast.  I have tried deleting and re-adding the capture cards
>>> (HD homerun) and also input sources.  I tried all to delete all the
>>> channels.  My HD homerun is connected to a UHF antenna.
>>>
>> I also tried with mythtv 0.27 same issue.  I am thinking something is
>> goofy about my db.  I dropped by db, then started a new one from scratch,
>> the scan and channel add went through fine.  Can someone suggest which
>> additional tables I need to delete or clear to make the channel add work?
>>   Like I said in my previous post, i deleted through mythtv-setup all
>> capture cards, video sources, input connections.  Mythtv finds the channel
>> and pretends like it is adding it, but it doesn't.
>>
> I ended up starting with a new database, then doing a partial restore of
> the database to bring over my recordings, scanning for the new channels
> worked, my recordings are still there!
>
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
>

FWIW, there is /absolutely/ no difference between starting with a new 
database and using an old database with old capture card/video 
source/input/channel configuration that's been "cleared" with "Delete 
all video sources" and "Delete all capture cards" (not "Delete all 
capture cards from <hostname>").  The /only/ way a new database would be 
different is if your database schema were corrupt in some way (which can 
happen in any of a number of ways, including restoring a database backup 
that wasn't created properly).  That said, if you did have a corrupt 
schema, the partial restore is the proper way to fix it (and, really, 
that's the only useful purpose of a partial restore).

Glad you got it working, though.  And, even if you just needed to do the 
"Delete all video sources" and/or "Delete all capture cards" to make 
things work with the old database, the process you described would work, 
too, and the only down side is all the extra work you had to do to 
reconfigure every single backend and frontend system and re-create data 
for all your plugins (rescan for videos/music/... and re-grab/-fix 
metadata and ...).  So at this point, you've paid the price for the 
partial restore, and you might as well stick with the database you have, 
now.  (In other words, I'm not recommending you go back and do it the 
other way, but trying to ensure that anyone else who sees this thread in 
the archives knows that there was probably a much easier approach than 
nuking the database from orbit.)

Mike