[mythtv] DVB patch v2.1 DB upgrade problems

[Steve Berryman]

I think you have to delete all the tables and fields it tries to create.
that includes both of them and others. it took me a long time to work
out which ones i had to delete and i lost the sql to delete them as
well... sorry

Steve

On Sat, 2004-11-20 at 02:28 +0000, Chris Birkinshaw 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'
> 
> I have tried deleting the column from the table, which then leads to the
> following error:
> 
> 2004-11-20 02:16:59.025 Upgrading to schema version 1059
> DB Error (Performing database upgrade):
> Query was:
> ALTER TABLE cardinput ADD COLUMN diseqc_pos FLOAT;
> Driver error was [2/-1]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate column name 'diseqc_pos'
> 
> So I then deleted this column but it now it recreates them both and I cam back
> to step one.
> 
> Is there any way to solve this without scrapping my DB?
> 
> Thanks,
> 
> Chris
> 
> 
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
> 
-- 
Steve Berryman <steve at object4.net>