Static Page plugin

Having trouble installing serendipity?
Post Reply
joey
Regular
Posts: 12
Joined: Sun Mar 26, 2006 3:05 pm

Static Page plugin

Post by joey »

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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Static Page plugin

Post by garvinhicking »

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply