WordPress.org

Ready to get started?Download WordPress

Forums

Yet Another Related Posts Plugin (YARPP)
[resolved] Manually Remove YARPP (5 posts)

  1. RalphMRivera
    Member
    Posted 9 months ago #

    Hi,

    I have deactivated and uninstalled YARPP via the WordPress admin, but I see there are still remnants that I'd like to remove.

    For context, I am using WP 3.5.2, MySQL 5.5 & PHPMyAdmin 4.0.4.

    I realized the problem because I exported my database using PHPMyAdmin and when I attempted to import the database, I received the following error:

    #1214 - The used table type doesn't support FULLTEXT indexes

    This happened because of the conflict between the InnoBD table and the FULLTEXT keys.

    CREATE TABLE IF NOT EXISTS 'wp_posts' (

    [edited]

    <strong>FULLTEXT KEY 'yarpp_title' (post_title),

    FULLTEXT KEY 'yarpp_content' (post_content),</strong>

    [edited]

    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9269 ;

    I manually deleted the lines with the FULLTEXT keys, but I want to ask about the following:

    1 --------------------------------------------------

    There are two tables that I want to confirm if I can delete:

    wp_yarpp_keyword_cache

    wp_yarpp_related_cache

    2 --------------------------------------------------

    I ran the following command on my options table:

    SELECT * FROM 'wp_options' WHERE option_name LIKE '%yarpp%'

    And it returned the following options:

    yarpp

    yarpp_version

    yarpp_version_info_timeout

    yarpp_version_info

    yarpp_optin_timeout

    Can I delete those options? Where else does YARPP place rows in the database that can be deleted?

    3 --------------------------------------------------

    In the wp_posts table there are the following index keys:

    FULLTEXT KEY 'yarpp_title' ('post_title'),

    FULLTEXT KEY 'yarpp_content' ('post_content'),

    Can I delete these without a negative impact and are there any other keys that I need to delete?

    4 --------------------------------------------------

    Presumably, I can run something like this to get rid of the keys:

    ALTER TABLE 'wp_posts' DROP INDEX 'yarpp_title'

    ALTER TABLE 'wp_posts' DROP INDEX 'yarpp_content'

    Howver, can you provide a SQL script to clean up/remove all of the YARPP related content.

    http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/

  2. MCM
    Member
    Posted 9 months ago #

    I would also like to know, yarpp_related_cache table still exists for me.

  3. swolfram
    Member
    Posted 9 months ago #

    clean uninstalls or full-removal scripts for plugins should become mandatory for wordpress. thats one of the biggest bugs since ... well since start.

    and yes: you can remove everything related to yarpp without problems!

  4. MCM
    Member
    Posted 9 months ago #

    swolfram you sure ?

  5. jeffparker
    Member
    Plugin Author

    Posted 8 months ago #

    A clean uninstall process is something I hope to include in the near future.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags