[mythtv-users] HD-PVR Problem with 0.25 fixes - is this a database issue?

[Fred Hamilton]

(Reposted from http://ubuntuforums.org - nickrout said this is where
all the database experts hang out)

Finally got around to upgrading Myth system from 10.10 / 0.24 to 12.04
/ 0.25. cx88 tuner works fine, but can't record programs or watch live
TV with HD-PVR.

Device is recognized:

  $ dmesg | grep video
  [ 0.241023] pci 0000:01:00.0: Boot video device
  [ 11.331169] Linux video capture interface: v2.00
  [ 11.610292] hdpvr 1-5:1.0: device now attached to video0
  [ 11.764201] cx88[0]/0: registered device video1 [v4l2]
  $

And I can even record and playback video outside MythTV:
  /dev/video0 > test.ts
generates a working, VLC-viewable video file.

Even got the ole 6200ch recompiled and tested that it works as well.

But whenever I try the HD-PVR with Myth, I just get a black screen
(Watch TV) or "no file" (when it tries to record something).

Couldn't find any new/updated log files in /var/log/mythtv, but I did
capture everything it spit out after launching mythfrontend -v
(apologies for length and inevitable formatting crimes).  Relevant
errors below:

$ sudo mythfrontend -v

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

Any suggestions where to look next? Looking at the log file above I
wonder if something's not misconfigured in my database (I imported and
upgraded it from 10.10). I'm very mysql illiterate - hope it might be
obvious to someone who isn't.

It's odd that Live TV and recording through the ATSC tuner seems to work fine.

Cheers,
Fred