[mythtv-users] Database Upgrade Troubles

[aaron]

Hi,

I have Slackware 9.2-partially-upgraded-to-11 on my Myth box (combined
be/fe), so I figure that in order to move to SVN or 0.22 (once it's
released) I'll probably have to do a full system reinstall/upgrade to
Slackware 12.2 or higher (at the very least, to get Qt 4). Of course,
that will be a fairly major undertaking, so I decided to create a VM
and start trying things out there, to make sure all will be well.

Alas, I found that all is not well. The code compiles and installs
just fine (yay!), but the database upgrade isn't so happy.

I am working with a backup from the real machine, so that I can replay
the upgrade as many times as I need, without risking breaking the main
system. It fails at the same place consistently:

====
2009-04-18 09:36:33.321 Newest Schema Version : 1232
2009-04-18 09:36:33.560 Upgrading to schema version 1215
2009-04-18 09:36:33.576 Upgrading to schema version 1216
2009-04-18 09:36:36.916 DB Error (Performing database upgrade):
Query was: ALTER TABLE program  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 category_type varbinary(64) NOT NULL default
'',  MODIFY title_pronounce varbinary(128) NOT NULL default '',
MODIFY seriesid varbinary(40) NOT NULL default '',  MODIFY showtype
varbinary(30) NOT NULL default '',  MODIFY colorcode varbinary(20) NOT
NULL default '',  MODIFY syndicatedepisodenumber varbinary(20) NOT
NULL default '',  MODIFY programid varbinary(40) NOT NULL default '';
Error was: Driver error was [2/1283]:
QMYSQL3: Unable to execute statement
Database error was:
Column 'title' cannot be part of FULLTEXT index

new version: 1216
2009-04-18 09:36:36.916 Database Schema upgrade FAILED, unlocking.
2009-04-18 09:36:36.916 Couldn't upgrade database to new schema
====

Obviously the problem is that title cannot be part of a FULLTEXT
index. But the problem is: why is it having this problem? I don't
recall making any manual changes to the program table... however, I
should point out that the database may date back to MythTV version
0.06, from about October 2002. So I suppose it's possible that I made
some update in the past, but I've tried to avoid manually modifying
the database schema.

After I removed:

FULLTEXT KEY `title2` (`title`)

from the program table DDL (and recreate the table), the upgrade
proceeds successfully.

I checked the archives but I didn't see anyone else report the same
problem. There was a similar report at one point, but it didn't seem
to have a definitive solution or explanation.

Is removing that FULLTEXT KEY the proper solution? Will it likely have
a negative impact, such as decreased query performance or somesuch?

-- 
aaron

"Oh oh oh. I'm incoherent with excitement. Please tell me what fascinating
bit of badger-sputumly inconsequential trivia you will assail me with next."
        -- Arthur Dent