Hi there. Sometimes when a user should be deleted (and is in fact gone from the WP User Page and wp_users table), the account hangs around somehow, and the credentials still work. And the old user’s email address can’t be used to create a new account.<\/p>\n
I’ve dumped the database to text files and searched for the username\/email and found references in a few tables: wp_comments, wp_usermeta, and wp_cleanup_optimizer_login_log.<\/p>\n
I’m not worried about comments, and deleting the wp_usermeta record makes no difference. Which narrows it down to wp_cleanup_optimizer_login_log. On a side note, it has almost 800 thousand rows, which seems excessive (but I guess I don’t really care).<\/p>\n
So wp_cleanup_optimizer_login_log has an obvious connection to logging in, which is where the problem is (old [deleted] users can still log in — new accounts w\/ same credentials are prevented).<\/p>\n
I’d like to know whether I can safely delete pretty much everything in this table without breaking something, or alternatively, whether I should be looking for something more specific. And also please let me know if I’m way off track (but what else could it be at this point?).<\/p>\n
Thanks for your help. Talk soon.<\/p>\n","protected":false},"template":"","class_list":["post-11410569","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11410569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11410569\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=11410569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}