[mythtv-users] Help with two database errors?
Fred Hamilton
fred at yonkitime.com
Fri Sep 21 00:17:59 UTC 2012
Can anyone help me understand these database errors? This is the
Mythfrontend output when I try to watch a TV show via my HD-PVR (ATSC
tuner works fine).
Database error was: Unknown column 'recordedmarkup.data' in 'field list'
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 ':CHANID AND recordedmarkup.starttime = :STARTTIME
AND recordedmar' at line 1
I recently upgraded from 10.10 / 0.24 to 12.04 / 0.25. Everything
worked fine under 10.10 / 0.24.
Cheers,
Fred
Full output below:
2012-09-17 22:53:42.204473 E Error preparing query: SELECT
recordedmarkup.data FROM recordedmarkup WHERE recordedmarkup.chanid
= :CHANID AND recordedmarkup.starttime = :STARTTIME AND
recordedmarkup.type = 33 GROUP BY recordedmarkup.data ORDER BY
SUM( ( SELECT IFNULL(rm.mark, recordedmarkup.mark) FROM
recordedmarkup AS rm WHERE rm.chanid =
recordedmarkup.chanid AND rm.starttime =
recordedmarkup.starttime AND rm.type =
recordedmarkup.type AND rm.mark >
recordedmarkup.mark ORDER BY rm.mark ASC LIMIT 1
) - recordedmarkup.mark ) DESC LIMIT 1
2012-09-17 22:53:42.204487 E Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'recordedmarkup.data' in 'field list'
2012-09-17 22:53:42.204662 E DB Error (load_markup_datum):
Query was:
SELECT recordedmarkup.data FROM recordedmarkup WHERE
recordedmarkup.chanid = :CHANID AND
recordedmarkup.starttime = :STARTTIME AND recordedmarkup.type
= 33 GROUP BY recordedmarkup.data ORDER BY SUM( ( SELECT
IFNULL(rm.mark, recordedmarkup.mark) FROM
recordedmarkup AS rm WHERE rm.chanid =
recordedmarkup.chanid AND rm.starttime =
recordedmarkup.starttime AND rm.type =
recordedmarkup.type AND rm.mark >
recordedmarkup.mark ORDER BY rm.mark ASC LIMIT 1
) - recordedmarkup.mark ) DESC LIMIT 1
Bindings were:
:CHANID=1221, :STARTTIME=2012-09-17T22:53:39
Driver error was [2/1064]:
QMYSQL: 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 ':CHANID AND recordedmarkup.starttime = :STARTTIME AND
recordedmar' at line 1
2012-09-17 22:53:42.204834 E Error preparing query: SELECT
recordedmarkup.data FROM recordedmarkup WHERE recordedmarkup.chanid
= :CHANID AND recordedmarkup.starttime = :STARTTIME AND
recordedmarkup.type = 34 GROUP BY recordedmarkup.data ORDER BY
SUM( ( SELECT IFNULL(rm.mark, recordedmarkup.mark) FROM
recordedmarkup AS rm WHERE rm.chanid =
recordedmarkup.chanid AND rm.starttime =
recordedmarkup.starttime AND rm.type =
recordedmarkup.type AND rm.mark >
recordedmarkup.mark ORDER BY rm.mark ASC LIMIT 1
) - recordedmarkup.mark ) DESC LIMIT 1
2012-09-17 22:53:42.204843 E Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'recordedmarkup.data' in 'field list'
2012-09-17 22:53:42.204965 E DB Error (load_markup_datum):
Query was:
SELECT recordedmarkup.data FROM recordedmarkup WHERE
recordedmarkup.chanid = :CHANID AND
recordedmarkup.starttime = :STARTTIME AND recordedmarkup.type
= 34 GROUP BY recordedmarkup.data ORDER BY SUM( ( SELECT
IFNULL(rm.mark, recordedmarkup.mark) FROM
recordedmarkup AS rm WHERE rm.chanid =
recordedmarkup.chanid AND rm.starttime =
recordedmarkup.starttime AND rm.type =
recordedmarkup.type AND rm.mark >
recordedmarkup.mark ORDER BY rm.mark ASC LIMIT 1
) - recordedmarkup.mark ) DESC LIMIT 1
Bindings were:
:CHANID=1221, :STARTTIME=2012-09-17T22:53:39
Driver error was [2/1064]:
QMYSQL: 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 ':CHANID AND recordedmarkup.starttime = :STARTTIME AND
recordedmar' at line 1
More information about the mythtv-users
mailing list