WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] [Plugin: Yet Another Related Posts Plugin] MySQL Error (11 posts)

  1. Jakets
    Member
    Posted 4 years ago #

    I have been getting this error, sometimes it changes slightly in the duplicate entry number. Is there any way to correct this?

    [24-Dec-2009 02:49:19] WordPress database error Duplicate entry '115-0' for key 1 for query insert into wp_yarpp_related_cache (reference_ID,ID,score) values (115,0,0) made by require, require_once, do_feed, do_action, call_user_func_array, do_feed_rss2, load_template, require_once, the_excerpt_rss, apply_filters, call_user_func_array, yarpp_rss_excerpt, yarpp_related, yarpp_cache_enforce

  2. Pinoy.ca
    Member
    Posted 4 years ago #

    Your Related Cache table is corrupted. I suggest you drop the table in PhpMyAdmin and rebuild the cache in YARRP Admin. In PhpMyAdmin, run this command:

    DROP TABLE wp_yarpp_related_cache;

    I do this all the time. I don't even include wp_yarrp_related_cache in my site backups.

    Like most things in WordPress and in life, DROP has no undo, so you may want to back up your database before you do this.

  3. Jakets, by chance, are you using the "cross-relate posts and pages" option?

  4. Jakets
    Member
    Posted 4 years ago #

    @ Pinoy.ca: Ok, I followed your instructions, but this did not help.

    @ mitchoyoshitaka: Nope, not using that option.

    Thanks, for the help. Any other ideas?

  5. @Jakets, just in case I made a fix in 3.1.3b3 just to make sure that that never happens... please try it out.

  6. Jakets
    Member
    Posted 4 years ago #

    @ mitchoyoshitaka: Thank you, I have installed the new version and will check it out for a couple days and report back. So far so good though, usually I would get the error fairly quickly and consistently. Time will tell. =D

  7. Great. :) Let me know if you notice anything as I hope to push 3.1.3 in the next day or two.

  8. Jakets
    Member
    Posted 4 years ago #

    @ mitchoyoshitaka: Looks good still, I have been putting it to the test and am happy to report I am error free. After about 6-7 hours of heavy use with several hundred users, all is well. =D

  9. Thanks! I'll push the release then.

  10. Floridan
    Member
    Posted 4 years ago #

    This plugin (3.1.7) causes a tremendous amount of MySQL requests and slows down posting and viewing of pages on my blog. Sometimes pages don't load for 2 minutes until I disable the plugin. I'm running WP 2.9.2. Does anyone know why this is happening with this plugin?

  11. @Floridan YARPP can produce some database-intensive queries. There are notes in the documentation (under FAQ) for improving performance.

Topic Closed

This topic has been closed to new replies.

About this Topic