[mythtv] MySQL errors with today's CVS

Eric A. Litman elitman at yahoo.com
Fri Aug 27 22:23:11 EDT 2004


FYI, I'm seeing lots of these in my frontend log today:

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.stars, 
program.originalairdate FROM program LEFT JOIN channel ON program.chanid = 
channel.chanid WHERE program.chanid = 1379 AND starttime <  AND     endtime 
 >   GROUP BY program.starttime, channel.channum,   channel.callsign 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     endtime 
 >   GROUP BY program.starttime, channel.channum

QTime::setHMS Invalid time 30:00:00.000
QDate::setYMD: Invalid date 2004-82-22
QTime::setHMS Invalid time 30:00:00.000
QDate::setYMD: Invalid date 2004-82-22
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.stars, 
program.originalairdate FROM program LEFT JOIN channel ON program.chanid = 
channel.chanid WHERE program.chanid = 1378 AND starttime <  AND     endtime 
 >   GROUP BY program.starttime, channel.channum,   channel.callsign 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     endtime 
 >   GROUP BY program.starttime, channel.channum

QTime::setHMS Invalid time 30:00:00.000
QDate::setYMD: Invalid date 2004-82-22
QTime::setHMS Invalid time 30:00:00.000
QDate::setYMD: Invalid date 2004-82-22
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.stars, 
program.originalairdate FROM program LEFT JOIN channel ON program.chanid = 
channel.chanid WHERE program.chanid = 1365 AND starttime <  AND     endtime 
 >   GROUP BY program.starttime, channel.channum,   channel.callsign 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     endtime 
 >   GROUP BY program.starttime, channel.channum



More information about the mythtv-dev mailing list