[mythtv-users] Database issue after upgrade to 0.20

[Bruce Markey]

Beny Spensieri Jr wrote:
...
> 2006-11-14 19:18:41.529 Upgrading to schema version
> 1154
> 2006-11-14 19:18:41.529 DB Error (Performing database
> upgrade):
> Query was: ALTER TABLE capturecard ADD diseqcid
> INT(10) UNSIGNED default NULL;
> Error was: Driver error was [2/1060]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate column name 'diseqcid'
> 
> new version: 1154
> 2006-11-14 19:18:41.530 Database Schema upgrade
> FAILED, unlocking.
> 2006-11-14 19:18:41.530 Couldn't upgrade database to
> new schema
> 
> Does anyone know what went wrong

Nope.

> and what I need to do to relove this issue?

Yep.

$ mysql -u mythtv -pmythtv mythconverg
mysql> ALTER TABLE capturecard DROP COLUMN diseqcid;
mysql> quit
$ mythbackend

--  bjm