Table Type Doesn’t Support FULLTEXT Indexes

#1214 – The used table type doesn’t support FULLTEXT indexes
ERROR 1214 (HY000) at line 29: The used table type doesn’t support FULLTEXT indexes


http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html
“Full-text indexes can be used only with MyISAM tables. (In MySQL 5.6 and up, they can also be used with InnoDB tables.)”

So if the database is using InnoDB you would either want to upgrade to mysql 5.6 (which is probably a good idea) or use MyISAM instead.