[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