• I’m pretty excited about the features of your plugin, but when I install it and try to view a post, I get the following error:

    `

    WordPress database 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 ‘and catscore >= 1 and tagscore >= 1 order by post_date DESC limit 4’ at line 21]
    SELECT *, (bodyscore * 1 + titlescore * 3 + tagscore * 1 + catscore * 1) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘students learning lectures lecture student environment boring academics article internet experience engaging adams professor passive education research wireless teacher academic’)) as bodyscore, (MATCH (post_title) AGAINST (‘syndrome street sesame’)) as titlescore, ifnull(catscore,0) as catscore, ifnull(tagscore,0) as tagscore from wp_posts left join ( select count(*) as block, object_id from wp_term_relationships natural join wp_term_taxonomy natural join wp_terms where wp_terms.term_id in (4) group by object_id ) as poolblock on (wp_posts.ID = poolblock.object_id) left join ( select count(*) as tagscore, object_id from wp_term_relationships natural join wp_term_taxonomy where wp_term_taxonomy.taxonomy = ‘post_tag’ and wp_term_taxonomy.term_taxonomy_id in (select term_taxonomy_id from wp_term_relationships where object_id = ‘449’) group by object_id ) as matchtags on (wp_posts.ID = matchtags.object_id) left join ( select count(*) as catscore, object_id from wp_term_relationships natural join wp_term_taxonomy where wp_term_taxonomy.taxonomy = ‘category’ and wp_term_taxonomy.term_taxonomy_id in (select term_taxonomy_id from wp_term_relationships where object_id = ‘449’) group by object_id ) as matchcats on (wp_posts.ID = matchcats.object_id) where ((post_status IN ( ‘publish’, ‘static’ ) && ID != ‘449’) and post_password =” and post_type IN (‘post’) and block IS NULL ) ) as rawscores where (bodyscore * 1 + titlescore * 3 + tagscore * 1 + catscore * 1) >= and catscore >= 1 and tagscore >= 1 order by post_date DESC limit 4`

    Can you help me out? I’m afraid that I don’t know much about my host’s setup in terms of MySQL versions, although I can try to do a little research if that’s called for.

    Thanks in advance.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi @mfeldstein — I have a new version of the algorithm which may solve your issue… I would greatly appreciate it if you could beta it. Please email me and I will send you the beta.

    mitcho

    terriz

    (@terriz)

    Hi,
    I have an error similar to this. I’m using WP 2.2.1. When I activate the plugin, at the top of the options page I see this error:

    WordPress database 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 ' name from natural join where .taxonomy = 'category'' at line 1]
    select .term_id, name from natural join where .taxonomy = 'category'

    At the beginning of my posts is a much longer version of this error message. I’ve disabled the plugin for now…

    Thanks in advance

    @terriz – YARPP only supports WP versions 2.2 and above, as is stated on the plugin’s page. Sorry about that.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] SQL Syntax Error’ is closed to new replies.