<br><br><div class="gmail_quote">On Tue, Sep 6, 2011 at 7:20 AM, Brian J. Murrell <span dir="ltr"><<a href="mailto:brian@interlinx.bc.ca">brian@interlinx.bc.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I'm getting the following on master (7768ebc):<br>
<br>
2011-09-06 08:27:42.960333 E [27892/27915] Scheduler mythdb.cpp:192<br>
(DBError) - DB Error (AddNewRecords):<br>
Query was:<br>
SELECT c.chanid, c.sourceid, p.starttime,<br>
p.endtime, p.title,<br>
p.subtitle, p.description, c.channum,<br>
c.callsign, <a href="http://c.name" target="_blank">c.name</a>,<br>
oldrecduplicate, p.category,<br>
sched_temp_record.recpriority, sched_temp_record.dupin, rec<br>
duplicate, findduplicate, sched_temp_record.type,<br>
sched_temp_record.recordid, p.start<br>
time - INTERVAL sched_temp_record.startoffset minute AS recstartts,<br>
p.endtime + INTERVAL sched_temp_<br>
record.endoffset minute AS recendts,<br>
p.previouslyshown,<br>
sched_temp_record.recgroup, sched_temp_record.dupmethod, c.commmethod,<br>
capturecard.cardid, cardinp<br>
ut.cardinputid,p.seriesid, p.programid,<br>
sched_temp_record.inetref, p.category_type,<br>
p.airdate, p.stars, p.originalairdate,<br>
sched_temp_record.inactive, sched_temp_record<br>
.parentid,(CASE sched_temp_record.type WHEN 6 THEN<br>
sched_temp_record.findid WHEN 9 THEN to_days(da<br>
te_sub(p.starttime, interval<br>
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))<br>
WHEN 10 THEN floor((to_days(date_sub(p.starttime, interval<br>
time_format(sched_temp_record<br>
.findtime, '%H:%i') hour_minute)) -<br>
sched_temp_record.findday)/7) * 7 + sched_temp_record.fin<br>
dday WHEN 7 THEN sched_temp_record.findid ELSE 0 END) ,<br>
sched_temp_record.playgroup, oldrecstat<br>
us.recstatus, oldrecstatus.reactivate, p.videoprop+0,<br>
p.subtitletypes+0, p.audioprop+0, sched_<br>
temp_record.storagegroup, capturecard.hostname,<br>
recordmatch.oldrecstatus,<br>
sched_temp_record.avg_delay, oldrecstatus.future,<br>
c.recpriority + cardinput.recpriority + (<br>
cardinput.cardinputid = sched_temp_record.prefinput) *<br>
2011-09-06 08:27:43.415639 I [27892/27915] Scheduler scheduler.cpp:2066<br>
(HandleReschedule) - Scheduled 0 items in 10.0 = 1.66 match + 8.33 place<br>
<br>
Any ideas?<br>
<br>
Cheers,<br>
<font color="#888888">b.<br>
<br>
</font><br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br>Have you tried repairing or optimizing the database? Are their any other errors showing up in your backend logs?<br clear="all"><br>-- <br>Working on World Domination since 2001<br><br>