Title: [Plugin: Yet Another Related Posts Plugin] MySQL errors in Apache error.log Last modified: August 19, 2016 --- # [Plugin: Yet Another Related Posts Plugin] MySQL errors in Apache error.log * [msebald](https://wordpress.org/support/users/msebald/) * (@msebald) * [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/) * I’m experiencing these errors several times a day in error.log of Apache: * ``` [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: WordPress-Datenbankfehler 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 '5 order by score desc limit 5 on duplicate key update date = now()' at line 15 f\xc3\xbcr die Abfrage insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 284, ID, (0+ (MATCH (post_content) AGAINST ('haus danke tobi bildes groe hier fr version link gefunden bookmarken com leenks hats wnde schilder hermacht ausschaut wenig eher ')) * 1+ (MATCH (post_title) AGAINST ('nummernschilderhaus ')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: from wp_posts [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 284 ) [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tleft JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tAND tagrel.object_id = wp_posts.ID) [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tleft JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tAND tagtax.taxonomy = 'post_tag') [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 284 ) [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tleft JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tAND catrel.object_id = wp_posts.ID) [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tleft JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: \t\tAND cattax.taxonomy = 'category') [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: where (post_status IN ( 'publish', 'static' ) and ID != '284') and post_date <= NOW() and post_password ='' and post_date > date_sub(now(), interval 12 month) and post_type IN ('post', 'page') [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: group by id [Wed May 20 09:06:57 2009] [warn] mod_fcgid: stderr: having score >= 2,5 order by score desc limit 5 on duplicate key update date = now() in require, require_once, include, the_content, apply_filters, call_user_func_array, yarpp_default, yarpp_related, yarpp_cache_enforce ``` * I cannot see any problems on the website itself, but it seems to be a problem somewhere. * Can somebody help? Or is this a bug somehow? If yes, I can test and provide further information of needed. * Regards, Martin * PS: Version of plugin 3.0.5, version of WordPress 2.7.1. Viewing 5 replies - 1 through 5 (of 5 total) * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/#post-1082737) * Hm, yes, this does indeed seem to be a bug of sorts. It’s trying to compare the score to the value “2,5” in the sql… can you check in your YARPP options and see what you’ve entered for the match threshold? Can you try changing its value once? * Thread Starter [msebald](https://wordpress.org/support/users/msebald/) * (@msebald) * [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/#post-1082787) * The value for match threshold was 5 (isn’t that the default value?). I changed it to 6 and now I have to wait if the error still occurs. It occurs only some times a day. How can I produce the error? Looking at a single post? * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/#post-1082798) * You can go to YARPP options and try rebuilding the cache manually in the “cache status” box… this’ll force it to execute that SQL query and you can see if it works or not. * Thread Starter [msebald](https://wordpress.org/support/users/msebald/) * (@msebald) * [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/#post-1082821) * Ah thanks. I did this yesterday evening, no errors in error.log. Then I set the value back from 6 to 5 and rebuild the cache again. No errors. * Now I see errors again in the log, from this morning… * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/#post-1082859) * [@msebald](https://wordpress.org/support/users/msebald/) sorry I’ve been away from the forum for a while. Are you still getting the errors? Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘[Plugin: Yet Another Related Posts Plugin] MySQL errors in Apache error. log’ is closed to new replies. * 5 replies * 2 participants * Last reply from: [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * Last activity: [17 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-errors-in-apache-errorlog/#post-1082859) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics