WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Yet Another Related Posts Plugin] WordPress database error (3 posts)

  1. When I go to the admin page for Yarpp and look under the section for Website display code example, I get the error below. Of note, everything seems to work just fine!

    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 'and date > date_sub(now(),interval 600 minute)' at line 1]
    select count(*) as count from wp_yarpp_related_cache where reference_ID = and date > date_sub(now(),interval 600 minute)
    
    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 1]
    select post_content from wp_posts where ID =
    
    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 1]
    select post_title from wp_posts where ID =
    
    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 '' ',' ') on duplicate key update date = now(), body = ' ', title = ' '' at line 1]
    insert into wp_yarpp_keyword_cache (ID,body,title) values (,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '
    
    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 'and ID != 0' at line 1]
    select ID from wp_yarpp_related_cache where reference_ID = and ID != 0
    
    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 1]
    delete from wp_yarpp_related_cache where reference_ID =
    
    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 1]
    select body from wp_yarpp_keyword_cache where ID =
    
    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 1]
    select post_content from wp_posts where ID =
    
    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 1]
    select post_title from wp_posts where ID =
    
    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 '' ',' ') on duplicate key update date = now(), body = ' ', title = ' '' at line 1]
    insert into wp_yarpp_keyword_cache (ID,body,title) values (,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '
    
    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 1]
    select body from wp_yarpp_keyword_cache where ID =
    
    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 1]
    select title from wp_yarpp_keyword_cache where ID =
    
    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 1]
    select post_content from wp_posts where ID =
    
    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 1]
    select post_title from wp_posts where ID =
    
    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 '' ',' ') on duplicate key update date = now(), body = ' ', title = ' '' at line 1]
    insert into wp_yarpp_keyword_cache (ID,body,title) values (,' ',' ') on duplicate key update date = now(), body = ' ', title = ' '
    
    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 1]
    select title from wp_yarpp_keyword_cache where ID =
    
    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 ' ID, (0+ (MATCH (post_content) AGAINST ('')) * 3+ (MATCH (post_title) AGAINST ('' at line 1]
    insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT , ID, (0+ (MATCH (post_content) AGAINST ('')) * 3+ (MATCH (post_title) AGAINST ('')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wp_posts left join wp_term_relationships as blockrel on (wp_posts.ID = blockrel.object_id) left join wp_term_taxonomy as blocktax using (<code>term_taxonomy_id</code>) left join wp_terms as blockterm on (blocktax.term_id = blockterm.term_id and blockterm.term_id in (242)) left JOIN wp_term_relationships AS thistag ON (thistag.object_id = ) left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = ) left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.taxonomy = 'category') where (post_status IN ( 'publish', 'static' ) and ID != '') and post_password ='' and post_type IN ('post') group by id having score >= 2.5 and count(blockterm.term_id) = 0 and COUNT( DISTINCT tagtax.term_taxonomy_id ) >= 1 order by score desc limit 10 on duplicate key update date = now()
    
    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 '0,0)' at line 1]
    insert into wp_yarpp_related_cache (reference_ID,ID,score) values (,0,0)
    
    <strong>Related posts:</strong><br /><ul><li><a href='http://myserver.net/2009/04/25/example-post-1/' rel='bookmark' title='Permanent Link: Example post 1'>Example post 1 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/26/example-post-2/' rel='bookmark' title='Permanent Link: Example post 2'>Example post 2 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/25/example-post-3/' rel='bookmark' title='Permanent Link: Example post 3'>Example post 3 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/25/example-post-4/' rel='bookmark' title='Permanent Link: Example post 4'>Example post 4 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/23/example-post-5/' rel='bookmark' title='Permanent Link: Example post 5'>Example post 5 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/02/16/example-post-6/' rel='bookmark' title='Permanent Link: Example post 6'>Example post 6 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/20/example-post-7/' rel='bookmark' title='Permanent Link: Example post 7'>Example post 7 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/22/example-post-8/' rel='bookmark' title='Permanent Link: Example post 8'>Example post 8 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/22/example-post-9/' rel='bookmark' title='Permanent Link: Example post 9'>Example post 9 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li><li><a href='http://myserver.net/2009/04/22/example-post-10/' rel='bookmark' title='Permanent Link: Example post 10'>Example post 10 <abbr title="0.000000 is the YARPP match score between the current entry and this related entry. You are seeing this value because you are logged in to WordPress as an administrator. It is not shown to regular visitors.">(0)</abbr></a></li></ul>
  2. webteamarm
    Member
    Posted 5 years ago #

    I'm actually getting the opposite - it looks fine on my admin page, but this error is popping up on my website:

    http://www.hairenik.com/weekly/2009/04/24/obama-will-not-acknowledge-armenian-genocide/

    I was on 3.02 which worked fine, I upgraded to 3.03 and received this error. Please help :)

    Thanks!

  3. @Ipstenu This bug has been fixed. Please try the latest version

Topic Closed

This topic has been closed to new replies.

About this Topic

  • RSS feed for this topic
  • Started 5 years ago by Ipstenu (Mika Epstein)
  • Latest reply from mitcho (Michael Yoshitaka Erlewine)
  • This topic is not resolved
  • WordPress version: 2.7