Got a problem with my fulltext searches. Here is the structure of the table as displayed in MySQLyog...
Column Information For - robeson_robesondb.robeson_inv
------------------------------------------------------
Field Type Null Key Default Extra Privileges
------------ ------- ------ ------ ------- --------------
-------------------------------
ID int(11) PRI (NULL) auto_increment
select,insert,update,references
manufacturer text YES MUL (NULL)
select,insert,update,references
model text YES (NULL)
select,insert,update,references
specs text YES MUL (NULL)
select,insert,update,references
qty int(11) YES (NULL)
select,insert,update,references
picture text YES (NULL)
select,insert,update,references
Index Information For - robeson_robesondb.robeson_inv
-----------------------------------------------------
Table Non_unique Key_name Seq_in_index Column_name
Collation Cardinality Sub_part Packed Null Index_type Comment
----------- ---------- ------------ ------------ ------------
--------- ----------- -------- ------ ------ ---------- -------
robeson_inv 0 PRIMARY 1 ID A
949 (NULL) (NULL) BTREE
robeson_inv 0 ID 1 ID A
949 (NULL) (NULL) BTREE
robeson_inv 1 specs 1 specs A
316 (NULL) (NULL) YES FULLTEXT
robeson_inv 1 manufacturer 1 manufacturer A
316 (NULL) (NULL) YES FULLTEXT
DDL Information For - robeson_robesondb.robeson_inv
---------------------------------------------------
Table Create Table
-----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
robeson_inv CREATE TABLE `robeson_inv` (
`ID` int(11) NOT NULL auto_increment,
`manufacturer` text,
`model` text,
`specs` text,
`qty` int(11) default NULL,
`picture` text,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`),
FULLTEXT KEY `specs` (`specs`),
FULLTEXT KEY `manufacturer` (`manufacturer`)
) TYPE=MyISAM
As you can see, I've created a fulltext index for the "manufacturer" field.
However, when I conduct a search, I get the following error message
returned...
Can't find FULLTEXT index matching the column list
What's the problem?
Thanx in advance,
Robb
--
Robb Kerr
Digital IGUANA
Helping Digital Artists Achieve their Dreams
http://www.digitaliguana.com
http://www.cancerreallysucks.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
