2006-09-19 03:28:22.692 DB Error (AddNewRecords):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime, program.endtime, program.title, program.subtitle, program.description, c
hannel.channum, channel.callsign, channel.name, oldrecorded.endtime IS NOT NULL AS oldrecduplicate, program.category, record.recpriority, rec
ord.dupin, recorded.endtime IS NOT NULL AS recduplicate, oldfind.findid IS NOT NULL AS findduplicate, record.type, record.recordid, program.s
tarttime - INTERVAL record.startoffset minute AS recstartts, program.endtime + INTERVAL record.endoffset minute AS recendts, program.previous
lyshown, record.recgroup, record.dupmethod, channel.commfree, capturecard.cardid, cardinput.cardinputid, UPPER(cardinput.shareable) = 'Y' AS
shareable, program.seriesid, program.programid, program.category_type, program.airdate, program.stars, program.originalairdate, record.inacti
ve, record.parentid, (CASE record.type   WHEN 6    THEN record.findid   WHEN 9    THEN to_days(date_sub(program.starttime, interval
       time_format(record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN floor((to_days(date_sub(program.starttime, interval
   time_format(record.findtime, '%H:%i') hour_minute)) -                record.findday)/7) * 7 + record.findday   WHEN 7    THEN record.findi
d   ELSE 0  END) , record.playgroup, oldrecstatus.recstatus, oldrecstatus.reactivate, channel.recpriority + cardinput.recpriority, record.pre
finput, program.hdtv, program.closecaptioned, program.first, program.last, program.stereo FROM recordmatch  INNER JOIN record ON (recordmatch
.recordid = record.recordid)  INNER JOIN program ON (recordmatch.chanid = program.chanid AND                         recordmatch.starttime =
program.starttime AND                         recordmatch.manualid = program.manualid)  INNER JOIN channel ON (channel.chanid = program.chani
d)  INNER JOIN cardinput ON (channel.sourceid = cardinput.sourceid)  INNER JOIN capturecard ON (capturecard.cardid = cardinput.cardid)  LEFT
JOIN oldrecorded as oldrecstatus ON   ( oldrecstatus.station = channel.callsign AND     oldrecstatus.starttime = program.starttime AND     ol
drecstatus.title = program.title )  LEFT JOIN oldrecorded ON   (     record.dupmethod > 1 AND     oldrecorded.duplicate <> 0 AND     program.
title = oldrecorded.title      AND      (       (program.programid <> '' AND program.generic = 0        AND program.programid = oldrecorded.p
rogramid)       OR       (oldrecorded.findid <> 0 AND         oldrecorded.findid = (CASE record.type   WHEN 6    THEN record.findid   WHEN 9
   THEN to_days(date_sub(program.starttime, interval                 time_format(record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN fl
oor((to_days(date_sub(program.starttime, interval                time_format(record.findtime, '%H:%i') hour_minute)) -                record.
findday)/7) * 7 + record.findday   WHEN 7    THEN record.findid   ELSE 0  END) )       OR       (        program.generic = 0        AND
  (program.programid = '' OR oldrecorded.programid = '')        AND        (((record.dupmethod & 0x02) = 0) OR (program.subtitle <> ''
    AND program.subtitle = oldrecorded.subtitle))        AND        (((record.dupmethod & 0x04) = 0) OR (program.description <> ''
AND program.description = oldrecorded.description))       )      )   )  LEFT JOIN recorded ON   (     record.dupmethod > 1 AND     recorded.d
uplicate <> 0 AND     program.title = recorded.title AND     recorded.recgroup <> 'LiveTV'      AND      (       (program.programid <> '' AND
 program.generic = 0        AND program.programid = recorded.programid)       OR       (recorded.findid <> 0 AND         recorded.findid = (C
ASE record.type   WHEN 6    THEN record.findid   WHEN 9    THEN to_days(date_sub(program.starttime, interval                 time_format(reco
rd.findtime, '%H:%i') hour_minute))   WHEN 10    THEN floor((to_days(date_sub(program.starttime, interval                time_format(record.f
indtime, '%H:%i') hour_minute)) -                record.findday)/7) * 7 + record.findday   WHEN 7    THEN record.findid   ELSE 0  END) )
  OR       (        program.generic = 0        AND        (program.programid = '' OR recorded.programid = '')        AND        (((record.dup
method & 0x02) = 0) OR (program.subtitle <> ''           AND program.subtitle = recorded.subtitle))        AND        (((record.dupmethod & 0
x04) = 0) OR (program.description <> ''           AND program.description = recorded.description))       )      )   )  LEFT JOIN oldfind ON
 (oldfind.recordid = recordmatch.recordid AND    oldfind.findid = (CASE record.type   WHEN 6    THEN record.findid   WHEN 9    THEN to_days(d
ate_sub(program.starttime, interval                 time_format(record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN floor((to_days(date
_sub(program.starttime, interval                time_format(record.findtime, '%H:%i') hour_minute)) -                record.findday)/7) * 7 +
 record.findday   WHEN 7    THEN record.findid   ELSE 0  END) )  ORDER BY record.recordid DESC
Driver error was [2/1030]:
QMYSQL3: Unable to execute query
Database error was:
Got error 28 from table handler

2006-09-19 03:28:22.721 Scheduled 4 items in 64.1 = 3.28 match + 60.79 place