[mythtv-users] databse issues

[Nick]

On 8/8/05, Reza Naima <reza at reza.net> wrote:
> 
> ok, this auto-db-update thing is driving me nuts.  every time i quit and
> restart mythtv, it wants to upgade the db.  i have to go in manually,
> and update the database to reflect the version change, then mythbackend
> starts.  but when mythbackend quites, and i try to restart it, it
> thinks it's the old version again.  anyone know why?
> 
> thnx
> 
> 2005-08-07 23:33:31.567 Upgrading to schema version 1077
> 2005-08-07 23:33:31.595 New DB connection, total: 3
> 2005-08-07 23:33:31.623 Upgrading to schema version 1078
> 2005-08-07 23:33:31.637 Upgrading to schema version 1079
> 2005-08-07 23:33:31.650 DB Error (Performing database upgrade):
> Query was: ALTER TABLE capturecard ADD COLUMN dvb_hw_decoder INT DEFAULT
> '0';
> Error was: Driver error was [2/1060]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate column name 'dvb_hw_decoder'
> 
> new version: 1079
> 2005-08-07 23:33:31.651 Database Schema upgrade FAILED, unlocking.
> 2005-08-07 23:33:31.651 Couldn't upgrade database to new schema

Reza,

Have you been through the update script manually to make sure the DB
has the correct new format (or removed the column 'dvb_hw_recorder'
from table 'capturecard' and let the update script run again? If
that's the only place the script is failing, the update might proceed
OK. If it complains of other SQL errors, look at the error and update
the DB as appropriate.

NIck