Title: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]
Last modified: April 4, 2020

---

# WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]

 *  [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/)
 * I’m getting a strange error while trying to register on my website that looks
   like this:
 *     ```
       WordPress database error: [Table 'wp_Dest.wp_users' doesn't exist]
       INSERT INTO <code>wpDusers</code> (<code>user_pass</code>, <code>user_nicename</code>, <code>user_email</code>, <code>user_url</code>, <code>user_registered</code>, <code>user_activation_key</code>, <code>display_name</code>, <code>user_login</code>) VALUES ('$P$BGyqjbeHyWXxBWUvokHoOUjaQ780hg0', 'leerling', 'leerling@xxxxxxx.nl', '', '2020-04-04 13:27:34', '', 'leerling', 'leerling')
       ```
   
 * I admit I used a really shitty plugin to change my table prefix and then had 
   to change it back because my website was showing the installation again but everything
   works except this.
 * The weird thing is that when I changed it from wpD to wp_ It gave an error that
   wpD didn’t exist, and now that I changed it back to wpD it gives the error that
   wp_users doesnt exist… what the heck is going on?
    -  This topic was modified 6 years, 1 month ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).

Viewing 12 replies - 1 through 12 (of 12 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627487)
 * Look at your database using PHPMYADMIN. Does the table exist?
 * Why did you feel the need to change your table prefix? When you look at your 
   DB with PHPMYADMIN, are the prefixes consistent and do they match the prefix 
   set in wp-config.php?
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627506)
 * Well as I mentioned I changed the prefix with a plugin from wpD to wp_, which
   returned the error that wpD doesn’t exist which was correct even though config.
   php CLEARLY had the prefix wp_ set. Then I changed it back and the error it gave
   was that wp_ didn’t exist which is also true although the config.php CLEARLY 
   had wpD as a prefix.
 * I thought it was a server caching issue so I waited a while after which I was
   able to register a user. Then I thought my problems were over but 5 minutes later
   I got this error:
 * WordPress database error: [Unknown column ‘wpdusers.ID’ in ‘field list’]
 * Now this table does exist 100%, I’m looking at it now.
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627513)
 * (I wanted to change the prefix because I’m building an application on top of 
   wordpress and I need my own tables so I wanted to clean up the messy prefix.)
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627622)
 * Make sure that the prefix is consisent across all tables and matches wp-config.
   php.
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627703)
 * Jep, checked the entire database, they all match the prefix set in config. I’m
   quite astounded by the register form wanting to send something to the wrong table
   that doesn’t exist.
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627785)
 * It may be that the table wp_users is corrupt. Use phpmyadmin to repair it.
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12627871)
 * Hmm I got this error:
 * “The storage engine for the table doesn’t support r…”
 * I don’t know if it matters but I have only 2 registered admins.
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12628118)
 * That’s fine. That’s just advisory.
 * Let’s review.
 * EVERY SINGLE TABLE in the database starts with “wp_”, as in “wp_posts”, “wp_postmeta”,
   etc.?
 * The table prefix set in wp-config.php is “wp_”.
 * Correct?
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12628560)
 * No no, every one of them right now starts with ‘wpD’, and the prefix set in config.
   php is ‘wpD’.
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12628565)
 * Wait no that’s not correct, I have a plugin called WPdatatables that makes its
   own tables without a the wpD prefix and simple uses wp.
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12628576)
 * That’s wrong. ALL tables for a given site MUST have the same prefix.
 *  Thread Starter [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * (@cityjohn)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12628618)
 * Ok, I’ve told them.
 * [https://wordpress.org/support/topic/database-prefix-missing-in-tables/#new-topic-0](https://wordpress.org/support/topic/database-prefix-missing-in-tables/#new-topic-0)

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]’ is
closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 12 replies
 * 2 participants
 * Last reply from: [cityjohn](https://wordpress.org/support/users/cityjohn/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_dest-wp_users-doesnt-exist/#post-12628618)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics