MySQL Forums
Forum List  »  Full-Text Search

Err 1191 Can't find FULLTEXT .. need explanation please
Posted by: Luca Borrione
Date: October 19, 2011 02:44AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Err 1191 Can't find FULLTEXT .. need explanation please
7515
October 19, 2011 02:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.