[mythtv-users] Upgrading to MythTV 0.19 - error upgrading database

[Pedro Flores]

Last night I decided to upgrade to 0.19 and things didn't go very well.
When upgrading to the new database schema I got the following error:

new version: 1109
2006-02-18 19:22:51.456 Database Schema upgrade FAILED, unlocking.
2006-02-18 19:22:51.458 Couldn't upgrade database to new schema
2006-02-18 19:46:38.140 Using runtime prefix = /usr
2006-02-18 19:46:38.165 New DB connection, total: 1
2006-02-18 19:46:38.168 Connected to database 'mythconverg' at host:
localhost
2006-02-18 19:46:38.173 Current Schema Version: 1108
2006-02-18 19:46:38.176 Newest Schema Version : 1123
2006-02-18 19:46:38.179 New DB connection, total: 2
2006-02-18 19:46:38.181 Connected to database 'mythconverg' at host:
localhost
2006-02-18 19:46:38.183 Setting Lock for Database Schema upgrade. If you
see a long
 pause here it means the Schema is already locked and is being upgraded
by another
Myth process.
2006-02-18 19:46:38.185 New DB connection, total: 3
2006-02-18 19:46:38.188 Connected to database 'mythconverg' at host:
localhost
2006-02-18 19:46:38.190 Upgrading to schema version 1109
2006-02-18 19:46:38.192 DB Error (Performing database upgrade):
Query was: ALTER TABLE oldrecorded ADD COLUMN generic TINYINT(1) DEFAULT
0;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'generic'


I ended up giving up, backed up the old database, and forced mythtv to
create a new one and things started working again, except for the fact
that mythtv knows nothing about my previously recorded programs.  Is
there a way I can now import that information from my old database into
the new one?  Or is there some command I can run on my *.nuv files that
will build the necessary information into the new database?  Any
suggestions will be greatly appreciated.  Thanks.