[mythtv-users] Upcoming Recordings Missing

John jksjdevelop at gmail.com
Wed Oct 27 08:49:39 UTC 2021


On 27/10/2021 04:24, Fred Squires wrote:
> I'm not getting any new recordings today and found that I have no 
> upcoming recordings listed.
> I'm also unable to schedule new recordings. If I try in MythWeb it 
> simply refreshes the page as if I selected no settings.
> My current recordings still exist and play back properly. I have 
> listings, recording schedules and tuners. I can play live TV. I'm 
> currently running Ubuntu 20.04.3 LTS and MythTV 
> v31.0+fixes.202108081239.5da2523154~ubuntu20.04.1
>
> I've restored my database to the backup from the last 2 days which did 
> not help.
>
> I noticed that another person posted a similar problem today. I 
> installed updates today including a "Ubuntu base" update, so maybe 
> something is wrong there.
>
> I see the following error in the mythbackend log:
> Oct 26 23:05:08 mainbe mythbackend: mythbackend[9515]: E Scheduler 
> mythdb.cpp:181 (DBError) DB Error (AddNewRecords):#012Query 
> was:#012SELECT     c.chanid, c.sourceid,           p.starttime,       
>     p.endtime,  p.title,              p.subtitle,           
>  p.description,  c.channum,            c.callsign, c.name 
> <http://c.name>,       oldrecduplicate,      p.category, 
>  sched_temp_record.recpriority, sched_temp_record.dupin, recduplicate, 
>          findduplicate,  sched_temp_record.type,       
>  sched_temp_record.recordid,   p.starttime - INTERVAL 
> sched_temp_record.startoffset minute AS recstartts,     p.endtime + 
> INTERVAL sched_temp_record.endoffset     minute AS recendts,           
>                         p.previouslyshown, sched_temp_record.recgroup, 
> sched_temp_record.dupmethod,  c.commmethod,         
>  capturecard.cardid, 0,  p.seriesid,          p.programid, 
> sched_temp_record.inetref,    p.category_type, p.airdate,         
> p.stars,             p.originalairdate, sched_temp_record.inactive, 
> sched_temp_record.parentid, recordmatch.findid,     
> sched_temp_record.playgroup, oldrecstatus.recstatus,     
> oldrecstatus.reactivate, p.videoprop+0,         p.subtitletypes+0, 
> p.audioprop+0, sched_temp_record.storagegroup,     
> capturecard.hostname, recordmatch.oldrecstatus, NULL,     
> oldrecstatus.future, capturecard.schedorder,     
> p.syndicatedepisodenumber, p.partnumber, p.parttotal,     c.mplexid, 
> capturecard.displayname,             p.season, p.episode, 
> p.totalepisodes, c.recpriority + capturecard.recpriority + 
> (capturecard.cardid = sched_temp_record.prefinput) * 2 + (p.hdtv > 0 
> OR FIND_IN_SET('HDTV', p.videoprop) > 0) * 1 AS powerpriority FROM 
> recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = 
> sched_temp_record.recordid) INNER JOIN program AS p ON ( 
> recordmatch.chanid    = p.chanid    AND      recordmatch.starttime = 
> p.starttime AND  recordmatch.manualid  = p.manualid ) INNER JOIN 
> channel AS c O
>
> Does anyone have any thoughts?
> Thanks!
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

I see mysql client changed on the 25 th you could try reverting it 
libmysqlclient21:amd64 (8.0.26-0ubuntu0.20.04.3, 8.0.27-0ubuntu0.20.04.1),

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20211027/437537bd/attachment.htm>


More information about the mythtv-users mailing list