<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 09/15/2014 06:50 PM, Eric Sharkey
wrote:<br>
</div>
<blockquote
cite="mid:CAC73aR2E-6zonzamTDnLptd-GOCL6_0B3E13uK=FPdH6ZhsReA@mail.gmail.com"
type="cite">
<pre wrap="">On Mon, Sep 15, 2014 at 6:18 PM, Michael T. Dean
<a class="moz-txt-link-rfc2396E" href="mailto:mtdean@thirdcontact.com"><mtdean@thirdcontact.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 09/15/2014 02:38 PM, Eric Sharkey wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Mon, Sep 15, 2014 at 11:37 AM, Michael T. Dean wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
On 09/15/2014 10:25 AM, Martin Compton wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
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?
</pre>
</blockquote>
<pre wrap="">
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.
</pre>
</blockquote>
<pre wrap="">
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.
</pre>
</blockquote>
<pre wrap="">
No, there's none
</pre>
</blockquote>
<pre wrap="">
We went over this before.
<a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/users/570123#570123">http://www.gossamer-threads.com/lists/mythtv/users/570123#570123</a>
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
</pre>
</blockquote>
<br>
Ha, I didn't find that thread! This would have been handy info:<br>
<blockquote type="cite"><font color="black"
face="Verdana,Arial,Helvetica" size="2"><font color="black"
face="Verdana,Arial,Helvetica" size="2">and allowing
--do-channel-updates <br>
would only be giving it permission to do dangerous things.</font></font></blockquote>
<br>
All is well, though. I just wrote a small script to de-duplicate
the channel table and maintain related "chanid" records.<br>
<br>
Mission accomplished, 40% channel reduction, worth the effort.<br>
<br>
Thank you all for your input.<br>
<br>
MC<br>
</body>
</html>