Page 1 of 1

Quickserch and FAQ

Posted: Sat Mar 25, 2006 8:04 pm
by Col. Kurtz
1) Under my quicksearch results this text appears:
SELECT s.*, a.realname FROM serendipity_staticpages AS s LEFT OUTER JOIN serendipity_authors AS a ON a.authorid = s.authorid WHERE MATCH(headline,content) AGAINST('Jahre') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC</pre> / Can't find FULLTEXT index matching the column list
Warning: Smarty error: unable to read resource: "file:/www/htdocs/hehe/humppa/plugins/serendipity_event_staticpage/plugin_staticpage_searchresults.tpl" in /www/htdocs/hehe/humppa/bundled-libs/Smarty/libs/Smarty.class.php on line 1088
?

2) Is it possible to make the faq entries searchable? Seems to make sense to me.

Re: Quickserch and FAQ

Posted: Sun Mar 26, 2006 10:21 pm
by garvinhicking
Hi!

The most recent static page update should automatically add a new fulltext index on your database:

Code: Select all

CREATE FULLTEXT INDEX staticentry_idx on serendipity_staticpages (headline, content);
Can you check if that command can be executed with the s9y database account?

It should've been automagically created; if not it means your user might be lacking the INDEX privilege.

If you were able to execute the query above, could you please check what the "db_built" config variable of your installation is? You can get it with this SQL statement:

Code: Select all

SELECT * FROM serendipity_config WHERE name LIKE '%serendipity_event_staticpage:%db_built%'

UPDATE: It seems that when installing the current staticpage plugin version from fresh, this fulltext index was not properly created. I've just patched that to create it on fresh installs. Sorry for that. :(

Then it seems your plugin does not have the "plugin_staticpage_searchresult.tpl" file. But that is bundled with CVS. Please check why you don't have that file?
2) Is it possible to make the faq entries searchable? Seems to make sense to me.
Maybe falk can loose a word on that. :)

Regards,
Garvin

Posted: Mon Mar 27, 2006 10:52 am
by Col. Kurtz
1) ok a re-install fixed this.
2) Ill sent a message to Falk.