[Plugin: Yet Another Related Posts Plugin] MySQL errors in Apache error.log
-
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_enforceI 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,
MartinPS: Version of plugin 3.0.5, version of WordPress 2.7.1.
Viewing 5 replies - 1 through 5 (of 5 total)
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.