Error "table does not exist"

  • Resolved gogreener

    (@gogreener)


    11 years, 10 months 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?

    https://www.ads-software.com/extend/plugins/external-db-auth-reloaded/

Viewing 15 replies - 1 through 15 (of 16 total)
  • Plugin Author Joshua Parker

    (@parkerj)

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

    Thread Starter gogreener

    (@gogreener)

    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

    (@parkerj)

    Can you posts screenshots of your settings page without passwords?

    Thread Starter gogreener

    (@gogreener)

    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!

    Plugin Author Joshua Parker

    (@parkerj)

    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

    (@gogreener)

    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

    (@parkerj)

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

    Thread Starter gogreener

    (@gogreener)

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

    Plugin Author Joshua Parker

    (@parkerj)

    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

    (@gogreener)

    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

    (@parkerj)

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

    Thread Starter gogreener

    (@gogreener)

    Thanks, will send you details there.

    what was the resolution to this problem?

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

    Thread Starter gogreener

    (@gogreener)

    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!

    gogreener can you post the fix?

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘Error "table does not exist"’ is closed to new replies.