[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