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' (
<strong>FULLTEXT KEY 'yarpp_title' (post_title
FULLTEXT KEY 'yarpp_content' (post_content
) 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:
There are two tables that I want to confirm if I can delete:
I ran the following command on my options table:
SELECT * FROM 'wp_options' WHERE option_name LIKE '%yarpp%'
And it returned the following options:
Can I delete those options? Where else does YARPP place rows in the database that can be deleted?
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?
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.
- The topic ‘Manually Remove YARPP’ is closed to new replies.