[mythtv-users] MySQL DB error

[Elliott Rezny]

When i try to record a program just using the R button while watching 
TV, it says it is recording, and then the console spits out this error 
message:

QDateTime::fromString: Parameter out of range
DB Error (ProgramList::FromProgram):
Query was:
SELECT program.chanid, program.starttime, program.endtime,     
program.title, program.subtitle, program.description,     
program.category, channel.channum, channel.callsign,     channel.name, 
program.previouslyshown, channel.commfree,     channel.outputfilters, 
program.seriesid, program.programid,     program.airdate, program.stars, 
program.originalairdate,     program.category_type FROM program LEFT 
JOIN channel ON program.chanid = channel.chanid WHERE program.chanid =  
AND starttime <  AND     endtime >   GROUP BY program.starttime, 
channel.channum,   channel.callsign, program.title ORDER BY 
program.starttime, channum + 0 LIMIT 1000
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near 'AND starttime

It then doesnt seem to record. Also, when i try to set a show to record 
while using the program guide, it doesnt seem to save the recording 
settings when i select save. the program then doesnt show up in the 
recording schedule or anything. It seems to me that it had worked 
before, but i was having audio problems at the time, so I wasnt focused 
on much except getting the audio to work.

Any help would be appreciated.
Thanks

Elliott Rezny