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

[Tom Dexter]

On Wed, Mar 12, 2008 at 8:37 AM, Mark Murray <marklmurray at gmail.com> wrote:
> 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
> _______________________________________________
>  mythtv-users mailing list
>  mythtv-users at mythtv.org
>  http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>

It sounds as thought your database schema is newer than 0.20-fixes
somehow.  My Gentoo backend is running 0.20.2 at SVN 14972 and the
column audioprop doesn't yet exist on the program table.  On yours it
apparently already does.  Did the backend somehow get interrupted
partway though a schema upgrade or something?

Tom