[mythtv-users] Upcoming recordings gone

Bill Meek keemllib at gmail.com
Thu Oct 28 01:30:23 UTC 2021


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>> wrote:
> 
> 
> 
>     On Tue, Oct 26, 2021 at 10:48 PM Bill Meek <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>>> 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>>>> 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>>>> 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>>>
>         >     >         >
>         >     >
>         >     >         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>> 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/>>
>         >
>         >
>         >     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://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/>
>     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

You'll see that a single negative recpriority will cause the SQL error pasted
earlier. The issue is still open

-- 
Bill


More information about the mythtv-users mailing list