[mythtv-users] Database error
bioart at gmail.com
Tue Apr 19 02:56:14 UTC 2005
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
> 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
I just saw the same error on my CVS update today... was working fine
as of a week or so ago.
More information about the mythtv-users