Page 2 of 2
Posted: Tue Jan 18, 2005 11:12 pm
by C_Calav
here is the error i am gettoing in mySQL
Error
SQL-query:
SELECT P_Name,
MATCH (
P_Name, P_Desc
)
AGAINST (
'army'
)
FROM planes
LIMIT 0 , 30
MySQL said:
#1191 - Can't find FULLTEXT index matching the column list
anyone help me out?
its only when i search with both feilds, singly they work fine
Posted: Tue Jan 18, 2005 11:47 pm
by feyd
I still think the table needs to be created with both as a single full text index:
FULLTEXT( P_Name, P_Desc )
or whatever it is..
Posted: Wed Jan 19, 2005 2:10 pm
by C_Calav
thanx feyd,
how am i going to create the table again when i have lots of info already init?
cheers
Posted: Wed Jan 19, 2005 2:37 pm
by feyd
total guess on this one; use phpMyAdmin to remove the fulltext marks on each, then add them back in at the same time.. this may have phpMyAdmin "fix" it..
you may need to make an ALTER TABLE call with the change..
last chance is to export the table's contents, drop it and recreate the table with both..
Posted: Wed Jan 19, 2005 3:22 pm
by JAM
Code: Select all
CHANGE COLUMN field field longtext;
What I do in one project where I need (sigh) to change a varchar to text field and keep content.
Posted: Tue Jan 25, 2005 12:08 am
by C_Calav
ok,
i re created the table with fulltext on from the create stage and i got the same error, took one of the fulltext off and it worked.
then i added the fulltext back on to the second feild and gave me the same error.
anyone ran into problems or know how to do a search on two feilds on your table?
thanx