[mythtv-users] Database error

SpikeyGG spikeygg at hotmail.com
Thu Apr 14 02:44:39 UTC 2005

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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050413/9b8158d0/attachment.htm

More information about the mythtv-users mailing list