[mythtv-users] Re: Problem upgrading to schema 1079 fails
cythrault at gmail.com
cythrault at gmail.com
Thu Mar 31 03:06:14 UTC 2005
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
More information about the mythtv-users
mailing list