[Plugin: Yet Another Related Posts Plugin] MySQL Error

  • Resolved Jakets

    (@jakets)


    14 years, 10 months 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

Viewing 10 replies - 1 through 10 (of 10 total)

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

    Jakets, by chance, are you using the “cross-relate posts and pages” option?

    Thread Starter Jakets

    (@jakets)

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

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

    Thread Starter Jakets

    (@jakets)

    @ 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

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

    Thread Starter Jakets

    (@jakets)

    @ 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

    Thanks! I’ll push the release then.

    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?

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] MySQL Error’ is closed to new replies.