WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Yet Another Related Posts Plugin] MySQL errors in Apache error.log (6 posts)

  1. msebald
    Member
    Posted 5 years ago #

    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.

  2. 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?

  3. msebald
    Member
    Posted 5 years ago #

    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?

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

  5. msebald
    Member
    Posted 5 years ago #

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

  6. @msebald sorry I've been away from the forum for a while. Are you still getting the errors?

Topic Closed

This topic has been closed to new replies.

About this Topic