[Plugin: Yet Another Related Posts Plugin] No working anymore – get error: Can’t find FULLTEXT index

Also getting 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 ‘) group by object_id ) as poolblock on (wp_posts.ID = poolblock.object_id) ‘ at line 7]
SELECT *, (bodyscore * 1 + titlescore * 3 + tagscore * 0 + catscore * 0) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘udon yilan great diner pizza steak soup taipei store aaron meal real american 0 night half market classic taiwanese recommended’)) as bodyscore, (MATCH (post_title) AGAINST (‘ate food’)) 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 () 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 = ‘1648’) 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 = ‘1648’) group by object_id ) as matchcats on (wp_posts.ID = matchcats.object_id) where ((post_status IN ( ‘publish’, ‘static’ ) && ID != ‘1648’) and post_password =” and post_type IN (‘post’) and block IS NULL ) ) as rawscores where (bodyscore * 1 + titlescore * 3 + tagscore * 0 + catscore * 0) >= 5 order by score DESC limit 5

@gmustuk—thank you for these bugs! I see this happens when no disallowed cats or tags were set… I’ve fixed this bug and rereleased it as version 2.0.3. Please let me know if this resolves your issues!

mitcho

I upgraded to latest, but same thing happens for me.

WordPress database error: [Can’t find FULLTEXT index matching the column list]
SELECT *, (bodyscore * 3 + titlescore * 3 + tagscore * 1 + catscore * 1) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘udon yilan great diner pizza steak soup taipei store aaron meal real american 0 night half market classic taiwanese recommended’)) as bodyscore, (MATCH (post_title) AGAINST (‘ate food’)) 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 (1) 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 = ‘254’) 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 = ‘254’) group by object_id ) as matchcats on (wp_posts.ID = matchcats.object_id) where ((post_status IN ( ‘publish’, ‘static’ ) && ID != ‘254’) and post_date <= ‘2008-07-14 15:59:14’ and post_password =” and post_type IN (‘page’, ‘post’) and block IS NULL ) ) as rawscores where (bodyscore * 3 + titlescore * 3 + tagscore * 1 + catscore * 1) >= 5 and catscore

Mitcho, thanks for your work on YARPP 2.0…but alas I’m also experiencing this problem: No related posts displayed, and a similar database error (below).

I tested this using YARPP 2.0.3 on WP 2.5.1.

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 ')' at line 18]
select count(*) from (SELECT *, (bodyscore * 1 + titlescore * 1 + tagscore * 1 + catscore * 1) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('udon yilan great diner pizza steak soup taipei store aaron meal real american 0 night half market classic taiwanese recommended')) as bodyscore, (MATCH (post_title) AGAINST ('ate food')) as titlescore, ifnull(catscore,0) as catscore, ifnull(tagscore,0) as tagscore from wp_posts 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 = '192') 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 = '192') group by object_id ) as matchcats on (wp_posts.ID = matchcats.object_id) where ((post_status IN ( 'publish', 'static' ) && ID != '192') and post_password ='' and post_type IN ('post') ) ) as rawscores where (bodyscore * 1 + titlescore * 1 + tagscore * 1 + catscore * 1) >= 9 order by score DESC limit )

@gmustuk, @mayurj, please try this latest development version… I believe it fixes this fulltext index issue.

@sairuh, could you try this development version as well? I’m curious if that fixes the issue or not… if not, could you send me the error in an email ([email protected]) so I can better understand where the error is? (It says line 18, but the way it shows up in the forum here, I can’t tell where line 18 is!)

Thank you all!

mitcho

Hi all,

I’ve just released version 2.0.4, what 2.0 should have been. I worked with @phorbidden and hopefully worked out a number of kinks. Please let me know if this still does not solve your issues.

mitcho

hey mitcho,nice plugin but I get this error –

WordPress database error The used table type doesn’t support FULLTEXT indexes for query SELECT *, (bodyscore * 1 + titlescore * 1 + tagscore * 1 + catscore * 1) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘per blog money internet blogging backlinks making seo hosting knowledge selling http various url ads post reseller etc domain com’)) as bodyscore, (MATCH (post_title) AGAINST (‘online internet money making ways various’)) 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 (1,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 = ‘6’) 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 = ‘6’) group by object_id ) as matchcats on (wp_posts.ID = matchcats.object_id) where ((post_status IN ( ‘publish’, ‘static’ ) && ID != ‘6’) and post_date <= ‘2008-07-28 14:02:06’ and post_password =” and post_type IN (‘post’) and block IS NULL ) ) as rawscores where (bodyscore * 1 + titlescore * 1 + tagscore * 1 + catscore * 1) >= 5 order by score DESC limit 5 made by yarpp_related

Can you plz help?

@drraman007, what type of database server are you running, and what version?

It may be easier to diagnose this problem over skype or aim… if alright with you, I would appreciate it if you could email me with some contact info so I can try to resolve the issue with you in real time. Thanks!

mitcho