[rt-users] can't alter table: attachments

Tom Vier tom at triadsys.com
Tue Jun 21 09:44:04 EDT 2005


Phil Homewood wrote:
>> #1214 - The used table type doesn't support FULLTEXT indexes
> Do you have some kind of locally installed index on the Attachments table?

Apparently rt set some up, at some point, and some are duplicates. I 
should be able to delete them, convert to innodb, then recreate the 
indexes, right?

Indexes:
Keyname 	Type 	Cardinality 	Action 	Field
PRIMARY 	PRIMARY 	8497  	Edit 	Drop 	id
Attachments1 	INDEX 	944  	Edit 	Drop 	Parent
Attachments2 	INDEX 	8497  	Edit 	Drop 	TransactionId
Attachments3 	INDEX 	8497  	Edit 	Drop 	Parent
TransactionId
Content 	FULLTEXT 	8497  	Edit 	Drop 	Content
Content_2 	FULLTEXT 	8497  	Edit 	Drop 	Content
Content_3 	FULLTEXT 	8497  	Edit 	Drop 	Content
Content_4 	FULLTEXT 	8497  	Edit 	Drop 	Content
Content_5 	FULLTEXT 	8497  	Edit 	Drop 	Content
Content_6 	FULLTEXT 	8497  	Edit 	Drop 	Content

- Tom



More information about the rt-users mailing list