<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 27/10/2021 04:24, Fred Squires
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAOyAxVVLFccROp4uwHfuEmqQH0NtJaFxQ=oZwANL4QAdA=U1Mw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>I'm not getting any new recordings today and found that I
have no upcoming recordings listed.</div>
<div>I'm also unable to schedule new recordings. If I try in
MythWeb it simply refreshes the page as if I selected no
settings.<br>
</div>
<div>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</div>
<div><br>
</div>
<div>I've restored my database to the backup from the last 2
days which did not help.<br>
</div>
<div><br>
</div>
<div>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.<br>
</div>
<div><br>
</div>
<div>I see the following error in the mythbackend log:</div>
<div>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, <a
href="http://c.name" moz-do-not-send="true">c.name</a>,
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</div>
<div><br>
</div>
<div>Does anyone have any thoughts? <br>
</div>
<div>Thanks!<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p>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),<br>
</p>
</body>
</html>