<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Is this the dreaded partial corruption? I've tried doing a partial restore on top of the 0.21 blank.sql file posted here a few months ago and it still is complaining - this time only 1 warning, in the oldrecorded table. Is there any way to find the "bad" characters in the database backup and fix them by hand? I really don't want to lose all my recordings but I'm somewhat at a loss as to what to try next (besides re-installing 0.21...)<br>
</blockquote>
<br></div>
It is definitely corruption. Because you had tried to reconfigure your MythTV box in 0.21 (where there was no way to test if the reconfiguration worked--as you wouldn't get the errors that only appear on database upgrade), you almost definitely have partial corruption.<br>
<br>
If it is partial corruption, it just means you'll need to use this fix:<br>
<br>
<a href="http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding#Partial_vs_.22equal.22_corruption" target="_blank">http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding#Partial_vs_.22equal.22_corruption</a><br>
<a href="http://www.gossamer-threads.com/lists/mythtv/users/406111#406111" target="_blank">http://www.gossamer-threads.com/lists/mythtv/users/406111#406111</a><br>
<br></blockquote><div><br></div><div><br></div><div>Thats exactly what I meant by the above paragraph - doing the partial restore over a blank database, and it still didn't work.... any other ideas? I've currently moved back to 0.21, but gentoo is about to purge qt3 & friends from portage in the next few weeks so I'd really like to get it upgraded cleanly.</div>
<div><br></div><div>Thanks,</div><div>Scott</div><div><br></div><div><br></div></div>