Search Plugin Error HELP [SOLVED]
Posted: Wed Mar 23, 2011 1:20 am
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
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
Maybe I would need my host's help. 