<div>Hi all,</div>
<div> </div>
<div>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).
</div>
<div> </div>
<div><log snippet></div>
<div>
<p>2005-06-13 20:39:12.366 AutoExpire: Found 2 recorders w/max rate of 210 MiB/min<br>2005-06-13 20:39:12.368 AutoExpire: space: 1.6 GB w/freq: 5 min<br>2005-06-13 20:39:14.321 Reschedule requested for id -1.<br>DB Error (UpdateMatches):
<br>Query was:<br>INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,<br>IF(search = 5, recordid, 0) FROM record, program The Limo INNER JOIN channel ON (
channel.chanid = program.chanid) WHERE reco<br>rd.recordid = 104 AND program.manualid = 0 AND ( Jerry and George commandeer a limousine headed for a neo-Nazi rally. ) AND<br>((record.type = 4 OR record.type = 6 OR record.type
= 9 OR record.type = 10) OR ((record.station = channel.callsign) AND<br> ((record.type = 3) OR ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime)) AND ((record.type =<br>2) OR ((DAYOFWEEK(
record.startdate) = DAYOFWEEK(program.starttime) AND ((record.type = 5) OR<br> ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime)) AND (TIME_TO_SEC(record.endtime) = TIME_TO_SEC(
<br>program.endtime)) AND (TO_DAYS(record.enddate) = TO_DAYS(program.endtime)) ) ) ) )<br> ) ) ) ))<br>Driver error was [2/1064]:<br>QMYSQL3: Unable to execute query<br>Database error was:
<br>You have an error in your SQL syntax near 'Limo INNER JOIN channel ON (channel.chanid = program.chanid) WHERE record.record'<br> at line 1</p>
<p>2005-06-13 20:39:21.263 Scheduled 335 items in 6.9 = 6.37 match + 0.57 place<br>2005-06-13 20:39:21.269 scheduler: Scheduled items<br>2005-06-13 20:39:21.274 Seem to be woken up by USER<br>2005-06-13 20:39:22.323 mythbackend: Running housekeeping thread
<br><snippet end></p></div>
<div>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)?
</div>
<div> </div>
<div>Thanks,</div>
<div>phlepper</div>
<div>-- <br>I hear and I forget. I see and I remember. I do and I understand. -- Confucius </div>