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

[Michael T. Dean]

On 09/18/2012 09:20 PM, Fred Hamilton wrote:
> (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'
...
> 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.
>

Your database schema is corrupt.  This corruption likely occurred when 
you "imported" the database.  If you didn't, you should have used the 
mythconverg_restore.pl script to restore the database from the old 
system, as described at 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database 
.  The purpose of using that script is to prevent invalid restores 
(which are extremely common when using "raw" mysql tools).  The script 
actually checks to make sure everything is right before restoring and 
tells you when you're doing something wrong.

You definitely need to find the pre-upgrade database backup, and should 
try to restore it, again, using the approach described above.

Mike