[mythtv-users] Database problem after upgrade to .15

[Simon]

I just upgrade from 0.14 to 0.15 using apt-get. It seemed to go smoothly and
did not crash.
Unfortunately on first running mythbackend, I got the following error:

[root at mythtv root]# mythbackend
2004-06-05 23:45:38 Upgrading to schema version 1029
DB Error (Performing database upgrade):
Query was:
ALTER TABLE channel ADD COLUMN commfree TINYINT NOT NULL default '0';
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'commfree'


I tried to fix this by typing the following MYSQL command:

DELETE FROM channel WHERE value='commfree';
INSERT INTO settings (value, data) VALUES ('DBSchemaVer', '1029');

Then I tried to run mythbackend, and I got:

[root at mythtv root]# mythbackend
2004-06-05 23:50:37 Upgrading to schema version 1030
2004-06-05 23:50:37 Upgrading to schema version 1031
DB Error (Performing database upgrade):
Query was:
ALTER TABLE channel ADD COLUMN visible TINYINT(1) NOT NULL default '1';
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'visible'

So to fix that I did:

UPDATE channel SET visible = 0 WHERE visible IS NULL;
INSERT INTO settings (value, data) VALUES ('DBSchemaVer', '1031');

And now I get this:

mythbackend
2004-06-05 23:52:35 Upgrading to schema version 1032
2004-06-05 23:52:35 Upgrading to schema version 1033
DB Error (Performing database upgrade):
Query was:
UPDATE record SET dupmethod = 6 WHERE dupmethod = 22;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'dupmethod' in 'where clause'

And I have no idea what to do!
Can anyone help?


Simon