I just installed a plugin for WordPress that displays the related entries to a post. Unfortunately, I got the following error:
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
SELECT ID, post_title, post_content,MATCH (post_name, post_content)
AGAINST (’wordpress skins’) AS score FROM wp_posts WHERE MATCH
(post_name, post_content) AGAINST (’wordpress skins’) AND post_date < =
‘2006-02-19 08:27:18′ AND (post_status IN ( ‘publish’, ’static’ ) && ID
!= ‘96′) AND post_password =” ORDER BY score DESC LIMIT
I have reported about this error to the author of the plugin and hopefuly correct it soon.
I have put the link to the plugin’s page, incase you want to try it.
Update: I have fixed the error. Actually the error was because I had left the number of posts to show field in the options page empty.
Download WordPress Related Entries 2.0