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
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

dahowlett - September 3, 2006 - 18:23
Priority:normal» minor
Status:active» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.