Hello @techspecx,
Thank you for contacting the support.
Uninstalling or disabling a plugin doesn’t remove its data from the database unless you have used a filter or option in the plugin settings to do that. The data is saved to make sure that if you ever decide to use the plugin again, the settings you have made before are not lost.
And if you don’t want to use the filter to remove our plugin’s data completely, all the tables created by our plugin have rank_math in the table’s name. Same for the meta keys, all the meta keys will also have rank_math prefix.
Hope that helps.
Hello,
Thank you for your reply.
I found:
24 matches in wp_options
12 matches in wp_postmeta
4 matches in wp_usermeta
For a total of 40 matches.
rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_internal_links_processed rank_math_known_post_types a:4:{s:4:”post”;s:4:”post”;s:4:”page”;s:4:”page”;s… rank_math_modules a:11:{i:0;s:12:”link-counter”;i:1;s:9:”analytics”;… rank-math-options-general a:38:{s:19:”strip_category_base”;s:3:”off”;s:24:”a… rank-math-options-titles a:120:{s:24:”noindex_empty_taxonomies”;s:2:”on”;s:… rank-math-options-sitemap a:14:{s:14:”items_per_page”;i:200;s:14:”include_im… rank_math_version 1.0.107.3 rank_math_db_version 1 rank_math_install_date 1612529286 rank_math_registration_skip 1 rank_math_review_posts_converted 1 rank_math_wizard_completed 1 rank_math_is_configured 1 rank-math-options-instant-indexing a:1:{s:15:”bing_post_types”;a:2:{i:0;s:4:”post”;i:… rank_math_pro_notice_date 1676549178 _transient_rank_math_first_submenu_id rank-math rank_math_notifications a:1:{i:0;a:2:{s:7:”message”;s:421:”Rank Math has d… rank_math_viewed_seo_analyer 1 rank_math_review_notice_delayed 1 rank_math_review_notice_date 1676808393 rank_math_already_reviewed 1675598793 _transient__rank_math_site_type webshop rank_math_sitemap_cache_files a:0:{} rank_math_viewed_index_status 1 manageedit-pagecolumnshidden a:3:{i:0;s:0:””;i:1;s:15:”rank_math_title”;i:2;s:2… manageedit-oceanwp_librarycolumnshidden a:3:{i:0;s:0:””;i:1;s:15:”rank_math_title”;i:2;s:2… manageedit-e-landing-pagecolumnshidden a:3:{i:0;s:0:””;i:1;s:15:”rank_math_title”;i:2;s:2… manageedit-blogcolumnshidden a:3:{i:0;s:0:””;i:1;s:15:”rank_math_title”;i:2;s:2…
So it is safe to remove all these leftovers?
Regards,
techspecX
Hello @techspecx,
Since you are no longer using our plugin, you can remove those entries without any worries. However, it is always good to take a backup of the database before performing such actions so you can revert the changes if something breaks.
Hope that helps and If you ever decide to switch back to Rank Math and need any assistance, let us know. We are here to assist.
Hello,
Thank you again for your time and reply but when I removed them I lost my admin privileges and access to the back end to my site and I had no ability to get to the back end of WordPress, I was only able to work at the front end of WordPress.
I ran a SQL to find all rank math entries and when deleted that was when II lost access. So tell me where in your code you have the ability to have this happen when removing entries related to your plugin.
So it is not safe to remove these entries.
Any suggestions since this is not a good thing.
Regards,
techspecX
-
This reply was modified 3 years, 3 months ago by
techspecx.
Hello @techspecx,
Can you please share the SQL query you have executed to remove all remnants of Rank Math in the database? For now, you can restore your backup database to regain access to your WordPress site.
Also, please share your website’s recent error logs so we can determine what’s causing the issue.
You can follow this guide to enable debugging in WordPress
https://ww.wp.xz.cn/support/article/debugging-in-wordpress/ or you can get in touch with your web host, they will help you locate the log file.
Looking forward to helping you with this one.
Hello,
Thank you for replying back to me and your great support!
This is the SQL I ran, I replaced my DB name with MYDB for security purposes:
SELECT*FROMMYDB.wp_optionsWHERE(CONVERT(option_idUSING utf8)LIKE'%rank_math%'ORCONVERT(option_nameUSING utf8)LIKE'%rank_math%'ORCONVERT(option_valueUSING utf8)LIKE'%rank_math%'ORCONVERT(autoloadUSING utf8)LIKE'%rank_math%')
And it showed 2 matches in wp_options table under the option name of wp_user_roles and all my admin privileges are in that table also. So when you said it was okay I deleted that table. I had a DB backup but how do I remove the entries in the wp_options table?
This is what it looks like below:
b:1;s:23:”rank_math_edit_htaccess”;b:1;s:12:
It has numbers before it and after it and I am not certain what should be removed since there are other entries in there for other plugins.
There is also an entry under the option name called recently activated:
s:30:”seo-by-rank-math/rank-math.php”;
So I don’t know what to remove since there are other entries in there and I do not want to mess that up.
Could you help?
Regards,
techspecX
Moderator
Jan Dembowski
(@jdembowski)
Forum Moderator and Brute Squad
@techspecx Can you share that paste on something like https://pastebin.com/ and share the link to that paste?
The forums here will never work here with that paste and important details may be lost to the developer.
Hi Jan,
How do I edit the message so I can include the pastebin link?
Moderator
Jan Dembowski
(@jdembowski)
Forum Moderator and Brute Squad
You can’t but you can reply with the link.
Thanks Jan.
Rank Math Devs here is the pastebin:
https://pastebin.com/fnYfiYmN
-
This reply was modified 3 years, 3 months ago by techspecx.
Hello @techspecx,
To completely remove the data from the plugin the recommended method is illustrated in this article: https://rankmath.com/kb/uninstall/
You would need to install the plugin once again after adding the filter just to trigger it upon uninstalling it.
Don’t hesitate to get in touch if you have any other questions.
Hello,
I added code to your theme’s functions.php and followed your instructions and deactivated and deleted the plugin but it still left residual code from your plugin in my DB.
How am I am suppose to remove that – that was my last question. It still leaves code in the wp_options table.
And what happened to this post – where are my replies?
Hello @techspecx,
All the data from our plugin is prefixed by rank_math so if you find any options with that prefix in the options table you can delete them if you are not using the plugin.
Don’t delete any other data from the database.
Hope this helps solve your issues.
Don’t hesitate to get in touch if you have any other questions.
