Kommentare von – Serendipity

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 entryidx on serendipityentries (title,body,extended)

The specific error returned by the database was:

SELECT e.id, e.authorid, a.realname AS author, e.allowcomments, e.moderatecomments, a.email, e.timestamp, e.comments, e.title, e.body, e.extended, e.trackbacks, e.exflag, e.isdraft, e.last_modified, a.username AS loginname

                  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 OUTER JOIN serendipity_entryproperties ep_access
                                          ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')

LEFT JOIN serendipityentryproperties epsticky ON (e.id = epsticky.entryid AND epsticky.property = 'epissticky') WHERE (MATCH(title,body,extended) AGAINST('ubuntu*' IN BOOLEAN MODE)) AND isdraft = 'false' AND timestamp

Thanks for your quick reply and fix.

It's salted, so we could've even stuck to md5.