<br><br>
<div class="gmail_quote">On Mon, Nov 16, 2009 at 1:58 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="im">On 11/16/2009 04:01 AM, James Warden wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I went through an upgrade from mythtv 0.21 to 0.22 yesterday and found an issue with the following (probably already mentioned somewhere else but this is how I fixed it):<br>
<br>the dtv_multiplex and channelscan_dtv_multiplex tables cannot be upgraded from db schema 1230 to 1231 and makes the whole upgrade fail.<br><br>This is because the table already contains a field (mysql column) that the upgrade is trying to add again when upgrading to 1231.<br>
<br>So what I did is to make a backup (mysqldump) of DB at schema 1230, remove the screwing field from the dump (it is an ASCII file) when it is trying to INSERT it in these particular tables, retore the modified DB, and upgrade again.<br>
<br>It worked pretty nicely. I can give some more technical details / howto when I am at home if someone needs it.<br></blockquote><br></div>You restored a 0.21-fixes DB backup /on top of/ a 0.22-fixes DB schema. That means that MySQL converted any data to fit (and may have broken your data). That means you should /immediately/ go back to your 0.21-fixes database backup and restore it properly and then let MythTV upgrade it properly.<br>
<br><a href="http://www.gossamer-threads.com/lists/mythtv/users/405443#405443" target="_blank">http://www.gossamer-threads.com/lists/mythtv/users/405443#405443</a><br><br>(Specifically, read the section, "If you're not doing an "in-place" upgrade (so you need to restore your DB backup), it is critical that you DROP any existing database /before/ restoring your database backup." )<br>
<br>and <a href="http://svn.mythtv.org/trac/ticket/6923#comment:4" target="_blank">http://svn.mythtv.org/trac/ticket/6923#comment:4</a><br><br>If you don't do this, all of your data is suspect, and bad things may happen.<br>
<br>Mike
<div>
<div></div>
<div class="h5"><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div>
<div><br> </div>
<div>I'm with Mike here. You want to load the old DB before you upgrade. I tried doing it in your order - overlaying a 0.21 DB over 0.22. Seemed to work okay until I kept getting query errors in my logs.</div>