Error message starts: User warning: Can't find FULLTEXT index matching the column list query:
dahowlett - September 3, 2006 - 02:47
| Project: | ContentO |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | minor |
| Assigned: | dahowlett |
| Status: | closed |
Jump to:
Description
This is the full message:
user warning: Can't find FULLTEXT index matching the column list query: SELECT DISTINCT(r.nid), r.title, r.teaser, MATCH(r.body, r.title) AGAINST ('Test post Test post 1
') AS score FROM node_revisions r, node n WHERE r.nid = n.nid AND MATCH(r.body, r.title) AGAINST ('Test post Test post 1
') AND n.status <> 0 AND r.nid <> 11 AND n.type IN ('blog','forum','page','poll') ORDER BY score DESC, r.vid DESC LIMIT 0, 5 in /home/howlett/public_html/drupal/includes/database.mysql.inc on line 120.
Looks like a DB error to me but I'm not sure.
This occurs when I create pages and blog posts.
Any help or advice please?

#1
Anton was able to point me to 'full text indexing' issue. Thanks.