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

mikp mikpolniak at roadrunner.com
Thu Jun 25 11:48:15 UTC 2009


Since my DB was originally created on gentoo (currently running Slackware) 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.

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
 
new version: 1216
2009-06-25 07:29:57.043 Database Schema upgrade FAILED, unlocking.
2009-06-25 07:29:57.043 Couldn't upgrade database to new schema

Since i have a working 0.21-fixes for my recordings and this is a second mythtv based on trunk, i am willing to try anything to work around this problem.


More information about the mythtv-users mailing list