[mythtv-users] Scheduler mythdb.cpp:192 (DBError) - DB Error (AddNewRecords)

Brian J. Murrell brian at interlinx.bc.ca
Tue Sep 6 14:20:25 UTC 2011


I'm getting the following on master (7768ebc):

2011-09-06 08:27:42.960333 E [27892/27915] Scheduler mythdb.cpp:192
(DBError) - DB Error (AddNewRecords):
Query was:
SELECT     c.chanid,         c.sourceid,           p.starttime,
  p.endtime,        p.title,
      p.subtitle,            p.description,    c.channum,
c.callsign,            c.name,
  oldrecduplicate,      p.category,
sched_temp_record.recpriority, sched_temp_record.dupin,   rec
duplicate,          findduplicate,    sched_temp_record.type,
sched_temp_record.recordid,     p.start
time - 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, cardinp
ut.cardinputid,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,(CASE sched_temp_record.type   WHEN 6    THEN
sched_temp_record.findid   WHEN 9    THEN to_days(da
te_sub(p.starttime, interval
time_format(sched_temp_record.findtime, '%H:%i') hour_minute))
  WHEN 10    THEN floor((to_days(date_sub(p.starttime, interval
       time_format(sched_temp_record
.findtime, '%H:%i') hour_minute)) -
sched_temp_record.findday)/7) * 7 + sched_temp_record.fin
dday   WHEN 7    THEN sched_temp_record.findid   ELSE 0  END) ,
sched_temp_record.playgroup, oldrecstat
us.recstatus,     oldrecstatus.reactivate, p.videoprop+0,
p.subtitletypes+0, p.audioprop+0,   sched_
temp_record.storagegroup,     capturecard.hostname,
recordmatch.oldrecstatus,
             sched_temp_record.avg_delay,     oldrecstatus.future,
c.recpriority + cardinput.recpriority + (
cardinput.cardinputid = sched_temp_record.prefinput) *
2011-09-06 08:27:43.415639 I [27892/27915] Scheduler scheduler.cpp:2066
(HandleReschedule) - Scheduled 0 items in 10.0 = 1.66 match + 8.33 place

Any ideas?

Cheers,
b.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
Url : http://www.mythtv.org/pipermail/mythtv-users/attachments/20110906/30b36bab/attachment.bin 


More information about the mythtv-users mailing list