MySQL Forums
Forum List  »  Full-Text Search

Unable to create full text index
Posted by: Kim Kohen
Date: February 15, 2006 03:34AM

I've moved a db to an Apple XServe running Apple's default MySQL installation (4.1 I think - don't have access at the moment to check exact version). The databases and tables have been created, the data imported and I just need to add the Full Text Index. When I attempt to do this I get the following error message Column '%s' cannot be part of FULLTEXT index Error: 1283.

I'm trying to add three columns, a varchar 255, a mediumtext and a text column. I can successfully add any two of the three columns to the Index but not all three. Could someone let me know if there's some restriction on the number or type of column which can be added to a Full Text Index or if there is an explanation for this error?

Many thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to create full text index
5812
February 15, 2006 03:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.