Search error

[Guest]

Hello, when I search something on my log I get this error.... Does someone know how I can fix this? Thanks!



CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)
De foutmelding van de database is:
SELECT
e.id,
e.author,
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

WHERE
MATCH(title,body,extended) AGAINST('asdg')
AND isdraft = 'false' AND timestamp <= 1114410825
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Can't find FULLTEXT index matching the column list

[garvinhicking]

The error message already says which SQL command you need to execute

Please search the forums, there are several threads about this problem.

Regards,
Garvin