WordPress.org

Ready to get started?Download WordPress

Forums

External Database Authentication Reloaded
[resolved] Error "table does not exist" (17 posts)

  1. gogreener
    Member
    Posted 1 year ago #

    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/

  2. Joshua Parker
    Member
    Plugin Author

    Posted 1 year ago #

    Is your login details correct for the external database you are trying to use?

  3. gogreener
    Member
    Posted 1 year ago #

    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?

  4. Joshua Parker
    Member
    Plugin Author

    Posted 1 year ago #

    Can you posts screenshots of your settings page without passwords?

  5. gogreener
    Member
    Posted 1 year ago #

    I don't seem to be able to upload to these forums, so I've popped it here 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!

  6. Joshua Parker
    Member
    Plugin Author

    Posted 1 year ago #

    To to be sure, under Name which comes after the Port field, you've entered the name of your external database right? Also,

  7. gogreener
    Member
    Posted 1 year ago #

    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.

  8. Joshua Parker
    Member
    Plugin Author

    Posted 1 year ago #

    And all the database settings in the first section are the settings for your external database and not WordPress?

  9. gogreener
    Member
    Posted 1 year ago #

    Let me double-check... yep, all for the external db.

  10. Joshua Parker
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  11. gogreener
    Member
    Posted 1 year ago #

    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.

  12. Joshua Parker
    Member
    Plugin Author

    Posted 1 year ago #

    Yes, I should have time on Saturday. You can contact me @ http://www.joshparker.us/contact

  13. gogreener
    Member
    Posted 1 year ago #

    Thanks, will send you details there.

  14. karlgoddard
    Member
    Posted 1 year ago #

    what was the resolution to this problem?

    I'm sure other users of this plugin will appreciate the answer!

  15. gogreener
    Member
    Posted 1 year ago #

    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!

  16. stueynet
    Member
    Posted 10 months ago #

    gogreener can you post the fix?

  17. gogreener
    Member
    Posted 10 months ago #

    The plugin was updated and I applied the update - I'm not sure what the code was exactly, sorry. If you're seeing the same error I was try updating the plugin and if that doesn't work, contact the author.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic