[mythtv-users] 0.20 schema upgrade failed

[Peter Bienstman]

Hi,

I upgraded from 0.19 to 0.20 (Actually the Gentoo 0.20_p11444 version), but 
when I start mythfrontend, I get this:

2006-10-07 21:58:51.187 Using runtime prefix = /usr
2006-10-07 21:58:51.190 DPMS is active.
2006-10-07 21:58:51.217 New DB connection, total: 1
2006-10-07 21:58:51.221 Connected to database 'mythconverg' at host: localhost
2006-10-07 21:58:51.222 Total desktop dim: 1280x1024, with 1 screen[s].
2006-10-07 21:58:51.224 Using screen 0, 1280x1024 at 0,0
2006-10-07 21:58:51.230 Current Schema Version: 1136
2006-10-07 21:58:51.231 Newest Schema Version : 1160
2006-10-07 21:58:51.233 New DB connection, total: 2
2006-10-07 21:58:51.234 Connected to database 'mythconverg' at host: localhost
2006-10-07 21:58:51.234 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-10-07 21:58:51.234 New DB connection, total: 3
2006-10-07 21:58:51.235 Connected to database 'mythconverg' at host: localhost
2006-10-07 21:58:51.235 Upgrading to schema version 1137
2006-10-07 21:58:51.236 DB Error (Performing database upgrade):
Query was: ALTER TABLE recordedprogram ADD listingsource INT NOT NULL 
default '0';
Error was: Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.recordedprogram' doesn't exist

new version: 1137
2006-10-07 21:58:51.236 Database Schema upgrade FAILED, unlocking.
2006-10-07 21:58:51.236 Couldn't upgrade database to new schema, exiting.

I don't know if it's related, but I noticed that before the upgrade, it took 
rather long to delete a recording...

Is there any way to recover from this without losing all my settings?

Thanks!

Peter