[mythtv-users] Unable to add channels

[Monkey Pet]

On Mon, Oct 7, 2013 at 1:24 PM, Michael T. Dean <mtdean at thirdcontact.com>wrote:

> 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<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.)
>

Thanks Michael for the response and specifically this useful info to the
thread.

My database was probably messed up in weird and mysterious ways.  My mythtv
setup went through a bunch of crazy stuff like power supply blowing, drive
filling up, drive having bad sectors, multiple fedora upgrades, motherboard
swaps,  and probably stuff I don't even remember. My oldest recording is
dated 2005 and I have been lucky that the database kept churning along
until the latest chanscan incident.  Hopefully won't need to do this again
for another 10 years :)

Still a very happy mythtv user, my family is surprised when they see
commercials.


>
> Mike
> ______________________________**_________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/**listinfo/mythtv-users<http://www.mythtv.org/mailman/listinfo/mythtv-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131007/75e5cf74/attachment.html>