Finding FULLTEXT using InnoDB

Question

I am trying to add a FULLTEXT index to an existing table, but I am getting the following error.

1214 - The table type used does not support FULLTEXT indexes

I am using the following query:

alter table <table name> add FULLTEXT INDEX (column name(s)) 

The same request works on my localhost. My db engine is InnoDB for local and live server.

Show table creation tables:

 CREATE TABLE `xxx` ( `name1` varchar(50) NOT NULL, `city1` varchar(30) NOT NULL, `area1` varchar(100) NOT NULL, `add1` varchar(100) NOT NULL, `cont1` varchar(10) NOT NULL, `gen` varchar(1) NOT NULL, `type` varchar(10) NOT NULL, `landm` varchar(30) NOT NULL, `mo` varchar(10) NOT NULL, `email` varchar(100) NOT NULL, `passwd` varchar(100) NOT NULL, `exp` varchar(10) NOT NULL, `qual` varchar(30) NOT NULL, `id` varchar(255) NOT NULL, `location_map` varchar(500) DEFAULT NULL, `email_v` varchar(1) NOT NULL DEFAULT 'n', `v` varchar(1) NOT NULL DEFAULT 'n', PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 

Answer 1

InnoDB first introduced FULLTEXT features in MySQL version 5.6.4. Your server is probably running an earlier version of MySQL. (Hosting providers, especially inexpensive ones, are known for this.)

Use this query to find versions of various subsystems.

  show variables like "%version%";