[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