Serendipity Forums

Posted: **Sun Mar 26, 2006 3:09 pm**

Hiya iv just upgraded the static Page plugin and when i do a search on my blog i get this message at the bottom of the page

<pre>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('books') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC</pre> / Can't find FULLTEXT index matching the column list

im not sure what this means

Posted: **Sun Mar 26, 2006 10:30 pm**

Hi Joey!

Sadly this was a small bug in the current version of the plugin - please read http://www.s9y.org/forums/viewtopic.php?p=26261#26261 for the SQL query you need to execute to fix that:

Code: Select all

CREATE FULLTEXT INDEX staticentry_idx on serendipity_staticpages (headline, content);

Best regards,
Garvin

Serendipity Forums

Static Page plugin

Static Page plugin

Re: Static Page plugin