[mythtv-users] Duplicate Channels Cleanup

[Michael T. Dean]

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.  Then again, if 
you mean that you're using Dish Network as a source of video, you're not 
scanning, so you may have duplicates from when they renumbered their 
channels and you didn't update properly (by either manually editing the 
XMLTV ID, name, and call sign of the changed channels or by "Delete all 
video sources" and re-fetching).  If you are using a non-scannable video 
source, "Delete all video sources" and then re-fetch channels from 
listings provider.

Mike