Search Plugin Error HELP [SOLVED]

[kento]

when i search for eg. tekst it comes up with this:

CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended) Den specifikke fejl returneret af databasen, var: SELECT

e.id,
e.authorid,
a.realname AS author,
e.allow_comments,
e.moderate_comments,
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 JOIN serendipity_category c
ON ec.categoryid = c.categoryid LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE
(MATCH(title,body,extended) AGAINST('tekst*' IN BOOLEAN MODE))
AND isdraft = 'false' AND timestamp <= 1300838700 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id

ORDER BY timestamp DESC
LIMIT 15 / The used table type doesn't support FULLTEXT indexes

im running the latest version of php and mysql and use workbench to connect to the mysql, need help on how to turn on the fulltext search so the search can run on the blog.

grettings
kento

[garvinhicking]

Hi!

check your mySQL interface, it seems your database tables were created with InnoDB; you must use MYISAM for s9y, which is usually the default for mysql.

Regards,
Garvin

[kathleensd]

Hi!

check your mySQL interface, it seems your database tables were created with InnoDB; you must use MYISAM for s9y, which is usually the default for mysql.

Regards,
Garvin

I am having the same issue as the OP. Thanks for the information, even though it sounds all Greek to me. Maybe I would need my host's help.



how to get rid of blemishes
garlic breath tips
plr
private label rights