<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Oct 30, 2021 at 5:34 AM 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 Sat, 30 Oct 2021 10:21:38 +0100, you wrote:<br>
<br>
>On 30/10/2021 09:35, Daryl McDonald wrote:<br>
>> On Fri, Oct 29, 2021 at 10:52 PM Stephen Worthington <<br>
>> <a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:<br>
>> <br>
>>> 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><br>
>>> <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 <<br>
>>> <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 <<br>
>>> <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<br>
>>> saw<br>
>>>>>> >><br>
>>>>>> >> It usually takes a day or so. Look in your backend log<br>
>>> 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 *<br>
>>> 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>
>>>> +--------------+-------------+---------------------------------------+--------------+-------------+---------------------------------------+<br>
>>>> | priorityname | recpriority | selectclause |<br>
>>>> priorityname | recpriority | selectclause |<br>
>>><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>
>>>> +--------------+-------------+---------------------------------------+--------------+-------------+---------------------------------------+<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>
>>> mysql> recpriority=50,selectclause='channel.mplexid!=6 or cardid not in<br>
>> (1,5)' where priorityname='CBSnotADP#0';<br>
>> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual<br>
>> that corresponds to your MySQL server version for the right syntax to use<br>
>> near 'recpriority=50,selectclause='channel.mplexid!=6 or cardid not in<br>
>> (1,5)' where pr' at line 1<br>
>> mysql><br>
>> <br>
>You overlooked the previous line. That command should all read:<br>
><br>
>mysql> update powerpriority set recpriority=50,selectclause='channel.mplexid!=6 or cardid not in<br>
> >> (1,5)' where priorityname='CBSnotADP#0';<br></blockquote><div>OK, I didn't realize. </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
><br>
>(all on one line, of course)<br>
><br>
>That all looks horrible to me and easy to get wrong. I'd do the changes using the front end, <br>
>manually tweaking the rules individually. Of course, that depends on how many rules you have to do.<br>
<br>
There is just the one rule. It adjusts the tuner priorities so that<br>
the two virtual tuners on the physical tuner that has problems<br>
recording from one multiplex are much lower priority for use when that<br>
multiplex is being recorded from. So that multiplex will only be<br>
recorded on the other three tuners.<br>
<br>
Changing the settings from mythfrontend has the problem that<br>
mythfrontend (and all MythTV programs) do not allow pasting of text,<br>
so you have to manually type it in.<br></blockquote><div>What I did do was delete the rule and remove the card from the scheduler's reach. Three tuners is enough for now. Now it occurs to me that I could apply the positive rule to use cardid=2,5 (or 2,3,4,6,7,8). I'll look into all possibilities, thanks again men!</div></div></div>