MySQL Forums
Forum List  »  Full-Text Search

errno: 140 trying to create a fulltext index
Posted by: George Mouchet
Date: October 20, 2005 04:36PM

Below is the command the causes the problem. All columns are either text or varchar. I'm using version 3.23.58 and the table type is MyISAM.

ALTER TABLE patent ADD FULLTEXT searchindex ( title, inventor_assignor, manufacturer, city, state, country, patent_year, form_name, alternate_form_name, materials, components, processes, design, style, keywords, category_form_type )

What does the error mean? How can I fix it? I was able to create a primary (non-full text) index on the same table without any problems.

Options: ReplyQuote

Written By
errno: 140 trying to create a fulltext index
October 20, 2005 04:36PM

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.