[mythtv] Fwd: Problems upgrading database
Nigel Pearson
nigel at ind.tansu.com.au
Thu Apr 7 22:29:55 UTC 2005
> 2005-04-07 11:07:14.454 DB Error (Performing database upgrade):
> 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'
>
> new version: 1079
I had similar errors on one machine, and got around them by
upgrading DBSchemaVer (in the database settings table) to 1081.
In my case, I suspect the problem was caused by mythtv-setup,
the frontend, or the dattabase crashing half way through the
schema upgrade.
--
Nigel Pearson, nigel at ind.tansu.com.au|"Beware - I am a carrier
Telstra BI&D, Sydney, Australia | of surrealism"
Office: 8255 4222 Fax: 8255 3153 | D A
Mobile: 0408 664435 Home: 9792 6998 | L I
More information about the mythtv-dev
mailing list