[mythtv-users] databse issues
Les Gondor
les at totalgraphix.ca
Mon Aug 8 15:19:01 UTC 2005
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
More information about the mythtv-users
mailing list