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
Static Page plugin
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Static Page plugin
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:
Best regards,
Garvin
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);
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/
# 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/