[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade

[Michael T. Dean]

  On 12/31/2010 01:18 PM, Nick Morrott wrote:
> On 31 December 2010 15:53, Richard Morton wrote:
>> Hi There,
>>
>> Thanks for the email however I have no issues with restoring the 0.23
>> database. I have an issue with mythbackend not upgrading it to 0.24
>> successfully.
> The upgrade is failing due to the presence of a(t least one) table
> that should not exist at the reported schema version of 1257.

Exactly.

> $ mysql -u<username>  -p mythconverg
>
> mysql>  DROP TABLE IF EXISTS internetcontent;
> mysql>  DROP TABLE IF EXISTS internetcontentarticles;
> mysql>  exit;
>
> This should permit this particular schema upgrade to succeed, but
> without knowing how far the broken upgrade got it's difficult to say
> how much more poking will be required.

Or how broken your data and/or schema will be because something besides 
MythTV obviously messed with your schema--and without knowing to what 
extent things were changed, it's impossible to know how much is wrong.

If you don't know where internetcontent* tables came from in your 
system, you may not want to trust anything about the schema and just do 
a partial restore because your schema may be corrupt.

Mike