[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