ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

[chillyroll r]

Hi,

Below is my SHOW CREATE TABLE output:

CREATE TABLE `tbl_businesses_city` (
`business_id` int(20) NOT NULL AUTO_INCREMENT,
`business_name` varchar(255) CHARACTER SET latin1 NOT NULL,
`business_type_id` int(20) NOT NULL,
`business_user_id` bigint(20) NOT NULL,
`address1` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`address2` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`city_id` int(20) NOT NULL,
`state_code` varchar(2) CHARACTER SET latin1 DEFAULT NULL,
`zip_code` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
`business_phone` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
`business_secondary_phone` varchar(20) DEFAULT NULL,
`business_tertiary_phone` varchar(20) DEFAULT NULL,
`website` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`business_info` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`latitude` double DEFAULT '0',
`longitude` double DEFAULT '0',
`created_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_deleted` enum('Y','N') DEFAULT 'N',
`source_id` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`city` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`is_rated` char(1) DEFAULT 'N',
`source_key_id` varchar(50) NOT NULL,
`business_type_id_back` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`business_id`),
KEY `business_name` (`business_name`),
KEY `business_type_id` (`business_type_id`),
KEY `city_id` (`city_id`),
KEY `latitude` (`latitude`),
KEY `longitude` (`longitude`),
KEY `source_id` (`source_id`),
KEY `state_code` (`state_code`),
KEY `idx_zip_code` (`zip_code`),
FULLTEXT KEY `bus_name_type_fulltxt_idx` (`business_name`,`business_info`)
) ENGINE=MyISAM AUTO_INCREMENT=18020371 DEFAULT CHARSET=utf8 |

I am looking to partition this table on city_id but I am getting a below error when trying to create partitions.

mysql> alter table tbl_businesses_city partition by hash(city_id) partitions 4;
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

My table engine is MyISAM only. So not sure why is this popping up.

MySQL Version is 5.1.33-community.

Any idea?

Thanks