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

[jedi]

On Wed, Mar 12, 2008 at 10:24:43AM -0400, Mark Murray wrote:
> On Wed, Mar 12, 2008 at 10:03 AM, Tom Dexter <digitalaudiorock at gmail.com>
> wrote:
> >
> > >
> >
> > 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
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> 
> Tom,
> 
> I don't think so.  I even went so far as to delete these new columns
> (apparently, there are three - audioprop, videoprop, and subtitletypes).
> The upgrade adds them back everytime so I think it's trying to add them
> TWICE during the same upgrade.

    Is there an upgrade script somewhere that we could examine
and perhaps run individually to get around this sort of problem?
If it's just one big SQL file then it should be easy enough to 
debug the issue directly.