<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On 23/05/2010, at 1:02 PM, Hadley Rich wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>On Sun, 2010-05-23 at 12:11 +1200, Steven Ellis wrote:<br><blockquote type="cite">These IDs are supposed to come from DataDirect, but something else<br></blockquote><blockquote type="cite">must also be populating them.<br></blockquote><br>I believe mythfilldatabase creates them for XMLTV data which includes<br>season/episode. I'm using the data from <a href="http://nzepg.org">nzepg.org</a> which includes some of<br>this data and see generated programids. They are EP... rather than MV...<br>though.<br><br><blockquote type="cite">A scan of my database shows I've got over 1400 entries in my Program<br></blockquote><blockquote type="cite">table with a programid starting MV, including shows like The Pacific,<br></blockquote><blockquote type="cite">30 Rock etc. This really isn't good. <br></blockquote><br>I've put some SQL at the bottom of this mail showing stats from my<br>database. From <a href="http://nzepg.org">nzepg.org</a> data.<br><br><blockquote type="cite">I'm also wondering if Jamu is in some way involved? <br></blockquote><br>I don't think so as I use it to, though like I said I don't know much<br>about Jamu.<br><br>Perhaps one of the epgsnoop processors is adding spurious movie category<br>tags for some reason.<br><br>hads<br><br>mysql> SELECT name, title FROM program INNER JOIN channel ON<br>program.chanid = channel.chanid WHERE programid LIKE 'MV%' AND xmltvid<br>IN ('tv1.freeviewnz.tv', 'tv2.freeviewnz.tv', 'tv3.freeviewnz.tv');<br><br></div></blockquote><br></div><div>From the looks of things I've got entries with bad programid values in the following tables</div><div>- program</div><div>- oldprogram</div><div>- recorded</div><div>- oldrecorded</div><div><br></div><div>I'm generating my own EPG data so there shouldn't be any programid values getting pulled in from anywhere else so I'm really rather puzzled, unless I have a rogue source configured for EIT data somewhere.</div><div><br></div><div>Anyway I've cleared the programid values for all non-movies and hopefully the EPG will now start behaving correctly again.</div><div><br></div><div><br></div><div>Steve</div><div><br></div><div><br></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div>Steven Ellis - Technical Director<br>OpenMedia Limited<br>email - <a href="mailto:steven@openmedia.co.nz">steven@openmedia.co.nz</a><br>website - <a href="http://www.openmedia.co.nz/">http://www.openmedia.co.nz</a><br></div></span>
</div>
<br></body></html>