[mythtv-users] Database upgrade failing (.20-fixes to .21 Ubuntu Backports)

[Mark Murray]

I really hope someone knows an easy fix for this.  I just upgraded to .21
from the Ubuntu backports repo.  Upon running mythtv-setup or
/usr/bin/mythbackend it tries to upgrade my database schema, but fails in
the following manner:

Shall I upgrade this database? [yes]
2008-03-12 08:26:40.376 Newest Schema Version : 1214
2008-03-12 08:26:40.378 Upgrading to schema version 1210
2008-03-12 08:26:40.379 DB Error (Performing database upgrade):
Query was: ALTER TABLE program ADD audioprop     tinyint(3) unsigned NOT
NULL;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'audioprop'

Anyone know what I've done wrong?

Thanks!

-- 
Mark Murray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080312/453f0a76/attachment.htm