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