Cannot get Quicksearch to work.
Posted: Tue Oct 31, 2006 10:19 pm
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:
When I output the sql query onto the php page Im running serendipity on I receive the following:
I'm really not quite sure how to proceed, I really would like the ability to search, what am I doing wrong?
My table type is MyISAM.
MySQL version obtained by "Select version()" is 4.0.27-max-log
Running the query:
returns the error:CREATE FULLTEXT INDEX entry_idx ON serendipity_entries(
title,
body,
EXTENDED
);
And I have verified there are full text indexes on the three relevant columns.MySQL said: Documentation
#1061 - Duplicate key name 'entry_idx'
When I output the sql query onto the php page Im running serendipity on I receive the following:
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.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
I'm really not quite sure how to proceed, I really would like the ability to search, what am I doing wrong?