[mythtv-users] Duplicate Channels Cleanup

[Eric Sharkey]

On Mon, Sep 15, 2014 at 6:18 PM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 09/15/2014 02:38 PM, Eric Sharkey wrote:
>
>> On Mon, Sep 15, 2014 at 11:37 AM, Michael T. Dean wrote:
>>>
>>> On 09/15/2014 10:25 AM, Martin Compton wrote:
>>>>
>>>> I was cleaning up my DISH-TV Schedules Direct listings and ran
>>>> mythfilldatabase to update the channels.
>>>>
>>>> When I was checking the channels table I noticed that some have 2-3
>>>> duplicate entries for the same sourceid+channel+callsign+xmltvid (etc).
>>>>
>>>> Can I safely reassign the chanid in the associated tables:
>>>> channelgroup
>>>> program (these duplicates can be deleted)
>>>> programgenres
>>>> programrating
>>>> record
>>>> recorded
>>>> oldrecorded
>>>>
>>>> and remove the duplicate channels?
>>>>
>>>> Am I missing any tables with a "chanid" column?
>>>
>>>
>>> The proper way to handle "ghost" channels (as you get when you don't
>>> properly set the XMLTV ID on channels before running mythfilldatabase and
>>> your broadcasters provide in-stream information about the channel that
>>> mythfilldatabase can't match to one of your scanned channels) is to
>>> "Delete
>>> all video sources" (to clear out everything--both the good and the bad
>>> channel info--from all the tables that are affected) and then rescan, set
>>> the XMLTV ID's, then run mythfilldatabase.
>>
>> You've posted this response before.  I can't say I recall anyone
>> agreeing that this is the best approach.  There's too much collateral
>> damage.
>
>
> No, there's none

We went over this before.

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

Just because you don't care about this kind of damage doesn't mean it
isn't there.

It's clear that neither one of us has changed our opinions since last
May.  I'm not going to get into this one again (any more than I
already have).

Eric