NoTrans: SQL Error: Unknown column 'future' in 'where clause' [#1054]!!

[dclemen@…]

file: /usr/share/mythtv/mythweb/classes/Database.php line: 322

class: Database

function: query

type: -> args: Array

(

[0] => SELECT COUNT(*) FROM oldrecorded WHERE future = 0 [1] => Array ( )

[Raymond Wagner]

You are attempting to run a version of MythWeb too new for your database. This is a schema mismatch.

[tom-mythtv@…]

I'm getting the same error and ought to have an up-to-date database (using the debian-multimedia packages for sid, and have mythtv-database installed). The backend and frontends seem to work fine, it's just mythweb which is not working since I upgraded to version 0.24+fixes20110426.

Any ideas how to fix it? If I need to update the schema, how is this done? (I had assumed it was done automatically, as I've not needed to do it before).

[sphery]

This is caused by using MythWeb from unstable/master against a MythTV 0.24 backend/database. It seems there's a problem with the Debian packages that results in these incompatible versions being installed.

Please direct all further questions to the mythtv-users list or, in this case (since it's a Debian packaging problem), you may have better luck with a Debian-/packaging-specific mailing list or forum.