[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?
Thanks,
-Greg
-------------- 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