[mythtv-users] DB Error inserting into recordmatch

Mon, 13 Jun 2005 19:05:33 -0700

Hi all,
 
Don't know where to post this, so I'll start here.  I'm running the latest mythtv from cvs (as of yesterday) and I'm getting an error in the mythbackend log.  Not sure if it is impacting anything (I haven't noticed a problem, just the log message).
 
<log snippet>

2005-06-13 20:39:12.366 AutoExpire: Found 2 recorders w/max rate of 210 MiB/min
2005-06-13 20:39:12.368 AutoExpire: space: 1.6 GB w/freq: 5 min
2005-06-13 20:39:14.321 Reschedule requested for id -1.
DB Error (UpdateMatches):
Query was:
INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,
IF(search = 5, recordid, 0) FROM record, program The Limo INNER JOIN channel ON ( channel.chanid = program.chanid) WHERE reco
rd.recordid = 104 AND program.manualid = 0 AND ( Jerry and George commandeer a limousine headed for a neo-Nazi rally. ) AND
((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10)  OR  ((record.station = channel.callsign)   AND
   ((record.type = 3)    OR   ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime))     AND     ((record.type =
2)      OR     ((DAYOFWEEK( record.startdate) = DAYOFWEEK(program.starttime)       AND       ((record.type = 5)        OR
   ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         AND         (TIME_TO_SEC(record.endtime) = TIME_TO_SEC(
program.endtime))         AND         (TO_DAYS(record.enddate) = TO_DAYS(program.endtime))         )       )      )     )
 )   )  ) ))
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax near 'Limo INNER JOIN channel ON (channel.chanid = program.chanid) WHERE record.record'
 at line 1

2005-06-13 20:39:21.263 Scheduled 335 items in 6.9 = 6.37 match + 0.57 place
2005-06-13 20:39:21.269 scheduler: Scheduled items
2005-06-13 20:39:21.274 Seem to be woken up by USER
2005-06-13 20:39:22.323 mythbackend: Running housekeeping thread
<snippet end>

Not sure what to do with this.  Since this looks like a Seinfeld episode, I've checked my recordings and I don't have one and I don't have a Seinfeld episode in my upcoming recordings.  Is this just junk?  Anyone know what I should do to delete the bad record(s) (assuming that is what is causing the problem)?
 
Thanks,
phlepper
--
I hear and I forget. I see and I remember. I do and I understand.  --  Confucius 
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Reply via email to