[mythtv-users] Help with two database errors?

[Nick Rout]

Are you sure your database properly upgraded when you went from 0.24 to
0.25?
On Sep 21, 2012 12:18 PM, "Fred Hamilton" <fred at yonkitime.com> wrote:

> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120922/00410853/attachment.html>