Cannot get Quicksearch to work.

[savante21]

I have done a search and tried the methods that seem to work for most.

My table type is MyISAM.

MySQL version obtained by "Select version()" is 4.0.27-max-log

Running the query:

CREATE FULLTEXT INDEX entry_idx ON serendipity_entries(
title,
body,
EXTENDED
);

returns the error:

MySQL said: Documentation
#1061 - Duplicate key name 'entry_idx'

And I have verified there are full text indexes on the three relevant columns.

When I output the sql query onto the php page Im running serendipity on I receive the following:

SELECT e.id, e.authorid, a.realname AS author, a.email, e.timestamp, e.comments, e.title, e.body, e.extended, e.trackbacks, e.exflag FROM serendipity_entries e LEFT JOIN serendipity_authors a ON e.authorid = a.authorid LEFT JOIN serendipity_entrycat ec ON e.id = ec.entryid LEFT JOIN serendipity_category c ON ec.categoryid = c.categoryid LEFT JOIN serendipity_authorgroups AS acl_a ON acl_a.authorid = 1 LEFT JOIN serendipity_access AS acl_acc ON ( acl_acc.artifact_mode = 'read' AND acl_acc.artifact_type = 'category' AND acl_acc.artifact_id = c.categoryid ) WHERE (MATCH(title,body,extended) AGAINST('address')) AND isdraft = 'false' AND timestamp <= 1162328428 AND ( c.categoryid IS NULL OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0) OR ( acl_acc.artifact_id IS NULL ) ) GROUP BY e.id ORDER BY timestamp DESC LIMIT 15

When I plug that query into myPHPAdmin, it also returns an empty result set however there is clearly one row which contains the search term.

I'm really not quite sure how to proceed, I really would like the ability to search, what am I doing wrong?

[garvinhicking]

Hi!

The MySQL fulltextsearch only begins to work once you have a few non-dummy entries. The fulltextsearch only works if it does not return more than 75% of all your existing rows. If that threshold is reached, the fulltext search of mysql returns no rows.

HTH,
Garvin