<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On Jan 17, 2024, at 6:44 PM, Tom Dexter <digitalaudiorock@gmail.com> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">On Wed, Jan 17, 2024 at 6:03 PM Mike Perkins</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;"><</span><a href="mailto:mikep@randomtraveller.org.uk" style="font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">mikep@randomtraveller.org.uk</a><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">> wrote:</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><blockquote type="cite" style="font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br>On 17/01/2024 21:55, Jay Harbeston wrote:<br><blockquote type="cite"><br><br><blockquote type="cite">On Jan 17, 2024, at 4:38 PM, Tom Dexter <digitalaudiorock@gmail.com> wrote:<br><br>On Sun, Jan 14, 2024 at 2:21 PM Jay Harbeston <jharbestonus@gmail.com> wrote:<br><blockquote type="cite"><br>Up to 2020, I used the sqlite version, and switched to the non-sqlite version … I think it maybe have been related to when HDHR was doing a ‘cable’ subsrciption thing in 2018 or so and then switched away in 2020.<br><br>Since my last email I have switched back to using the sqlite version and am getting good data now.<br><br>Sounds Kinda like the non-sqlite version might be fading from use anyway, so now I am converted, and I have confirmed that the S/E data is populating correctly!<br><br>Thanks all for the assistance!<br><br><br>I did take a look at the perl program for non-sqlite.. and decided I would stay away from the dragons in it as I haven’t touched perl in at least 15 years! :-)<br><br>Regards!<br></blockquote><br>I've just recently started noticing the same missing seasons and<br>episodes. I've never used anything except for the non-sqlite version.<br><br>I suppose I may have to change to that sqlite one. On the whole,<br>Schedules Direct seems to do a good job, but on occasion they do some<br>really questionable stuff. There was that bizarre thing they did some<br>time back where they apparently replaced their backend stuff with some<br>new python version, which totally broke a lot of stuff. They ended up<br>having to roll that back, and I've never heard anything about it<br>since. It all makes me wonder what they might have done here.<br><br>Tom<br></blockquote><br>It wasn’t hard to switch, as I didn’t have to change any of the channels except for changing the number of the source id in channels to the new number for the new sqlite grabber.<br><br>Alternatively, you will need to do as Gary suggested and do an issue request to the xmltv group for the problem.<br><br><br>I took the path of least resistance and switched to the sqlite version. :-)<br><br></blockquote>Why did you have to change the source id in channels? Surely all that was needed was to go to the<br>source and change the grabber?<br><br>--<br><br>Mike Perkins<br><br></blockquote><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">I think he's referring to the xmltvids on the channel table. The</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">non-sqlite grabber requires just the numeric id but the sqlite version</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">requires them to be in the form<span class="Apple-converted-space"> </span></span><a href="http://innnnn.json.schedulesdirect.org/" style="font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">Innnnn.json.schedulesdirect.org</a><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">.</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">Jay: Correct me if I'm wrong on that. I was actually going to reply to</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">verify that that needs to be changed.</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">Tom</span><br style="caret-color: rgb(0, 0, 0); font-family: Palatino-Roman; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"></div></blockquote><br></div><div><br></div><div>Actually the sourced field in the channel table points to the video source table with information on the data source to use(such as schedules direct). When I moved to the sqlite version, a new video source is added, and hence the source id had to change in the channel table. In my case, the old nonsqlite version had sourceid of 4 and after the sqlite version was added, the source id for it was now 6. So updated the channel table to reflect the change.</div><div>NOTE that this change could be made in the backend setup(either the original mythtv-setup, or the new web version).</div><div>For almost 40 channels, this is a pain to do, so I went ‘under the hood/ and modded the channel table using sql.</div><div><br></div><div>The xmltv ids did not have to be modified as they are the same for both non sqlite and sqlite versions as far as I can tell, and everything was working fine after the change.</div><div><br></div><div>Regards!</div><br></body></html>