[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