"Can't find FULLTEXT index matching the column list query: SELECT"

By blogeration on 8 Oct 2005 at 11:50 UTC

Installed drupal yesterday...
Posting content to my front page, in admin across the top I am getting this error message:

The page still appears ok, but I cannot figure out what's causing the message.
Advice most welcome :)

Comments

tassoman commented 23 October 2005 at 17:53

I got the same error inserting a new topic in forums, but I've upgraded from 4.5.0 to 4.6.3

geek, net addicted user

deeptii commented 17 November 2005 at 03:13

u got this error mainly because u installed the "Similar Entries" module, and u need to run this SQL:

ALTER TABLE node ADD FULLTEXT(title, body);

chueewowee commented 17 June 2006 at 02:02

the ReadMe.txt to the Similar module advises: ALTER TABLE < strong >node_revisions ADD FULLTEXT(title, body);

You say
ALTER TABLE node ADD FULLTEXT(title, body);

Which is correct?

chueewowee commented 17 June 2006 at 02:08

I had success in removing the error under discussion by running the SQL query:
ALTER TABLE node_revisions ADD FULLTEXT(title, body);

as given in the Similar module ReadMe.txt

alliax commented 24 August 2006 at 17:15

Thank you for this thread and to Google, saved me a long long time!