Database metakey: wp_rp_related_posts_query_result_cache_6, is this normal?

  • Resolved parade

    (@parade)


    10 years, 7 months ago

    I was checking my wordpress database and I noticed the table: wp_postmeta has meta key _wp_rp_related_posts_query_result_cache_6 and _wp_rp_related_posts_query_result_cache_expiration generated whenever I update a post.

    I thought it was due to quickcache plugin so I un-installed and remove it but it’s still generating this meta key whenever I update a post. Is this normal for all wordpress installation? If not, what causes it and how should I stop it?

    Regards

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator keesiemeijer

    (@keesiemeijer)

    I’m guessing you’re using a related posts plugin (now or in the past) or your theme comes with this functionality

    It’s up to a plugin if it cleans up it’s data in the database after deactivation. If you’ve used a related posts plugin in the past the data can still be in the database and will not be removed when updating a post.

    Does the problem still exist if you de-activate all plugins and update a newly created post?

    Thread Starter parade

    (@parade)

    Yes, I know it’s up to a plugin if it cleans up the database after deactivation. I tried it with quickcache disabled. The problem still exist after deactivating the only caching plugin I have installed, quickcache. I have some others plugin enabled but would like to solve this issue without disabling all of them. Any idea how the meta key: _wp_rp_related_posts_query_result_cache_6 is generated?

    Moderator keesiemeijer

    (@keesiemeijer)

    Any idea how the meta key: _wp_rp_related_posts_query_result_cache_6 is generated?

    What plugins are you using?

    As “rp_related_posts” is in the key it’s probably a related post plugin and not the quickcache plugin.

    Thread Starter parade

    (@parade)

    Hello,

    I have the following active plugins: *snipped*

    Moderator keesiemeijer

    (@keesiemeijer)

    It’s this plugin: WordPress Related Posts.
    It’s normal for plugins to store data as custom fields.

    Thread Starter parade

    (@parade)

    It’s indeed that plugin. Thank You! ??

    Moderator keesiemeijer

    (@keesiemeijer)

    You’re welcome ??

    Thread Starter parade

    (@parade)

    By the way, just wondering why the postmeta table does not increase incrementally but skipped a few metaid here and there, for example 1001, 1002, 1023,1024.

    Is there a way to arrange them incrementally?

    Moderator keesiemeijer

    (@keesiemeijer)

    By the way, just wondering why the postmeta table does not increase incrementally but skipped a few metaid here and there, for example 1001, 1002, 1023,1024.

    When custom fields get deleted the meta_ids are not reorganized to be incremental.

    Is there a way to arrange them incrementally?

    No. The database doesn’t care if keys are not incremental and you would not get any gains if they were.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database metakey: wp_rp_related_posts_query_result_cache_6, is this normal?’ is closed to new replies.