Support » Plugin: Yet Another Related Posts Plugin (YARPP) » Manually Remove YARPP

  • Resolved RalphMRivera

    (@ralphmrivera)


    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/

Viewing 4 replies - 1 through 4 (of 4 total)
  • I would also like to know, yarpp_related_cache table still exists for me.

    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!

    swolfram you sure ?

    Plugin Author jeffparker

    (@jeffparker)

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Manually Remove YARPP’ is closed to new replies.