[mythtv-users] Database error

[Art Morales]

On 4/13/05, SpikeyGG <spikeygg at hotmail.com> wrote:
>  
> Hello Mythgroup, 
>   
> I recently tried to upgrade my installation of myth cause I noticed that the
> new stuff is all packaged nice (in three packages).  Anyway, I built it from
> CVS like normal... uninstalled my old one first and install the new one. 
> When I run mythbackend I get the following error: 
>   
> 2005-04-13 20:23:58.545 New DB connection, total: 1
> 2005-04-13 20:23:58.547 Setting Lock for Database Schema upgrade. If you see
> a long pause here it means the Schema is already locked and is being
> upgraded by another Myth process.
> 2005-04-13 20:23:58.548 New DB connection, total: 2
> 2005-04-13 20:23:58.549 Upgrading to schema version 1079
> 2005-04-13 20:23:58.549 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
> 2005-04-13 20:23:58.550 Database Schema upgrade FAILED, unlocking.
> 2005-04-13 20:23:58.550 Couldn't upgrade database to new schema
>  
> I'm brand new to mysql and learned a little off the web (basically how to
> look at tables).  I checked out the capturecard table and it looks like that
> dvb_hw_decoder does exist.  Any idea how I can fix it without trashing my
> DB? 
>   


I just saw the same error on my CVS update today... was working fine
as of a week or so ago.

Art