Mike,<br><br>That solution worked perfectly. Thank you so much for the help and advise.<br><br>-Rob<br><br><br><div class="gmail_quote">On Thu, Mar 14, 2013 at 12:04 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On 03/14/2013 11:53 AM, Robert Dege wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Mike,<br>
<br>
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:<br>
<br>
2013-03-14 11:12:53.534448 E Unrecognized video database schema version. Unable to upgrade database.<br>
2013-03-14 11:12:53.534459 E mythvideo.DBSchemaVer: '', VideoDBSchemaVer: '1010', DVDDBSchemaVer: '1002'<br>
2013-03-14 11:12:53.534464 E Database Schema upgrade FAILED, unlocking.<br>
<br>
The mythtv schema version is currently at 1266<br>
<br>
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?<br>
</blockquote>
<br></div>
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.<br>
<br>
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:<br>
<br>
<a href="http://www.gossamer-threads.com/lists/mythtv/users/406462#406462" target="_blank">http://www.gossamer-threads.<u></u>com/lists/mythtv/users/406462#<u></u>406462</a><br>
<br>
Then run mythtv-setup, and it should upgrade the database without issue.<br>
<br>
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.<div class="HOEnZb">
<div class="h5"><br>
<br>
Mike<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/<u></u>listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>