Title: Error "table does not exist" Last modified: August 20, 2016 --- # Error "table does not exist" * Resolved [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/) * Hi there, I seem to be entering the external database settings incorrectly? After installing, settings, logging out then logging in again I get an error message saying `Table 'prefix_wp.prefix_users' doesn't exist` (obviously with my actual prefixes). It seems to be looking at the WordPress database, not my external database. * In the “External Database Settings: User table” field, I’ve tried both `prefix_usertable` as in the screenshot and `prefix_dbname.prefix_usertable`. * Is there another place where I should identify the name/location of the external db? * [http://wordpress.org/extend/plugins/external-db-auth-reloaded/](http://wordpress.org/extend/plugins/external-db-auth-reloaded/) Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/error-table-does-not-exist-1/page/2/?output_format=md) [→](https://wordpress.org/support/topic/error-table-does-not-exist-1/page/2/?output_format=md) * Plugin Author [Joshua Parker](https://wordpress.org/support/users/parkerj/) * (@parkerj) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344463) * Is your login details correct for the external database you are trying to use? * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344477) * Yep, they’re correct – I’ve got an account on the external database with the same username and password as the admin account for WordPress, have double-checked both for typos. * A quick look at external database type things for non-Wordpress connections shows that sometimes they rely on config.php in the root – could mine be a problem here? * Plugin Author [Joshua Parker](https://wordpress.org/support/users/parkerj/) * (@parkerj) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344500) * Can you posts screenshots of your settings page without passwords? * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344515) * I don’t seem to be able to upload to these forums, so I’ve popped it [here](http://tellcentre.org/test/extdbsettings.jpg) instead. * Thankfully, WP remembers almost all the settings except the hash code when I delete and reinstall the plugin after an unsuccessful attempt. * Other possible issues with my setup that might affect finding the table: – WP is installed in a subfolder – The external db belongs to a program installed in a subdomain (not my idea, but stuck with it now). * Let me know if there’s any other information I can provide for you. Thanks! * Plugin Author [Joshua Parker](https://wordpress.org/support/users/parkerj/) * (@parkerj) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344522) * To to be sure, under Name which comes after the Port field, you’ve entered the name of your external database right? Also, * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344538) * Ah, I knew there was something odd there. I’ve changed it now to the external database name (and updated my screenshot at the link above). The plugin is still looking in the WordPress database though – `prefix_wp.prefix_users doesn't exist`. * Plugin Author [Joshua Parker](https://wordpress.org/support/users/parkerj/) * (@parkerj) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344539) * And all the database settings in the first section are the settings for your external database and not WordPress? * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344541) * Let me double-check… yep, all for the external db. * Plugin Author [Joshua Parker](https://wordpress.org/support/users/parkerj/) * (@parkerj) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344542) * Hmm, I don’t know without seeing the database. Maybe the user’s data is located in two different tables? That is the only thing I think of that could cause issues. * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344543) * I’ve got username and password in that one table, is there anything else it will be looking for? I’d be happy to give you a login if you have time to look at it for me. * Plugin Author [Joshua Parker](https://wordpress.org/support/users/parkerj/) * (@parkerj) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344544) * Yes, I should have time on Saturday. You can contact me @ [http://www.joshparker.us/contact](http://www.joshparker.us/contact) * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 4 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344564) * Thanks, will send you details there. * [karlgoddard](https://wordpress.org/support/users/karlgoddard/) * (@karlgoddard) * [13 years, 2 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344601) * what was the resolution to this problem? * I’m sure other users of this plugin will appreciate the answer! * Thread Starter [gogreener](https://wordpress.org/support/users/gogreener/) * (@gogreener) * [13 years, 1 month ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344602) * Turns out it was a slight bug in the plugin, which has now been fixed. After that, I had no trouble at all with it and it’s been really useful, works perfectly for me! * [stueynet](https://wordpress.org/support/users/stueynet/) * (@stueynet) * [12 years, 12 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/#post-3344605) * gogreener can you post the fix? Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/error-table-does-not-exist-1/page/2/?output_format=md) [→](https://wordpress.org/support/topic/error-table-does-not-exist-1/page/2/?output_format=md) The topic ‘Error "table does not exist"’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/external-db-auth-reloaded.svg) * [External Database Authentication Reloaded](https://wordpress.org/plugins/external-db-auth-reloaded/) * [Frequently Asked Questions](https://wordpress.org/plugins/external-db-auth-reloaded/#faq) * [Support Threads](https://wordpress.org/support/plugin/external-db-auth-reloaded/) * [Active Topics](https://wordpress.org/support/plugin/external-db-auth-reloaded/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/external-db-auth-reloaded/unresolved/) * [Reviews](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/) ## Tags * [authentication](https://wordpress.org/support/topic-tag/authentication/) * [external database](https://wordpress.org/support/topic-tag/external-database/) * 16 replies * 4 participants * Last reply from: [gogreener](https://wordpress.org/support/users/gogreener/) * Last activity: [12 years, 12 months ago](https://wordpress.org/support/topic/error-table-does-not-exist-1/page/2/#post-3344606) * Status: resolved