I did this to fix it, and now get another error:
I did this: 1) mysql -u mythtv -pmythtv mythconverg 2) DELETE FROM profilegroups WHERE name = 'FireWire Input'; ALTER TABLE capturecard DROP COLUMN firewire_port; ALTER TABLE capturecard DROP COLUMN firewire_node; ALTER TABLE capturecard DROP COLUMN firewire_speed; ALTER TABLE capturecard DROP COLUMN firewire_model; quit
But now get this:
2005-02-18 13:42:55.802 Upgrading to schema version 1066
2005-02-18 13:42:55.803 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD COLUMN firewire_port INT UNSIGNED NOT NULL DEFAULT 0;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'firewire_port'
new version: 1066
2005-02-18 13:42:55.804 Couldn't upgrade database to new schema, exiting.
Thoughts?
Mark
On Feb 18, 2005, at 1:50 PM, mark wrote:
Upgrade went fine from FC2-3 and I have upgraded 16-17 on Myth. I ran mythtvsetup, I get the 5 options, I keep all settings.
Now when I start mythtvfrontend I get:
2005-02-18 13:42:55.802 Upgrading to schema version 1066
2005-02-18 13:42:55.803 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD COLUMN firewire_port INT UNSIGNED NOT NULL DEFAULT 0;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'firewire_port'
new version: 1066
2005-02-18 13:42:55.804 Couldn't upgrade database to new schema, exiting.
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
