WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Database Errors using YARPP / Yet Another Related Posts Plugin (5 posts)

  1. thephpoldbie
    Member
    Posted 4 years ago #

    Tried running version 3.0.6 and 3.0.13 and upon activation I get the following in the wp-admin area on the plugins page:

    WordPress database error: [Duplicate key name 'yarpp_title']
    ALTER TABLE wp_posts ADD FULLTEXT yarpp_title ( post_title)

    WordPress database error: [Duplicate key name 'yarpp_content']
    ALTER TABLE wp_posts ADD FULLTEXT yarpp_content ( post_content)

    And on all my posts I get this annoying message:

    WordPress database error: [Table 'MyDBase.wp_yarpp_related_cache' doesn't exist]
    select count(*) as count from wp_yarpp_related_cache where reference_ID = 1607 and date > date_sub(now(),interval 600 minute)

    WordPress database error: [Unknown system variable 'names']
    set names utf8

    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 = 'video link code m]
    insert into wp_yarpp_keyword_cache (ID,body,title) values (1607,'stuff clothes things cost dollars cents American ','Bargins sales stores ') on duplicate key update date = now(), body = 'stuff clothes things cost dollars cents Americangured ', title = 'Bargins sales stores '

    WordPress database error: [Table 'MyDBase.wp_yarpp_related_cache' doesn't exist]
    select ID from wp_yarpp_related_cache where reference_ID = 1607 and ID != 0

    WordPress database error: [Table 'MyDBase.wp_yarpp_related_cache' doesn't exist]
    delete from wp_yarpp_related_cache where reference_ID = 1607

    WordPress database error: [Table 'MyDBase.wp_yarpp_keyword_cache' doesn't exist]
    select body from wp_yarpp_keyword_cache where ID = 1607

    WordPress database error: [Unknown system variable 'names']
    set names utf8

    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 = 'video link code m]
    insert into wp_yarpp_keyword_cache (ID,body,title) values (1607,'stuff clothes things cost dollars cents American ','Bargins sales stores ') on duplicate key update date = now(), body = 'stuff clothes things cost dollars cents Americangured ', title = 'Bargins sales stores '

    WordPress database error: [Table 'MyDBase.wp_yarpp_keyword_cache' doesn't exist]
    select body from wp_yarpp_keyword_cache where ID = 1607

    WordPress database error: [Table 'MyDBase.wp_yarpp_keyword_cache' doesn't exist]
    select title from wp_yarpp_keyword_cache where ID = 1607

    WordPress database error: [Unknown system variable 'names']
    set names utf8

    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 = 'video link code m]
    insert into wp_yarpp_keyword_cache (ID,body,title) values (1607,'stuff clothes things cost dollars cents American ','Bargins sales stores ') on duplicate key update date = now(), body = 'stuff clothes things cost dollars cents Americangured ', title = 'Bargins sales stores '

    WordPress database error: [Table 'MyDBase.wp_yarpp_keyword_cache' doesn't exist]
    select title from wp_yarpp_keyword_cache where ID = 1607

    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()' at line 15]

    Any help would be greatly appreciated with this. I'm on WP 2.7.1 and definitely need help since this plugin is very useful looking :(

  2. thephpoldbie
    Member
    Posted 4 years ago #

    Never could figure this out for the life of me, so I just jumped on this Similar Posts plugin which works the same way as far as generating links based on title + content + tags with enough options to keep me happy. Need to install a library plugin which is also on that site but afterwards everything works the way I want it. While this issue itself with YARPP isn't exactly resolved - i found this similar one to be a helluva workaround

  3. @thephpoldbie - it seems like you aren't using an appropriate version of MySQL. What MySQL version is that? YARPP requires at least 4.1.

  4. dannoll
    Member
    Posted 4 years ago #

    I just installed YARPP. A great plugin, except that I'm noticing my error logs full of MySQL errors as well.

    I'm running WP 2.91, YARPP 3.1.3 and my server runs MySQL 5.1.3.

    Examples of the errors:

    ---
    [30-Jan-2010 21:21:04] 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 for query set names made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, yarpp_cache_keywords

    and

    [30-Jan-2010 16:17:02] 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 for query set names made by include, do_meta_boxes, call_user_func, yarpp_metabox, yarpp_related, yarpp_cache_enforce, yarpp_cache_keywords

  5. dannoll, as I think I mentioned to you elsewhere, this should be fixed in the latest beta:

    http://downloads.wordpress.org/plugin/yet-another-related-posts-plugin.3.1.4b4.zip

Topic Closed

This topic has been closed to new replies.

About this Topic