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
