[mythtv-users] Database issue after upgrade to 0.20
bjm at lvcm.com
Wed Nov 15 01:52:44 UTC 2006
Beny Spensieri Jr wrote:
> 2006-11-14 19:18:41.529 Upgrading to schema version
> 2006-11-14 19:18:41.529 DB Error (Performing database
> 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
> and what I need to do to relove this issue?
$ mysql -u mythtv -pmythtv mythconverg
mysql> ALTER TABLE capturecard DROP COLUMN diseqcid;
More information about the mythtv-users