Closed (fixed)
Project:
ContentO
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Minor
Category:
Support request
Assigned:
Reporter:
Created:
3 Sep 2006 at 02:47 UTC
Updated:
3 Sep 2006 at 18:23 UTC
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?
Comments
Comment #1
dahowlett commentedAnton was able to point me to 'full text indexing' issue. Thanks.