Maverick wrote:
I finally got the libqt3c102-mt-mysql package installed, ran through
myth-setup to make sure everything is ok, now starting mythfrontend I
am getting:
2005-02-11 14:14:32.678 Upgrading to schema version 1066
2005-02-11 14:14:32.681 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD COLUMN firewire_port INT UNSIGNED NOT NUL
L 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-11 14:14:32.681 Couldn't upgrade database to new schema, exiting.
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
3)
Don't worry if any of these complain. One or more should.
4)
mythbackend . Do not start two different myth programs at this
time and do not inturrupt it while it is doing it's updates.
5)
Continue on with the rest of your life =).
-- bjm
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
