Page 1 of 1

QuickSearch again and again(?)

Posted: Fri Feb 18, 2005 11:18 pm
by Roaster
Hi,

using the latest release and MySQL 4.1.8, PHP 5.0.3 (XAMPP installation on Windows XP Pro) I cannot get the quick search running at all.

No matter what search term I use (4 letters and more, using + > %) I always get no results back.

I've read at least all forum entries about this problem, I've created the appropriate fulltext index. The table is of type MyISAM.

I've tried the following query:

Code: Select all

SELECT id FROM serendipity_entries WHERE MATCH(title,body,extended) AGAINST('unicode')
but got no results back either.

To test this query I've add a simply entrie with title "unicode", body "using unicode" but no luck anyway.

Any hints on how to get this working?

Thx,
Roaster

Re: QuickSearch again and again(?)

Posted: Sat Feb 19, 2005 10:20 am
by garvinhicking
You need to have at least a couple of entries with at least a several dozen words before MySQL fulltext works. This is needed so that MySQL can build its index.

Regards,
Garvin