Archive for May, 2006

WordPress Error – Related Posts

Monday, May 1st, 2006

WordPress database error: [Can’t find FULLTEXT index matching the column list]
SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST ('test page') AS score FROM wordpress_posts WHERE MATCH (post_name, post_content) AGAINST ('test page') AND post_date <= '2006-05-01 20:42:17' AND (post_status = 'publish' && ID != '1') AND post_password ='' ORDER BY score DESC LIMIT 5

If you have installed the WP Related Posts plugin for WordPress and you are getting the above error message then you need to carry out a quick database modification:

Modifying the database is simple. 
Open your database in phpMyAdmin (available in your cPanel as a rule)
Click on your database and click the SQL option.
Run the following SQL command (cut and paste it for simplicity):


ALTER TABLE 'wp_posts' ADD FULLTEXT 'post_related' (
'post_name' ,
'post_content'
)

http://wasabi.pbwiki.com/

%d bloggers like this: