Тема: Ошибка 1214
Уважаемые!
Снова беда:
MySQL: MySQL query failed with error 1214 (The used table type doesn't support FULLTEXT indexes). The query was:CREATE TABLE `jos_jevents_vevdetail` ( `evdet_id` int(12) NOT NULL auto_increment, `rawdata` longtext NOT NULL, `dtstart` int(11) NOT NULL default '0', `dtstartraw` varchar(30) NOT NULL default '', `duration` int(11) NOT NULL default '0', `durationraw` varchar(30) NOT NULL default '', `dtend` int(11) NOT NULL default '0', `dtendraw` varchar(30) NOT NULL default '', `dtstamp` varchar(30) NOT NULL default '', `class` varchar(10) NOT NULL default '', `categories` varchar(120) NOT NULL default '', `color` varchar(20) NOT NULL default '', `description` longtext NOT NULL, `geolon` float NOT NULL default '0', `geolat` float NOT NULL default '0', `location` varchar(120) NOT NULL default '', `priority` tinyint(3) unsigned NOT NULL default '0', `status` varchar(20) NOT NULL default '', `summary` longtext NOT NULL, `contact` varchar(120) NOT NULL default '', `organizer` varchar(120) NOT NULL default '', `url` varchar(120) NOT NULL default '', `extra_info` varchar(240) NOT NULL default '', `created` varchar(30) NOT NULL default '', `sequence` int(11) NOT NULL default '1', `state` tinyint(3) NOT NULL default '1', `multiday` tinyint(3) NOT NULL default '1', `hits` int(11) NOT NULL default '0', `noendtime` tinyint(3) NOT NULL default '0', PRIMARY KEY (`evdet_id`), FULLTEXT KEY `searchIdx` (`summary`,`description`) )
Чует мое сердце, дело в FULLTEXT KEY `searchIdx` (`summary`,`description`).
Что поменять? Что делать-то?)