Features / Usability

Features / Usability

serch box

posts: 20 Italy

hi, i have a problem whit mod-search_box.. when i search the response is:
Warning: mysql error: Can't find FULLTEXT index matching the column list in query:
SELECT COUNT(*) FROM tiki_blog_posts p LEFT JOIN tiki_blogs b ON b.blogId = p.blogId WHERE b.use_find = "y" AND MATCH(p.data) AGAINST ('s')
in /http/www/portale/tikiwiki-1.8/lib/tikidblib.php on line 125

$result is false
$result is empty

somebody have a suggestion for me???

posts: 2881 United Kingdom

See the same post from user phpsharma,

replace your search module with the search_new module


posts: 32 Greece

It' s too late of course for an advice but I think I have to post this for general use.

So, this error depends on the version you have installed. There is a full text index on table tiki_blog_posts by the name ft. If this index contains only data column you must drop it and build a new one full text too, containing data and title columns.

Your problem will be resovled.