[mythtv-users] databse issues

Reza Naima reza at reza.net
Mon Aug 8 06:37:02 UTC 2005


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



More information about the mythtv-users mailing list