Page 1 of 1
Quotation Marks in the Quick Search cause a problem..
Posted: Fri Dec 09, 2005 11:43 pm
by Mr. Tony
Hello there,
I am new to serendipity but like it very much and want to use it for my blog. But on my testing of my demo site I notice when I put something in quotes in the search box it breaks...
http://www.fattony.com/serendipity/
example might be "dogs" or "cats" etc.
Please try it and see if you guys can make some sense of the error and tell me what might be set wrong?
Much appreciated.
Tony
Posted: Sat Dec 10, 2005 8:07 am
by Col. Kurtz
I dont see any errors, using firefox 1.5
Posted: Sat Dec 10, 2005 5:03 pm
by Wizard
I saw your quoted "green dogs are fun to type about in fake blogs" in IE.
But this is what I get when I search for it.
Code: Select all
The search function did not work as expected. Notice for the administrator of this blog: This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query:
CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)The specific error returned by the database was:
SELECT
e.id,
e.authorid,
a.realname AS author,
a.email,
ec.categoryid,
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 = 0
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('"green dogs are fun to type about in fake blogs" ' IN BOOLEAN MODE)
AND isdraft = 'false' AND timestamp <= 1134230231 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15 / You have an error in your SQL syntax near 'BOOLEAN MODE)
AND isdraft = 'false' AND timestamp ' at line 30
Posted: Sat Dec 10, 2005 8:19 pm
by garvinhicking
Your MySQL version is too old and does not support BOOLEAN fulltext search. You need to upgrade your MySQL version for that to work.
Regards,
Garvin