[mythtv-users] DB Error inserting into recordmatch

Paul Leppert phlepper at gmail.com
Tue Jun 14 02:05:04 UTC 2005


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050613/4139309f/attachment.htm


More information about the mythtv-users mailing list