Title: Database Errors using YARPP / Yet Another Related Posts Plugin
Last modified: August 19, 2016

---

# Database Errors using YARPP / Yet Another Related Posts Plugin

 *  Resolved [thephpoldbie](https://wordpress.org/support/users/thephpoldbie/)
 * (@thephpoldbie)
 * [16 years, 8 months ago](https://wordpress.org/support/topic/database-errors-using-yarpp-yet-another-related-posts-plugin/)
 * 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 🙁

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

 *  Thread Starter [thephpoldbie](https://wordpress.org/support/users/thephpoldbie/)
 * (@thephpoldbie)
 * [16 years, 8 months ago](https://wordpress.org/support/topic/database-errors-using-yarpp-yet-another-related-posts-plugin/#post-1213004)
 * Never could figure this out for the life of me, so I just jumped on this [Similar Posts](http://rmarsh.com/plugins/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
 *  [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * (@mitchoyoshitaka)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/database-errors-using-yarpp-yet-another-related-posts-plugin/#post-1213059)
 * [@thephpoldbie](https://wordpress.org/support/users/thephpoldbie/) – it seems
   like you aren’t using an appropriate version of MySQL. What MySQL version is 
   that? YARPP requires at least 4.1.
 *  [dannoll](https://wordpress.org/support/users/dannoll/)
 * (@dannoll)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/database-errors-using-yarpp-yet-another-related-posts-plugin/#post-1213062)
 * 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
 *  [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * (@mitchoyoshitaka)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/database-errors-using-yarpp-yet-another-related-posts-plugin/#post-1213064)
 * 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](http://downloads.wordpress.org/plugin/yet-another-related-posts-plugin.3.1.4b4.zip)

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

The topic ‘Database Errors using YARPP / Yet Another Related Posts Plugin’ is closed
to new replies.

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)
 * [YARPP](https://wordpress.org/support/topic-tag/yarpp/)

 * 4 replies
 * 3 participants
 * Last reply from: [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * Last activity: [16 years, 3 months ago](https://wordpress.org/support/topic/database-errors-using-yarpp-yet-another-related-posts-plugin/#post-1213064)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics