I just installed s9y on my public host, with success.
I inserted just two entries, then I tested the "Quick Search" plugin, and this is the error I get (sorry for the italian... it says: "Search function did not work as expected. Note for sysadm of this blog: this can happen for missing keys in your DB. On MySQL systems your DB account needs authorization to execute this:"):
Code: Select all
La funzione di ricerca non ha funztionato come previsto. Nota per l'amministratore di questo blog: ciò può succedere a causa di chiavi indice mancanti nel tuo database. Su sistemi MySQL il tuo account utente di database ha bisogno di privilegi per eseguire questa :
CREATE FULLTEXT INDEX entry_idx on s9y_entries (title,body,extended)
L'errore specifico restituito dal database è stato:
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
s9y_entries e
LEFT JOIN s9y_authors a
ON e.authorid = a.authorid
LEFT JOIN s9y_entrycat ec
ON e.id = ec.entryid
LEFT OUTER JOIN s9y_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN s9y_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN s9y_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN s9y_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN s9y_category c
ON ec.categoryid = c.categoryid LEFT JOIN s9y_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN s9y_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('un benvenuto*' IN BOOLEAN MODE))
AND isdraft = 'false' AND timestamp <= 1252406400 AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 15
/ Unknown column 'orderkey' in 'order clause'
This is the link to the blog, if useful: http://www.portovenere.biz/comitato-olivo
Thanks!
