[mythtv-users] databse issues
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?
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
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