[mythtv-users] Re: Problem upgrading to schema 1079 fails

[cythrault at gmail.com]

On Mar 30, 2005 10:00 PM, cythrault at gmail.com <cythrault at gmail.com> wrote:
> Hi,
> 
> I had problem upgrading schema version on my setup. I resolved the
> following by dropping the dvb_hw_decoder column and adding the
> dvb_swfilter column... this is from today's cvs.
> 
> 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'
> 
> Query was: ALTER TABLE capturecard CHANGE dvb_swfilter dvb_hw_decoder
> INT DEFAULT '0';
> Error was: Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'dvb_swfilter' in 'capturecard'
> 
> cyth

What probably created the problem is the fact that I enabled dvb
hardware decoding in mythsetup after a recent dvb patch but before the
schema update.

cyth