Quotation Marks in the Quick Search cause a problem..

[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

[Col. Kurtz]

I dont see any errors, using firefox 1.5

[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

[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