[mythtv-users] help - updating db schema

James Armstrong james at thearmstrongs.org
Tue Nov 28 15:21:30 UTC 2006


I am trying to move from dbschemaver 1137 to the lastest svn code. I 
think somewhere the database got partially updated (probably when I 
tried a newer OS X frontend). Now the backend dies trying to update the 
database:

2006-11-28 10:19:45.870 Upgrading to schema version 1139
2006-11-28 10:19:45.871 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD contrast   INT NOT NULL default '0';
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'contrast'

How can I force it to continue?

Thanks,
James


More information about the mythtv-users mailing list