[mythtv-users] trunk could not upgrade DB schema from 1215 with fixed corrupted DB encoding

[Michael T. Dean]

On 06/25/2009 07:48 AM, mikp wrote:
> Since my DB was originally created on gentoo (currently running Slackware)

Note that if you changed from Gentoo MySQL server to a Slackware MySQL 
server (and assuming that Slack's server was set with latin1 encoding) 
/before/ fixing the corruption from running with an unsupported MySQL 
server configuration, you would have had partially corrupt data--which 
the instructions in the wiki will not fix (it would basically invert the 
corruption--what was corrupt (when running on Gentoo) becomes uncorrupt 
and what wasn't corrupt (when running on Slackware) becomes corrupt).

>  i followed the sphery wiki: "Fixing_Corrupt_Database_Encoding" to set character set to 'latin1'
> and restore the _un_corrupted database. But with trunk svn 20741 and starting mythbackend shows this error:
>
>
> Warning: MythTV wants to upgrade your database,
> for the TV schema, from 1215 to 1235.
>   

Were you running an extremely old trunk version?  The current 0.21-fixes 
schema version is 1214, so the 1215 may indicate a problem (using a 
broken/unsupported patch on -fixes that changed your DB schema).  Then 
again, it may just be that you attempted the upgrade already once before 
and the 1215 upgrade succeeded and it failed on the 1216 upgrade (as below).

> Database Host: 192.168.15.5
> Database Name: mythconverg
>
> If your system becomes unstable, a database backup is located in /mnt/store2/mythconverg-1215-20090625072803.sql.gz
>
>
> Shall I upgrade this database? [yes]  yes
>
> A database backup might be a good idea
> Are you sure you want to upgrade? [no]  u^Hyes^Hyes
> 2009-06-25 07:29:48.110 Newest Schema Version : 1235
> 2009-06-25 07:29:48.113 Upgrading to schema version 1216
> 2009-06-25 07:29:57.043 DB Error (Performing database upgrade): 
> Query was: ALTER TABLE recorded  MODIFY title varbinary(128) NOT NULL default '',  MODIFY subtitle varbinary(128) NOT NULL default '',  MODIFY description blob NOT NULL,  MODIFY category varbinary(64) NOT NULL default '',  MODIFY hostname 
> varbinary(64) NOT NULL default '',  MODIFY recgroup varbinary(32) NOT NULL default 'Default',  MODIFY seriesid varbinary(40) NOT NULL default '',  MODIFY programid varbinary(40) NOT NULL default '',  MODIFY basename varbinary(255) NOT NULL,  MODIFY playgroup varbinary(32) NOT NULL default 'Default',  MODIFY profile varbinary(32) NOT NULL default '',  MODIFY storagegroup varbinary(32) NOT NULL default 'Default'; 
> Error was: Driver error was [2/1283]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Column 'subtitle' cannot be part of FULLTEXT index
>   

Something is wrong with your DB schema.  The recorded.subtitle column is 
/not/ part of any indices in 0.21-fixes or trunk.  Did you perform any 
modifications to your DB "to enhance performance" or are you running 
with any patches?  As a matter of fact, I'm pretty sure there are no 
FULLTEXT indices anywhere in the MythTV database schema.

Mike