Changed meta_key value in structures, now dashboard shows zero users

You have destroyed a significant section of your database. Unless you have a backup you cannot get it back.

What happened when you changed the varchar to an int was that every entry not recognized as an integer was converted to 0. You can see that in your screenshot. That is not reversible. Data was lost.

In the future:

  1. Make a backup
  2. Don’t mess with things you don’t understand. Take the time to
    understand     first then mess with things.

Related Posts:

  1. Set Display Name to first and last name (phpmyadmin SQL Query)
  2. Can’t log into wordpress site – I have made a new user and still cant access
  3. Multiple developers / editors working on a site in progress
  4. How many users can WordPress handle?
  5. How to track user progress?
  6. Performance tips for a large user base [closed]
  7. Efficiency on displaying random authors based on large database
  8. Delete all post meta except featured image
  9. Extend the wp_users table
  10. How to use user table of a different database for WordPress users?
  11. Subscribers to posts
  12. Emojis getting converted to “?”
  13. How to replace values in WordPress DB using phpMyAdmin
  14. Select Multiple meta_value from WP DB; Single Query
  15. Getting all the users who have author privilege
  16. Delete all post meta except featured image Using SQL
  17. Accidentally deleted active_plugins portion of the wp_options DB table
  18. Does WordPress always create unique passwords?
  19. In what part of the WordPress core does the users table and usermeta table get joined?
  20. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  21. Modify Database in Multi-Site wp_usermeta table
  22. Users table association with users_metadata table appears broken
  23. Change WordPress prefix for only one table?
  24. WordPress database import: Row size too large
  25. wp_get_current_user always returns 0 continued
  26. Is there a smart way to obtain a list of only some selected user meta data?
  27. How can i customize the export personal data file?
  28. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  29. WordPress Database Huge wp_usermeta Table
  30. Import users from old WP site to new one
  31. How to Access wp_usermeta Data Immediately After a New User is Created
  32. Logins from WP users table use on another page
  33. MS Access to manage WordPress Database
  34. 2 WordPress sites with 2 databases but sharing the same users
  35. Connection refused on locahost after importing database?
  36. Convert user passwords to MD5?
  37. Changing root password in PHPMyAdmin for WordPress Database when going live
  38. Can’t update WordFence Options, clear data manually
  39. Does WordPress store the username as a primary key in the database?
  40. Is there a way to execute a php script outside WordPress?
  41. multiple wordpress installation with shared usertable on an different database
  42. Post Views / Hit Counter Problem?
  43. How to migrate a database from a server to another
  44. Best practice to import user base (subscribers) from one website to another?
  45. Share users across multiple sites on same database, but with different domains
  46. Users table missing from Database [closed]
  47. Some weird users in database
  48. How to delete a particular row in a database table
  49. Add search bar to Custom Database Table in WordPress Dashboard
  50. Recovering the table wp_usermeta from users
  51. How to direct my site to the proper URL without Dashboard
  52. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  53. Regenerate user_nicename column
  54. Files on Localhost, Database on Server
  55. Backing up WordPress database and files
  56. Storing user submitted forms [closed]
  57. WordPress where clauses in db select
  58. wp_option table error while importing
  59. wp_insert_user not creating account correctly when ID is manually set
  60. Installing local to live WP into subdirectory
  61. Select From wpdb – Author/User Directory page
  62. Delete user with only subscriber role
  63. Need help with creating a searchable user data by name or specific number like ID
  64. Is there any way to monitor a MySQL db and check what has changed?
  65. DB prefix not updating
  66. Migrate Users From laravel to wordpress
  67. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  68. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  69. Display user data in numbered list
  70. User input to database
  71. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  72. how add more field to wp user and save it to database
  73. Move Non-WordPress users table to WordPress database
  74. Is there any defects for using same database prefix in WordPress for multiple sites?
  75. Migrating meta_key and meta_value from old theme to new one
  76. Change user_nickname for author page link
  77. What is recommended data type and encryption type for password in a database
  78. How to force set same page as homepage and blogpage in static page settings
  79. syntax error for changing user role from database
  80. how restrict user to give star ratings once for a post?
  81. Duplicate database to roll back theme & content changes
  82. WP website showing blank page after moving from subdomain to main domain
  83. create a table using user meta custom data
  84. How to get the id of recently registered user from database?
  85. How to save dropdown slection by a user in the DB
  86. How to get specific table by current user login
  87. How to retrieve user data based on role using SQL?
  88. update multiple user meta field based on another meta field
  89. WordPress character set issue
  90. Missing latest posts and options after DB migration via phpMyAdmin
  91. Hash user emails in database?
  92. Check if a database is well installed
  93. What WordPress file is saving new users to database
  94. Get id from database
  95. Options table – where does my values go?
  96. WordPress sync with phpbb
  97. import (migration) user database to wp-users
  98. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  99. Import Excel (or csv) Table with user-data as subscribers to wordpress
  100. WP Multisite Users Not Linking