<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I was cleaning up my DISH-TV Schedules Direct listings and ran mythfilldatabase to update the channels.<br>
<br>
When I was checking the channels table I noticed that some have 2-3 duplicate entries for the same sourceid+channel+callsign+<u></u>xmltvid (etc).<br>
<br>
Can I safely reassign the chanid in the associated tables:<br>
channelgroup<br>
program (these duplicates can be deleted)<br>
programgenres<br>
programrating<br>
record<br>
recorded<br>
oldrecorded<br>
<br>
and remove the duplicate channels?<br>
<br>
Am I missing any tables with a "chanid" column?<br>
</blockquote>
<br>
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.<br></blockquote><div><br></div><div>That may be a bit of a bazooka-to-a-knife-fight solution. I would first open MythWeb's settings page and delete the duplicates from the channel table there. Run mythfilldatabase and see if they come back.</div><div><br></div><div><br></div></div></div></div>