[mythtv-users] Fixing minor errors in Myth database

[Fred Hamilton]

I'm running Myth 0.26 on Ubuntu 12.04.  Over the years the migrations
appear to have taken their toll on the database.  So even though everything
seems to be working well, mythweb gags when I select "Recorded Programs",
saying:

Fatal Error  !!NoTrans: SQL Error: Unknown column 'recordedmarkup.data' in
'field list' [#1054]!!

with the backtrace shown below.  I'm looking for some advice on how to
clean that up.  The MythWeb "Repair Tables" function doesn't seem to do it.

Cheers,
Fred

backtrace:

  datetime:  2013-04-19 17:14:27 (PDT)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: SQL Error: Unknown column 'recordedmarkup.data'
in 'field list' [#1054]!!
    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
  error line:  79

==========================================================================

Backtrace:

    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
    line:  79
   class:
function:  trigger_error
    type:
    args:  Array
(
    [0] => SQL Error: Unknown column 'recordedmarkup.data' in 'field list'
[#1054]
    [1] => 256
)

    file:  /usr/share/mythtv/mythweb/classes/Database.php
    line:  261
   class:  Database_Query_mysql
function:  execute
    type:  ->
    args:  Array
(
    [0] => Array
        (
            [0] => 4709
            [1] => 1366408800
        )

)

    file:  /usr/share/mythtv/mythweb/modules/tv/classes/Program.php
    line:  810
   class:  Database
function:  query
    type:  ->
    args:  Array
(
    [0] => SELECT recordedmarkup.type,
                                 recordedmarkup.data
                            FROM recordedmarkup
                           WHERE recordedmarkup.chanid    = ?
                             AND recordedmarkup.starttime = FROM_UNIXTIME(?)
                             AND recordedmarkup.type      IN (10, 11, 12,
13, 14)
                        GROUP BY recordedmarkup.type
                        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 IN (10, 11, 12, 13, 14)
                                         AND rm.mark > recordedmarkup.mark
                                ORDER BY rm.mark ASC LIMIT 1)-
recordedmarkup.mark) DESC
                           LIMIT 1
    [1] => 4709
    [2] => 1366408800
)

    file:  /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
    line:  144
   class:  Program
function:  getAspect
    type:  ->
    args:  Array ( )
    file:  /usr/share/mythtv/mythweb/modules/tv/recorded.php
    line:  193
   class:
function:  require_once
    type:
    args:  Array
(
    [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php
)

    file:  /usr/share/mythtv/mythweb/modules/tv/handler.php
    line:  82
   class:
function:  require_once
    type:
    args:  Array
(
    [0] => /usr/share/mythtv/mythweb/modules/tv/recorded.php
)

    file:  /usr/share/mythtv/mythweb/mythweb.php
    line:  35
   class:
function:  require_once
    type:
    args:  Array
(
    [0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130419/a38b4a01/attachment.html>