<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Oct 29, 2021 at 10:52 PM Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz">stephen_agent@jsw.gen.nz</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 Fri, 29 Oct 2021 21:49:29 -0400, you wrote:<br>
<br>
>On Fri, Oct 29, 2021 at 9:37 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>> wrote:<br>
><br>
>> On 10/29/21 4:04 PM, Daryl McDonald wrote:<br>
>> ><br>
>> ><br>
>> > On Fri, Oct 29, 2021 at 3:51 PM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a> <mailto:<br>
>> <a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>>> wrote:<br>
>> ><br>
>> > On 10/29/21 2:44 PM, Daryl McDonald wrote:<br>
>> > ><br>
>> > ><br>
>> > > On Fri, Oct 29, 2021 at 6:14 AM Paul Harrison <<a href="mailto:mythtv@mythqml.net" target="_blank">mythtv@mythqml.net</a><br>
>> <mailto:<a href="mailto:mythtv@mythqml.net" target="_blank">mythtv@mythqml.net</a>> <mailto:<a href="mailto:mythtv@mythqml.net" target="_blank">mythtv@mythqml.net</a><br>
>> > <mailto:<a href="mailto:mythtv@mythqml.net" target="_blank">mythtv@mythqml.net</a>>>> wrote:<br>
>> > ><br>
>> > > On 28/10/2021 23:50, Daryl McDonald wrote:<br>
>> > ><br>
>> > >><br>
>> > >><br>
>> > >> On Thu, Oct 28, 2021 at 5:09 PM Bill Meek <<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>> <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/28/21 4:03 PM, Daryl McDonald wrote:<br>
>> > >> > I just upgraded and nothing for myth or mysql that I saw<br>
>> > >><br>
>> > >> It usually takes a day or so. Look in your backend log to<br>
>> see if<br>
>> > >> the same error is still there. If you see: BIGINT, for<br>
>> example,<br>
>> > >> that's a clue.<br>
>> > >><br>
>> > >> --<br>
>> > >> Bill<br>
>> > >> _______________________________________________<br>
>> > >><br>
>> > >> OK, practicing patience here. Thanks, again.<br>
>> > >><br>
>> > >><br>
>> > ><br>
>> > > For any Ubuntu users using the PPA's both mythbuntu/31<br>
>> (fixes/31) and mythbuntu/32 (master) have now been updated with the fix.<br>
>> > ><br>
>> > ><br>
>> > > Paul H.<br>
>> > ><br>
>> > > I got the updates this morning, but still no recordings being<br>
>> scheduled. When might things get back to functional?<br>
>> ><br>
>> > When you try to schedule a new recording, look in the backend log.<br>
>> Is the same SQL error<br>
>> > message there?<br>
>> ><br>
>> > Look for this:<br>
>> ><br>
>> > BIGINT UNSIGNED value is out of range in<br>
>> '((`mythconverg`.`c`.`recpriority` +<br>
>> `mythconverg`.`capturecard`.`recpriority`) +<br>
>> > ((`mythconverg`.`capturecard`.`cardid` =<br>
>> `mythconverg`.`sched_temp_record`.`prefinput`) * 2))'<br>
>> ><br>
>> > It's issue fixed for me and others reporting on the Forum.<br>
>> ><br>
>> > --<br>
>> > Bill<br>
>> > __<br>
>> ><br>
>> > There seems to be some kind of dberror, here is a short log from the<br>
>> backend :<br>
>> ><br>
>> > <a href="https://paste.ubuntu.com/p/VBVtxZJzPK/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/VBVtxZJzPK/</a> <<br>
>> <a href="https://paste.ubuntu.com/p/VBVtxZJzPK/" rel="noreferrer" target="_blank">https://paste.ubuntu.com/p/VBVtxZJzPK/</a>><br>
>><br>
>> Any Custom Priority rules:<br>
>><br>
>> mysql --user=mythtv --password --host=localhost --execute="SELECT * FROM<br>
>> powerpriority,powerpriority_tmp" mythconverg<br>
>><br>
>> --<br>
>> Bill<br>
>><br>
>><br>
> daryl@trieli:~$ mysql --user=mythtv --password --host=localhost<br>
>--execute="SELECT * FROM powerpriority,powerpriority_tmp" mythconverg<br>
>Enter password:<br>
>+--------------+-------------+---------------------------------------+--------------+-------------+---------------------------------------+<br>
>| priorityname | recpriority | selectclause |<br>
>priorityname | recpriority | selectclause |<br>
>+--------------+-------------+---------------------------------------+--------------+-------------+---------------------------------------+<br>
>| CBSnotADP#0 | -50 | channel.mplexid=6 and cardid in (1,5) |<br>
>CBSnotADP#0 | -50 | channel.mplexid=6 and cardid in (1,5) |<br>
>+--------------+-------------+---------------------------------------+--------------+-------------+---------------------------------------+<br>
>daryl@trieli:~$<br>
><br>
>Stephen and I just put this one in due to a less sensitive tuner card<br>
<br>
It might be an idea to reverse that rule - add 50 when the opposite of<br>
the condition applies:<br>
<br>
update powerpriority set<br>
recpriority=50,selectclause='channel.mplexid!=6 or cardid not in<br>
(1,5)' where priorityname='CBSnotADP#0';<br>
<br>
(or change it via mythfrontend).<br>
<br>
That should have the same effect without causing negative priorities.<br><br></blockquote><div> mysql> recpriority=50,selectclause='channel.mplexid!=6 or cardid not in (1,5)' where priorityname='CBSnotADP#0';</div>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'recpriority=50,selectclause='channel.mplexid!=6 or cardid not in (1,5)' where pr' at line 1<br>mysql> </div></div>