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

dahowlett’s picture

Priority: Normal » Minor
Status: Active » Closed (fixed)

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