[mythtv-users] databse issues

[Les Gondor]

I had this happen to me post-upgrade (to 0.18) when my startup scripts 
were causing mythbackend to restart in quick succession during boot. The 
first invocation was only partway through the database modifications 
before the restart occurred, leaving the database schema only partly 
changed and the version number unchanged. The solution was to restore 
from the backup of the database and invoke mythbackend without the 
restart. Once the schema was completely changed the upgrade proceeded 
normally. If you don't have a pre-update copy of the database, you will 
have to alter the affected tables yourself to match your current schema 
version.

Cheers,
Les

Reza Naima 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
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

-- 
Les Gondor, Total Graphics            les at totalgraphix.ca
If you don't know what you're doing, do it neatly