<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Sep 15, 2014 at 10:14 AM, Martin Compton <span dir="ltr"><<a href="mailto:martinc@itrans.com" target="_blank">martinc@itrans.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><div><div class="h5">
<div>On 09/15/2014 10:58 AM, Joseph Fry
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);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+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>
</div>
</div>
</blockquote></div></div>
Michael: no scanning, all data direct. No manual modifications
until after mythfilldatabase updated the channels in unexpected ways
(deletion, and reassigning channum, having the effect of deleting
the channel, even though it is in the SD lineup), that's when I
noticed the duplicates.<br>
<br>
Won't the "Delete All Video Sources" re-fetch process cause me to
lose my recording history?<br></div></blockquote><div><br></div><div>It will cause you to lose the associated channel information for your recordings, and you'd need to re-create any recording rules which specify "This Channel", but your recording history would otherwise be intact.<br> <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div bgcolor="#FFFFFF" text="#000000">
<br>
Joe, I tried deleting via MythWeb and it did not delete the
channels. I deleted a few others (NBA PayPerView) and they deleted
okay.<br>
<br>
Any reason MythWeb would NOT delete a channel?<br>
</div><br></blockquote></div>Seems like I'm posting this answer a few times a week lately. You need to change your php.ini max_input_vars. See here: <a href="http://www.mythtv.org/pipermail/mythtv-users/2012-February/328610.html">http://www.mythtv.org/pipermail/mythtv-users/2012-February/328610.html</a><br><br></div><div class="gmail_extra">Karl<br></div></div>