WordPress.org

Ready to get started?Download WordPress

Forums

Contextual Related Posts
[resolved] Manual uninstall of CRP (8 posts)

  1. RalphMRivera
    Member
    Posted 9 months ago #

    Hi,

    I deactivated and uninstalled this plugin, but noticed that there are keys remaining in the wp_posts table.

    Can you provide a SQL script or instructions for removing any traces of CRP from my database?

    http://wordpress.org/extend/plugins/contextual-related-posts/

  2. Ajay
    Member
    Plugin Author

    Posted 9 months ago #

    The plugin uses the following code to delete the cache:

    DELETE FROM <code>wp_postmeta</code> WHERE meta_key='crp_related_posts';

    Please backup your DB before running anything

  3. RalphMRivera
    Member
    Posted 9 months ago #

    I also see some keys in wp_posts can you provide a SQL script to remove those?

    Thanks.

  4. Ajay
    Member
    Plugin Author

    Posted 9 months ago #

    Can you give me some examples of this

  5. RalphMRivera
    Member
    Posted 9 months ago #

    The following indexes exist in wp_posts:

    crp_related
    crp_related_content
    crp_related_title

  6. Ajay
    Member
    Plugin Author

    Posted 9 months ago #

    Did you delete the plugin via the WordPress interface? The uninstall script is automatically run when you delete the plugin from WordPress Admin.

    ALTER TABLE wp_posts DROP INDEX crp_related
    ALTER TABLE wp_posts DROP INDEX  crp_related_content
    ALTER TABLE wp_posts DROP INDEX crp_related_title
  7. RalphMRivera
    Member
    Posted 9 months ago #

    Yes, I did. I even re-installed it and uninstalled it again, but the keys were not removed.

    OK, so if I understand you correctly, if I run the following, the CRP stuff will be gone?

    DELETE FROM wp_postmeta WHERE meta_key='crp_related_posts';

    ALTER TABLE wp_posts DROP INDEX crp_related

    ALTER TABLE wp_posts DROP INDEX crp_related_content

    ALTER TABLE wp_posts DROP INDEX crp_related_title

  8. Ajay
    Member
    Plugin Author

    Posted 9 months ago #

    Yes. Please backup your DB before you do this.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.