Title: [Plugin: Yet Another Related Posts Plugin] MySQL Error Last modified: August 19, 2016 --- # [Plugin: Yet Another Related Posts Plugin] MySQL Error * Resolved [Jakets](https://wordpress.org/support/users/jakets/) * (@jakets) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/) * 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) * [pinoyca](https://wordpress.org/support/users/pinoyca/) * (@pinoyca) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320686) * 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. * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320691) * Jakets, by chance, are you using the “cross-relate posts and pages” option? * Thread Starter [Jakets](https://wordpress.org/support/users/jakets/) * (@jakets) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320715) * @ 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? * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320730) * [@jakets](https://wordpress.org/support/users/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](https://wordpress.org/support/users/jakets/) * (@jakets) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320732) * @ 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 * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320735) * 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](https://wordpress.org/support/users/jakets/) * (@jakets) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320739) * @ 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 * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [16 years, 5 months ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320744) * Thanks! I’ll push the release then. * [floridan](https://wordpress.org/support/users/floridan/) * (@floridan) * [16 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320826) * 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? * [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * (@mitchoyoshitaka) * [16 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320828) * [@floridan](https://wordpress.org/support/users/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. * 10 replies * 4 participants * Last reply from: [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/) * Last activity: [16 years ago](https://wordpress.org/support/topic/plugin-yet-another-related-posts-plugin-mysql-error-1/#post-1320828) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics