Err 1191 Can't find FULLTEXT .. need explanation please
Hello,
Trying to use MATCH on an already created table,
CREATE TABLE `fcrt_site_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(20) NOT NULL DEFAULT 'document',
`contentType` varchar(50) NOT NULL DEFAULT 'text/html',
`pagetitle` varchar(255) NOT NULL DEFAULT '',
`longtitle` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) DEFAULT '',
`link_attributes` varchar(255) NOT NULL DEFAULT '',
`published` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pub_date` int(20) NOT NULL DEFAULT '0',
`unpub_date` int(20) NOT NULL DEFAULT '0',
`parent` int(10) NOT NULL DEFAULT '0',
`isfolder` tinyint(1) unsigned NOT NULL DEFAULT '0',
`introtext` text,
`content` mediumtext,
`richtext` tinyint(1) unsigned NOT NULL DEFAULT '1',
`template` int(10) NOT NULL DEFAULT '0',
`menuindex` int(10) NOT NULL DEFAULT '0',
`searchable` tinyint(1) unsigned NOT NULL DEFAULT '1',
`cacheable` tinyint(1) unsigned NOT NULL DEFAULT '1',
`createdby` int(10) NOT NULL DEFAULT '0',
`createdon` int(20) NOT NULL DEFAULT '0',
`editedby` int(10) NOT NULL DEFAULT '0',
`editedon` int(20) NOT NULL DEFAULT '0',
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`deletedon` int(20) NOT NULL DEFAULT '0',
`deletedby` int(10) NOT NULL DEFAULT '0',
`publishedon` int(20) NOT NULL DEFAULT '0',
`publishedby` int(10) NOT NULL DEFAULT '0',
`menutitle` varchar(255) NOT NULL DEFAULT '',
`donthit` tinyint(1) unsigned NOT NULL DEFAULT '0',
`privateweb` tinyint(1) unsigned NOT NULL DEFAULT '0',
`privatemgr` tinyint(1) unsigned NOT NULL DEFAULT '0',
`content_dispo` tinyint(1) NOT NULL DEFAULT '0',
`hidemenu` tinyint(1) unsigned NOT NULL DEFAULT '0',
`class_key` varchar(100) NOT NULL DEFAULT 'modDocument',
`context_key` varchar(100) NOT NULL DEFAULT 'web',
`content_type` int(11) unsigned NOT NULL DEFAULT '1',
`uri` text,
`uri_override` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `alias` (`alias`),
KEY `published` (`published`),
KEY `pub_date` (`pub_date`),
KEY `unpub_date` (`unpub_date`),
KEY `parent` (`parent`),
KEY `isfolder` (`isfolder`),
KEY `template` (`template`),
KEY `menuindex` (`menuindex`),
KEY `searchable` (`searchable`),
KEY `cacheable` (`cacheable`),
KEY `hidemenu` (`hidemenu`),
KEY `class_key` (`class_key`),
KEY `context_key` (`context_key`),
KEY `uri` (`uri`(333)),
KEY `uri_override` (`uri_override`),
FULLTEXT KEY `content_ft_idx` (`pagetitle`,`longtitle`,`description`,`introtext`,`content`),
FULLTEXT KEY `name_of_index` (`pagetitle`,`longtitle`,`content`),
FULLTEXT KEY `pagetitle` (`pagetitle`,`longtitle`,`content`),
FULLTEXT KEY `pagetitle_2` (`pagetitle`,`longtitle`,`content`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8
With just a query test:
SELECT content
FROM fcrt_site_content
WHERE MATCH (content) AGAINST ('keyword')
Always receiving this error
#1191 - Can't find FULLTEXT index matching the column list
I googled a lot for a solution and I:
1. altered my table with
ALTER TABLE fcrt_site_content ADD FULLTEXT(content)
and the query was successfully completed
2. checked with phpmyadmin on the table structure
that the fulltext icon (the last one) of the 'content' column
was active and it was
3. checked that my table was created with MyISAM and it was,
as shown in the above create table.
Then I kept on receiving the same error UNTIL I clicked on the
mentioned fulltext icon of phpmyadmin.
Then the query test could be executed successfully.
I would like to know WHY ...
Is this happened to any of you?
Thanks in advance for any explanation
Cheers