Page 1 of 1

Quick Search plugin error

Posted: Tue Sep 08, 2009 12:46 pm
by marcolino1961
Hi
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'


Any hints?
This is the link to the blog, if useful: http://www.portovenere.biz/comitato-olivo
Thanks!

Re: Quick Search plugin error

Posted: Tue Sep 08, 2009 12:59 pm
by garvinhicking
Hi!

Did you by chance install the serendipity 1.5 beta release? If so, this one had a bug in the quicksearch - it can be fixed by uploading a recent snapshot. The bug will of course also be fixed in the final 1.5 release.

Thank you for reporting this!

Regards,
Garvin

Re: Quick Search plugin error

Posted: Tue Sep 08, 2009 3:41 pm
by marcolino1961
Hi!
Yes, I did! It's 1.5-beta1 ...
I just uploaded s9y_200909072342.tar.gz (yesterday, 23:42, 5.02 MB), and now everything's ok!
Thanks again!!!
Sorry for posting about a beta version problem...
Keep up the good work!

Re: Quick Search plugin error

Posted: Tue Sep 08, 2009 8:51 pm
by stm999999999
marcolino1961 wrote:Sorry for posting about a beta version problem...
Keep up the good work!


Hey, if no one posts about beta problems, no one can fix it! :)