Serendipity Forums

Using quicksearch, everything seems to work fine as long as their are no characters other than letters/numbers/space in the search string. Actually, I'm guessing about that but a few tests seem to indicate that.

If I search for
water filter
it works fine.

If I search for
"water filter"
or
water+filter
(note the quotes and/or plus sign) it gives me the following error:

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 quagmire_entries (title,body,extended)

I am seeing this on two blogs, using 0.9 and 0.91 (same error on both versions) and PHP 4.3.11
The MySQL user has full privilege for the entire database as far as I know.

What am I missing?

Thanks.

At the end of the error notice you should see the ACTUAL MySQL error message.

If wrapping your search terms with Quotes, Serendipity assumes that you want to use Boolean fulltext features. Those only work with MySQL 4.1.x (don't know the exact version).

Best regards,
Garvin