[mythtv-users] 0.17 DB update problems

[Caleb]

First post here, so bear with me....

 

I updated my myth-suite from the apt rpms and now I am having some database update errors.  I (unfortunately) did not back up my mythconverg database before I updated, so I amhaving to fix these problems manually. 

 

I first had the same problems described in this post:

http://www.gossamer-threads.com/lists/mythtv/users/110446?search_string=scheme%20update%20error;#110446

 

I updated the FireWire column problems and now am coming up with another error that is very similar. 

 

2005-02-15 10:36:08.581 Upgrading to schema version 1066

2005-02-15 10:36:08.591 Upgrading to schema version 1067

2005-02-15 10:36:08.592 Upgrading to schema version 1068

2005-02-15 10:36:08.593 Upgrading to schema version 1069

2005-02-15 10:36:08.594 DB Error (Performing database upgrade):

Query was: ALTER TABLE recorded ADD COLUMN deletepending TINYINT(1) NOT NULL DEFAULT 0;

Error was: Driver error was [2/1060]:

QMYSQL3: Unable to execute query

Database error was:

Duplicate column name 'deletepending'

new version: 1069

2005-02-15 10:36:08.594 Couldn't upgrade database to new schema

I found the 'deletepending' column in the 'recorded' table of the mythconverg database, but I am not sure what I can do with it to make everything work again.

Any help would be great!!

 

Thanks!

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users