Tried running mythtv-setup first, no change. The setup prints the same error message to stdout(see below). starting mythbackend afterwards still gives same error message.
help! -Henrik [EMAIL PROTECTED] mythtv]# mythtv-setup 2005-04-23 20:49:15.571 New DB connection, total: 1 Total desktop width=1024, height=768, numscreens=1 2005-04-23 20:49:15.576 Using screen 0, 1024x768 at 0,0 2005-04-23 20:49:15.579 Setting Lock for Database Schema upgrade. If you see a long pause here it means t he Schema is already locked and is being upgraded by another Myth process. 2005-04-23 20:49:15.580 New DB connection, total: 2 2005-04-23 20:49:15.581 Upgrading to schema version 1072 2005-04-23 20:49:15.582 DB Error (Performing database upgrade): Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT NULL DEFAULT 0; Error was: Driver error was [2/1060]: QMYSQL3: Unable to execute query Database error was: Duplicate column name 'manualid' new version: 1072 2005-04-23 20:49:15.582 Database Schema upgrade FAILED, unlocking. 2005-04-23 20:49:15.621 Switching to square mode (G.A.N.T.) mythtv: could not open config file /root/.mythtv/lircrc mythtv: No such file or directory Failed to read lirc config /root/.mythtv/lircrc for mythtv 2005-04-23 20:49:16.078 Joystick disabled. On 4/23/05, Henrik Bentel <[EMAIL PROTECTED]> wrote: > Hi > > I'm having trouble upgrading to .18. Rather I upgrade (from .17 to .18 > , using atrpms ) and mythtvbackend process keeps dying. > It attempts to upgrade the DB schema but this fails and the > process dies. Log below. > > Hope someone can help > > -Henrik > > 2005-04-23 15:05:21.396 New DB connection, total: 1 > 2005-04-23 15:05:21.437 Setting Lock for Database Schema upgrade. If > you see a long pause here it means the Schema is already locked and is > being up > graded by another Myth process. > 2005-04-23 15:05:21.439 New DB connection, total: 2 > 2005-04-23 15:05:21.441 Upgrading to schema version 1072 > 2005-04-23 15:05:21.443 DB Error (Performing database upgrade): > Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT > NULL DEFAULT 0; > Error was: Driver error was [2/1060]: > QMYSQL3: Unable to execute query > Database error was: > Duplicate column name 'manualid' > > new version: 1072 > 2005-04-23 15:05:21.445 Database Schema upgrade FAILED, unlocking. > 2005-04-23 15:05:21.446 Couldn't upgrade database to new schema > _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
