[mythtv-users] Upgrade from 0.20.2 -> 0.25.2

[Michael T. Dean]

On 03/14/2013 11:53 AM, Robert Dege wrote:
> Mike,
>
> Following your advice, I built a virtual test box with mythtv-0.23.1 
> on it.  I was able to successfully import my 0.20 DB, and upgrade from 
> DBSchemaVer 1161 to 1254 without any errors (other than a few MythFont 
> errors).  Unfortunately, I ran into problems when I tried to upgrade 
> the DB to 0.25.2.  While mythtv-setup was upgrading the DB, it 
> encountered the following problem and errored out:
>
> 2013-03-14 11:12:53.534448 E  Unrecognized video database schema 
> version. Unable to upgrade database.
> 2013-03-14 11:12:53.534459 E  mythvideo.DBSchemaVer: '', 
> VideoDBSchemaVer: '1010', DVDDBSchemaVer: '1002'
> 2013-03-14 11:12:53.534464 E  Database Schema upgrade FAILED, unlocking.
>
> The mythtv schema version is currently at 1266
>
> Since I never used mythvideo, would it be possible to just delete the 
> conflicting tables, and have mythtv-setup recreate them while updating 
> the DB?  What do I need to do to resolve the problem?

Yeah.  You probably had used some part of MythVideo (MythDVD or 
something?) at one time, so it's in a bad "partial" state right now (as 
the upgrade script saw something MythVideo/DVD related, but old enough 
it didn't know how to upgrade it--and at the time we supported an 
upgrade from about ).  The right fix for that is to just delete the 
MythVideo schema from the pre-upgrade database.

So, restore your pre-upgrade backup (the one you made of the MythTV 0.23 
database schema at version 1254 is fine, or I'd recommend starting over 
with your 0.20.2 database backup if you didn't make one)--you don't want 
to use the database that failed an upgrade because its state is unknown 
and it may be compromised.  Then, do:

http://www.gossamer-threads.com/lists/mythtv/users/406462#406462

Then run mythtv-setup, and it should upgrade the database without issue.

Note to anyone reading this:  After upgrading to 0.25 or higher, 
deleting the MythVideo schema as shown in the linked post will corrupt 
your MythTV schema, so this approach should not be taken for any reason 
by anyone running a relatively-recent version of MythTV.

Mike