[mythtv] DVB patch v2.1 DB upgrade problems

[Jesper Sörensen]

Taylor Jacob wrote:

>>Just changed to v2.1 of the DVB patch, however get the following error on
>>starting myth setup:
>>    
>>
>
>  
>
>>2004-11-20 02:17:59.108 Upgrading to schema version 1059
>>DB Error (Performing database upgrade):
>>Query was:
>>ALTER TABLE capturecard ADD COLUMN dvb_diseqc_type SMALLINT(6);
>>Driver error was [2/-1]:
>>QMYSQL3: Unable to execute query
>>Database error was:
>>Duplicate column name 'dvb_diseqc_type'
>>    
>>
>
>These patches are all designed to be installed over a clean myth cvs setup..
>I.E. If you had 2.0 installed you gotta dump the database..
>  
>

It's also possible to bypass that step by manually setting the schema 
version:

update settings set data=1059 where value='DBSchemaVer';

Don't do this without taking a look at libs/libmythtv/dbcheck.cpp to 
make sure you understand what's going on though. A good backup is also 
recommended of course... ;-)