[mythtv] Ticket #6923: 0.21->trunk DB upgrade failed

[Michael T. Dean]

On 08/26/2009 05:38 PM, MythTV wrote:
> #6923: 0.21->trunk DB upgrade failed
>
>
> Comment(by warpme):
>
>  Well,
>  My setup is:[[BR]]
>
>
>  -0.21-fixes production BE[[BR]]
>
>  -trunk test BE running under vmware[[BR]]
>
>
>  According to Your suggestions I do following:[[BR]]
>
>  -stop msql/mythbackend in trunk based test BE[[BR]]
>
>  -rsync DB files from running, production 0.21-fixes BE to test BE[[BR]]
>
>  -start mysql on test BE[[BR]]
>
>  -launch mythtv-setup on test BE[[BR]]
>
>
>  Log attached...

Thank you for restoring the DB to get a clean "first-time upgrade" log.

The log file seems to indicate that your 0.21-fixes database schema has 
been modified to include the default_authority column in the 
channelscan_dtv_multiplex table.  Since 0.21-fixes doesn't have a 
channelscan_dtv_multiplex table (it's created in DB schema update 
1219--which yours went through without error because of the "IF NOT 
EXISTS" in the "CREATE TABLE" statement), your 0.21-fixes database 
schema has been modified.

Are you, perhaps, running a version of 0.21-fixes that was patched with 
the patch at http://svn.mythtv.org/trac/ticket/5603, or any other patch 
that adds a channelscan_dtv_multiplex table?

Thanks,
Mike