WordPress.org

Support

Support » Plugins and Hacks » [Plugin: Yet Another Related Posts Plugin] MySQL errors in Apache error.log

[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_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)
  • 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?

    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?

    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.

    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…

    @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.