[mythtv] Ticket #6923: 0.21->trunk DB upgrade failed
Michael T. Dean
mtdean at thirdcontact.com
Wed Aug 26 22:02:04 UTC 2009
On 08/26/2009 05:38 PM, MythTV wrote:
> #6923: 0.21->trunk DB upgrade failed
> Comment(by warpme):
> 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?
More information about the mythtv-dev