<div dir="ltr">Thanks Bill, halfway there, I was able to neutralize the priority factor on two of the four that showed from the query. The other two do not show up in frontend settings because I deleted those channels. How would I go about making that change from mysql?</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 27, 2021 at 9:30 PM Bill Meek <<a href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 10/27/21 6:01 AM, Daryl McDonald wrote:<br>
> <br>
> <br>
> On Wed, Oct 27, 2021 at 6:43 AM Daryl McDonald <<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>>> wrote:<br>
> <br>
> <br>
> <br>
> On Tue, Oct 26, 2021 at 10:48 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>>> wrote:<br>
> <br>
> On 10/26/21 1:28 PM, Daryl McDonald wrote:<br>
> ><br>
> ><br>
> > On Tue, Oct 26, 2021 at 2:22 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a><br>
> <mailto:<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>>>> wrote:<br>
> ><br>
> > On 10/26/21 11:40 AM, Daryl McDonald wrote:<br>
> > ><br>
> > ><br>
> > > On Tue, Oct 26, 2021 at 12:34 PM Daryl McDonald <<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>><br>
> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>>> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>><br>
> > <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>>>>> wrote:<br>
> > ><br>
> > > I update and upgrade regularly<br>
> > ><br>
> > > On Tue, Oct 26, 2021 at 8:59 AM Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a> <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>><br>
> <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a> <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>>><br>
> > <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a> <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a><br>
> <mailto:<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>>>>> wrote:<br>
> > ><br>
> > > On Tue, 26 Oct 2021 07:45:34 -0500, you wrote:<br>
> > ><br>
> > > >I don't know if this is your issue, but there is a know problem with<br>
> > > >recordings caused by a database software change:<br>
> > > ><a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a>><br>
> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a>>><br>
> > <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a>><br>
> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4453" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4453</a>>>><br>
> > > ><br>
> > ><br>
> > > That problem was fixed a while ago, but only if you keep your system<br>
> > > and MythTV up to date.<br>
> > ><br>
> > ><br>
> > > It's different than that, when I look in upcoming recordings, it says "you have not scheduled any recordings" when I look in<br>
> recording rules I<br>
> > > can see them all, when I look in info I see 49 rules and two templates. when I try to schedule a recording from the grid all the<br>
> correct<br>
> > things<br>
> > > show until I hit enter, then no icon on the show that it will record. I can go through the motions but the system will not take<br>
> a new<br>
> > recording.<br>
> > > Maybe the scheduler is broken?<br>
> > Can you watch LiveTV, proving that one or more of your tuners<br>
> > are available?<br>
> ><br>
> > Yes I can watch live TV <br>
> ><br>
> ><br>
> > This may help: mythbackend --printsched (put the output at <a href="http://pastebin.com" rel="noreferrer" target="_blank">pastebin.com</a> <<a href="http://pastebin.com" rel="noreferrer" target="_blank">http://pastebin.com</a>> <<a href="http://pastebin.com" rel="noreferrer" target="_blank">http://pastebin.com</a><br>
> <<a href="http://pastebin.com" rel="noreferrer" target="_blank">http://pastebin.com</a>>> please,<br>
> > it can be long).<br>
> ><br>
> > <a href="https://paste.ubuntu.com/p/zXTnrd9swf/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/zXTnrd9swf/</a> <<a href="https://paste.ubuntu.com/p/zXTnrd9swf/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/zXTnrd9swf/</a>> <<a href="https://paste.ubuntu.com/p/zXTnrd9swf/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/zXTnrd9swf/</a><br>
> <<a href="https://paste.ubuntu.com/p/zXTnrd9swf/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/zXTnrd9swf/</a>>><br>
> ><br>
> ><br>
> > IF the above don't show any clues:<br>
> ><br>
> > curl --header Accept:application/json --silent localhost:6544/Dvr/GetRecordScheduleList | jsonlint --format --nonstrict<br>
> ><br>
> > You'll probably need to do: sudo apt install jsonlint python3-demjson<br>
> > first. Also needs to go in a pastebin.<br>
> ><br>
> > <a href="https://paste.ubuntu.com/p/cGJMVRrPMH/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/cGJMVRrPMH/</a> <<a href="https://paste.ubuntu.com/p/cGJMVRrPMH/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/cGJMVRrPMH/</a>> <<a href="https://paste.ubuntu.com/p/cGJMVRrPMH/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/cGJMVRrPMH/</a><br>
> <<a href="https://paste.ubuntu.com/p/cGJMVRrPMH/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/cGJMVRrPMH/</a>>><br>
> <br>
> <a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776</a> <<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776</a>><br>
> <br>
> If you just posted on the forum, can you do these two queries:<br>
> <br>
> It was not I <br>
> <br>
> <br>
> SELECT cardid,recpriority FROM capturecard WHERE recpriority != 0 ORDER BY cardid;<br>
> <br>
> SELECT chanid,recpriority FROM channel WHERE recpriority != 0 ORDER BY chanid;<br>
> <br>
> If that wasn't you, a fresh backend log may help. Not the entire file, just from<br>
> the last line that contains: mythbackend version: master [v31<br>
> <br>
> I don't know how to post a log from a certain point, and shortlog only goes back to the 27th whereas my system worked on the 24th but not<br>
> the 25th. so here is a short log:<br>
> <a href="https://paste.ubuntu.com/p/swcPMBg6Rd/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/swcPMBg6Rd/</a> <<a href="https://paste.ubuntu.com/p/swcPMBg6Rd/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/swcPMBg6Rd/</a>><br>
> and here is a log from the 24th on:<br>
> <br>
> It might be the same situation though:<br>
> <br>
> <br>
> mysql> SELECT cardid,recpriority FROM capturecard WHERE recpriority != 0 ORDER BY cardid;<br>
> Empty set (0.00 sec)<br>
> <br>
> mysql> SELECT cardid,recpriority FROM capturecard WHERE recpriority != 0 ORDER BY cardid;<br>
> Empty set (0.00 sec)<br>
> <br>
> mysql> SELECT chanid,recpriority FROM channel WHERE recpriority != 0 ORDER BY chanid;<br>
> +--------+-------------+<br>
> | chanid | recpriority |<br>
> +--------+-------------+<br>
> | 1061 | -3 |<br>
> | 1161 | -2 |<br>
> | 1171 | -1 |<br>
> | 1301 | -5 |<br>
> +--------+-------------+<br>
> 4 rows in set (0.00 sec)<br>
<br>
You can follow this on: <a href="https://forum.mythtv.org/viewtopic.php?f=36&t=4628" rel="noreferrer" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=4628</a><br>
<br>
You'll see that a single negative recpriority will cause the SQL error pasted<br>
earlier. The issue is still open<br>
<br>
-- <br>
Bill<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>