‘username_exists’ still returns an ID even after deleting record from the database?

By default, WordPress uses $wp_object_cache which is an instance of WP_Object_Cache to save on trips to the database.

Trace back username_exists() function, you will notice that get_user_by() uses WP_User::get_data_by() which return user data from $wp_object_cache immediately without checking if that user exists in database. Note that $wp_object_cache is stored in memory.

It means that if you deleted an user record directly in your database without cleaning up user cache, user data is still available. That’s the problem.

So what you’re missing?

  1. Missing to delete user the right way.

  2. Missing to clean user cache.

Related Posts:

  1. Automatically delete inactive users after 2 months
  2. Delete all subscribers from wp_users and wp_usermeta a few thousand at a time
  3. How can I add a user through SQL?
  4. importing users where password is provided as md5 + much metadata
  5. Search multiple meta keys at once
  6. Return ID of authors who have at least one post
  7. wp_insert_user is not working for me?
  8. Add user data to table when user is created?
  9. Bulk create clean user_nicename from user_email with SQL function
  10. C# user_nicename and Display name blank
  11. How do I transfer user passwords from one WordPress site to another?
  12. I am getting mysql_real_escape_string() function error while adding user?
  13. MySQL query to mass change role of users
  14. WordPress SQL Issue not returning correct reselts
  15. create new users in db starting at what ID?
  16. Delete Users without a First and Last Name
  17. Delete all users with Editor role and their content mysql
  18. How do I change the user via SQL?
  19. is_user_logged_in() not working after domain change
  20. MySQL query to list users who never signed in
  21. How to allow an user role to create a new user under a role which lower than his level only?
  22. How to get userid at wp_logout action hook?
  23. What’s the difference between the capability remove_users and delete_users?
  24. How to change user_login with wp-cli?
  25. How to hide media uploads by other users in the Media menu?
  26. Get users with atleast one post
  27. edit profile validation refreshes all field if missing wordpress
  28. Track logged in users’ visits
  29. order users with drag’n’drop?
  30. include user profiles in search results?
  31. Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that
  32. How to delete users with no order history through phpmyadmin sql?
  33. User profile custom field
  34. Authors Page : A page of authors
  35. Limit content by user registration date
  36. What is the best way to avoid spammers registering to my blog?
  37. Completely hide user info
  38. Gravity Forms Submit form as another user
  39. Redirect User to Homepage if no other redirect is specified
  40. Set default page for user account in admin
  41. Searchable meta value in user.php
  42. Find out who created a certain user?
  43. Locate authors on Google map version 3
  44. Add email addresses to already registered users
  45. show text If special user is logged
  46. Multiple Backend Users as single Frontend User
  47. Forcing WordPress to work differently
  48. Does WordPress Importer notify imported Users?
  49. Remove user profile field [duplicate]
  50. Can user login details be used for other applications?
  51. How can I attach a user to another user with user meta
  52. How do I protect user_activation_key?
  53. WP not logging in at first time
  54. Log out users from every where
  55. Separate Out Real Users
  56. No user found when using REST API
  57. is_user_logged_in() throwing undefined function error
  58. How to prevent a specific users’s profile photo (gravatar) from showing on the frontend to other users?
  59. WordPress REST Api: update user
  60. Hackers tried user name with wrong case [closed]
  61. SQL Bulk update all WordPress user’s nicknames to firstname + lastname format
  62. Redirect logged on user to a specific page based on wp user role, page id
  63. Show WordPress users in grid with image and name
  64. Automatic Website user password generation
  65. Redirect users after login
  66. How to hide some users to unlogged users [closed]
  67. List all users and current week entries
  68. Need to manually add multiple WP users with same e-mail address (with good reason)
  69. How to get current user on a multi site that is using domain mapping?
  70. WordPress Redirect Specific User. Tired of Peter’s redirect Plugin its not working
  71. Can I edit the database to change a login?
  72. User Meta stuff
  73. User can’t search himself on rest api
  74. How do I update user email from frontend input field?
  75. How to allow access based on the user meta flag
  76. Authentication between two different sites using the WordPress login cookie
  77. Cannot update newly added User field using wp_update_user
  78. Block editor completely gone for second of two super user
  79. How can I display Only the first Array/Object?
  80. How to create page for user?
  81. How to prevent multiple user accounts with the same meta field?
  82. How do I set a maximum upload size for a specific user role (Editor)
  83. Return all users that have one or more published blog posts
  84. members only products
  85. Modify the user data stdObject and add extra items to it?
  86. Create relationships between users or user roles
  87. User Permissions on custom post type
  88. update custom field user profile from front end form
  89. Change “logged in as a ” link in comments form
  90. Specific Content on pages based on user
  91. Custom user query – orderby meta_key (that may not exist)
  92. I try to add informations to User profile
  93. force registered user as seller
  94. Not able to call value in the core files
  95. Privacy in WordPress
  96. Create a wordpress admin user and only let them edit and post blog posts?
  97. How to display Most Recently Read 10 Posts by a logged in user in wordpress
  98. Email Subscribe for Downloads in WordPress
  99. Cant edit profile from frontend
  100. application password is missing

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)