YARPP doesn’t do anything on uninstall.
So you have to uninstall it then go remove the indexes manually from the DB. The index names should be prefixed with yarpp_. Very untested SQL follows:
SHOW INDEXES ON wp_posts;
DROP INDEX yarpp_title ON wp_posts;
DROP INDEX yarpp_content ON wp_posts;
Related Posts:
- What is this JavaScript “require”?
- Example of a strong and weak entity types
- WPDB Insert or if exists Update
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- MariaDB as a backend database
- WordPress database error with latest WP – “WP_termmeta doesn’t exist”
- WordPress Connection Pooling
- WordPress database error: [Query was empty] [closed]
- Login in WordPress using external database data
- Shared Members between two different wordpress installations with different databases
- What is the fastest way to generate a unique id number when registering a user
- How best to inject ads between posts in the loop?
- How to write Hebrew characters?
- Cloning and syncing a WordPress website
- Error establishing a database connection – with Debug Data
- Finding the login page from database?
- Does thumbnail regeneration edit the database?
- When and why should I use $wpdb different return types?
- Using table lock with wp_insert_post?
- Should I remove transients from the wp_options table?
- WordPress doesn’t show all posts in database
- Adding new row to wp_post table
- Extracting the post_id via the wp_insert_post action (external db query)
- How to interact with another wordpress install on same database?
- Are custom tables in the database overwritten when WordPress is updated to new versions?
- What is the proper way to validate and sanitize JSON response from REST API?
- How to migrate a website based on a custom database to wordpress?
- How do I get the posts within a certain year/date(with sql query)?
- batch UPDATE autoload value in wp_options table
- Displaying BLOB PDF File
- Saving into post_excerpt or post_content
- Maintain user profile data in a non-WordPress database
- How to fix the disappearance of the “\” character when updating a post in the database
- Data storage for JS app using WP REST API
- WP CLI Core install – blank database
- Update from 4.5 to 4.6 failing
- Setup 3 Sites To Connect To 1 Database and Share Data
- How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
- Setup private content for specific users with daily updates [closed]
- Does auto_load to ‘no’ in wp_options improve performance
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- Have working sql query… trying to adjust it to use $wpdb
- Best host for running large mem and processor intensive WordPress sites?
- Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
- In which format the data is stored in WordPress Databases?
- Is it possible to rebuild the website while not accesseing the original database?
- Error message on blog posts only on my local environment [closed]
- how to read database fields
- $wpdb->query can’t insert data
- WSOD 3.9.1 – Tried Everything so far
- Can you refresh ONLY the wordpress adminbar and not the whole page?
- After database migration, theme mods don’t show [closed]
- Sending posts from Python to WordPress
- Problem migrating to localhost
- Remote database connection and local development
- How can I detect right db type?
- Add search bar to Custom Database Table in WordPress Dashboard
- Design problems when exporting remote database for local development
- How do you render posts from outside wordpress?
- Website displays old version of page
- A change in URL slug in database returns 404, how can I do auto-redirect?
- Second ezSQL initialization for MSSQL
- How to restore an option_value with serialized data from backup data
- Replacing javascript link in WordPress database without getting mysql syntax errors
- How can i restore a WordPress site with the DB and WordPress Files
- User input to database
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- how to access 2nd Mysqli Database from different server for wordpress
- Change user_nickname for author page link
- What is recommended data type and encryption type for password in a database
- Error establishing a database connection with XAMPP
- How to map data on CSV to web pages?
- Search and replace http:// to https:// 10x my database size
- Database size for news publishers?
- WordPress URL error for links
- Search and Replace in Windows XAMPP site
- Db connection problem on Azure Since database moved on CLEARDB
- How to get specific table by current user login
- After Migration From dev, Only my Links to the Homepage Still Redirect to dev
- do I need to change the default database prefix?
- WordPress Database Posts Table query
- How to use separate database on differrent server with different username and password in wordpress for users data
- Generating an HTML table from an array based on dynamic key values
- Split posts between databases
- How to write to wp-users table
- Theme options not being sent to Database
- What’s wrong with my $wpdb query?
- What is good W3 total database caching option? [closed]
- Why are my WordPress post queries so slow?
- Moving database from WP 2.6 to 3.5 problem
- How do I find posts?
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- Multi database link and mix and match email alert
- Homepage redirects to other site of mine? [closed]
- Recover Same WordPress Admin Password
- How to STOP wordpress trying to update database?
- WordPress, Error when trying to insert data >> Notice: wpdb::prepare was called incorrectly
- Uploaded images not displaying full size preview or inserting into posts
- Display custom data based on URL slug
- How to protect my credentials on my clients website