[mythtv-users] Upcoming recordings gone
Bill Meek
keemllib at gmail.com
Thu Oct 28 15:13:51 UTC 2021
> On Wed, Oct 27, 2021 at 9:30 PM Bill Meek <keemllib at gmail.com <mailto:keemllib at gmail.com>> wrote:
>
> On 10/27/21 6:01 AM, Daryl McDonald wrote:
> >
> >
> > On Wed, Oct 27, 2021 at 6:43 AM Daryl McDonald <darylangela at gmail.com <mailto:darylangela at gmail.com> <mailto:darylangela at gmail.com
> <mailto:darylangela at gmail.com>>> wrote:
> >
> >
> >
> > On Tue, Oct 26, 2021 at 10:48 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/26/21 1:28 PM, Daryl McDonald wrote:
> > >
> > >
> > > On Tue, Oct 26, 2021 at 2:22 PM Bill Meek <keemllib at gmail.com <mailto:keemllib at gmail.com> <mailto:keemllib at gmail.com
> <mailto:keemllib at gmail.com>> <mailto:keemllib at gmail.com <mailto:keemllib at gmail.com>
> > <mailto:keemllib at gmail.com <mailto:keemllib at gmail.com>>>> wrote:
> > >
> > > On 10/26/21 11:40 AM, Daryl McDonald wrote:
> > > >
> > > >
> > > > On Tue, Oct 26, 2021 at 12:34 PM Daryl McDonald <darylangela at gmail.com <mailto:darylangela at gmail.com>
> <mailto:darylangela at gmail.com <mailto:darylangela at gmail.com>>
> > <mailto:darylangela at gmail.com <mailto:darylangela at gmail.com> <mailto:darylangela at gmail.com <mailto:darylangela at gmail.com>>>
> <mailto:darylangela at gmail.com <mailto:darylangela at gmail.com> <mailto:darylangela at gmail.com <mailto:darylangela at gmail.com>>
> > > <mailto:darylangela at gmail.com <mailto:darylangela at gmail.com> <mailto:darylangela at gmail.com
> <mailto:darylangela at gmail.com>>>>> wrote:
> > > >
> > > > I update and upgrade regularly
> > > >
> > > > On Tue, Oct 26, 2021 at 8:59 AM Stephen Worthington <stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz>
> <mailto:stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz>>
> > <mailto:stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz> <mailto:stephen_agent at jsw.gen.nz
> <mailto:stephen_agent at jsw.gen.nz>>>
> > > <mailto:stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz> <mailto:stephen_agent at jsw.gen.nz
> <mailto:stephen_agent at jsw.gen.nz>> <mailto:stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz>
> > <mailto:stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz>>>>> wrote:
> > > >
> > > > On Tue, 26 Oct 2021 07:45:34 -0500, you wrote:
> > > >
> > > > >I don't know if this is your issue, but there is a know problem with
> > > > >recordings caused by a database software change:
> > > > >https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>
> <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>>
> > <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>
> <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>>>
> > > <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>
> <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>>
> > <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>
> <https://forum.mythtv.org/viewtopic.php?f=36&t=4453 <https://forum.mythtv.org/viewtopic.php?f=36&t=4453>>>>
> > > > >
> > > >
> > > > That problem was fixed a while ago, but only if you keep your system
> > > > and MythTV up to date.
> > > >
> > > >
> > > > It's different than that, when I look in upcoming recordings, it says "you have not scheduled any recordings" when I look in
> > recording rules I
> > > > 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
> > correct
> > > things
> > > > 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
> > a new
> > > recording.
> > > > Maybe the scheduler is broken?
> > > Can you watch LiveTV, proving that one or more of your tuners
> > > are available?
> > >
> > > Yes I can watch live TV
> > >
> > >
> > > This may help: mythbackend --printsched (put the output at pastebin.com <http://pastebin.com> <http://pastebin.com
> <http://pastebin.com>> <http://pastebin.com <http://pastebin.com>
> > <http://pastebin.com <http://pastebin.com>>> please,
> > > it can be long).
> > >
> > > https://paste.ubuntu.com/p/zXTnrd9swf/ <https://paste.ubuntu.com/p/zXTnrd9swf/> <https://paste.ubuntu.com/p/zXTnrd9swf/
> <https://paste.ubuntu.com/p/zXTnrd9swf/>> <https://paste.ubuntu.com/p/zXTnrd9swf/ <https://paste.ubuntu.com/p/zXTnrd9swf/>
> > <https://paste.ubuntu.com/p/zXTnrd9swf/ <https://paste.ubuntu.com/p/zXTnrd9swf/>>>
> > >
> > >
> > > IF the above don't show any clues:
> > >
> > > curl --header Accept:application/json --silent localhost:6544/Dvr/GetRecordScheduleList | jsonlint --format --nonstrict
> > >
> > > You'll probably need to do: sudo apt install jsonlint python3-demjson
> > > first. Also needs to go in a pastebin.
> > >
> > > https://paste.ubuntu.com/p/cGJMVRrPMH/ <https://paste.ubuntu.com/p/cGJMVRrPMH/> <https://paste.ubuntu.com/p/cGJMVRrPMH/
> <https://paste.ubuntu.com/p/cGJMVRrPMH/>> <https://paste.ubuntu.com/p/cGJMVRrPMH/ <https://paste.ubuntu.com/p/cGJMVRrPMH/>
> > <https://paste.ubuntu.com/p/cGJMVRrPMH/ <https://paste.ubuntu.com/p/cGJMVRrPMH/>>>
> >
> > https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776
> <https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776> <https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776
> <https://forum.mythtv.org/viewtopic.php?f=36&t=4628&p=22776#p22776>>
> >
> > If you just posted on the forum, can you do these two queries:
> >
> > It was not I
> >
> >
> > SELECT cardid,recpriority FROM capturecard WHERE recpriority != 0 ORDER BY cardid;
> >
> > SELECT chanid,recpriority FROM channel WHERE recpriority != 0 ORDER BY chanid;
> >
> > If that wasn't you, a fresh backend log may help. Not the entire file, just from
> > the last line that contains: mythbackend version: master [v31
> >
> > 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
> > the 25th. so here is a short log:
> > https://paste.ubuntu.com/p/swcPMBg6Rd/ <https://paste.ubuntu.com/p/swcPMBg6Rd/> <https://paste.ubuntu.com/p/swcPMBg6Rd/
> <https://paste.ubuntu.com/p/swcPMBg6Rd/>>
> > and here is a log from the 24th on:
> >
> > It might be the same situation though:
> >
> >
> > mysql> SELECT cardid,recpriority FROM capturecard WHERE recpriority != 0 ORDER BY cardid;
> > Empty set (0.00 sec)
> >
> > mysql> SELECT cardid,recpriority FROM capturecard WHERE recpriority != 0 ORDER BY cardid;
> > Empty set (0.00 sec)
> >
> > mysql> SELECT chanid,recpriority FROM channel WHERE recpriority != 0 ORDER BY chanid;
> > +--------+-------------+
> > | chanid | recpriority |
> > +--------+-------------+
> > | 1061 | -3 |
> > | 1161 | -2 |
> > | 1171 | -1 |
> > | 1301 | -5 |
> > +--------+-------------+
> > 4 rows in set (0.00 sec)
>
> You can follow this on: https://forum.mythtv.org/viewtopic.php?f=36&t=4628 <https://forum.mythtv.org/viewtopic.php?f=36&t=4628>
>
> You'll see that a single negative recpriority will cause the SQL error pasted
> earlier. The issue is still open
On 10/28/21 6:08 AM, Daryl McDonald wrote:
> 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?
This is a safe way, just change the chanid:
mysql --user=mythtv --password --execute="UPDATE channel SET recpriority=0 WHERE chanid=98765 LIMIT 1" mythconverg
--
Bill
More information about the mythtv-users
mailing list