[SOLVED] Can't find FULLTEXT index matching the column list

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mudkicker
Forum Contributor
Posts: 479
Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:

[SOLVED] Can't find FULLTEXT index matching the column list

Post by mudkicker »

This is my SQL code:

Code: Select all

SELECT *, MATCH (keywords) AGAINST ('".addslashes($query)."') AS score FROM mudcrawl WHERE MATCH (keywords) AGAINST ('".addslashes($query)."' IN BOOLEAN MODE)
And this is SHOW CREATE of the table - > mudcrawl :

Code: Select all

# Host: localhost
# Database: mudsearch
# Table: 'mudcrawl'
# 
CREATE TABLE `mudcrawl` (
  `filename` varchar(200) default NULL,
  `fileurl` varchar(200) default NULL,
  `keywords` longtext,
  FULLTEXT KEY `keywords` (`keywords`,`filename`)
) TYPE=MyISAM;
So it give me the error

Code: Select all

Can't find FULLTEXT index matching the column list
if I want to query that sql. I did't understand what to do, because i already gave the FULLTEXT index to all my columns.. What is wrong with it?
Last edited by mudkicker on Thu Oct 07, 2004 4:47 pm, edited 1 time in total.
User avatar
mudkicker
Forum Contributor
Posts: 479
Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:

Post by mudkicker »

Ok i have solved my problem by addin seperate fulltext indexes to my columns. i can do it bacuse i use boolean mode... look @mysql manual ;)
Post Reply