WordPress.org

Forums

External Database Authentication Reloaded
[resolved] Unknown column 'active' in 'where clause' (8 posts)

  1. weblance_com
    Member
    Posted 2 years ago #

    error: Unknown column 'active' in 'where clause'

    Is the plugin looking for a status to be active? Not sure why this is popping up..?

    http://wordpress.org/extend/plugins/external-db-auth-reloaded/

  2. weblance_com
    Member
    Posted 2 years ago #

    now I am getting a Table 'admin_db1.user' doesn't exist

  3. weblance_com
    Member
    Posted 2 years ago #

    resolved

  4. karlgoddard
    Member
    Posted 2 years ago #

    what was the resolution to this problem?

  5. bruno.carvalho
    Member
    Posted 2 years ago #

    I get same error. Where is the author?

    Please, help us!

  6. nxnla
    Member
    Posted 1 year ago #

    I'm getting this error as well:

    Unknown column 'active' in 'where clause'

    Can weblance_com please post what his solution was? It may help me and others.

    I've tried different settings and this is the furthest I've been able to go in a positive direction until that error popped up.

    Please enlighten the rest of us! :)

  7. cehwitham
    Member
    Posted 1 year ago #

    I'm getting the same error. Would really appreciate people sharing their solutions.

  8. cehwitham
    Member
    Posted 1 year ago #

    Adding a column titled active to your external table of users with a 1 against users you want to allow to login gets around this issue.

    If you're authenticating against another WP site, create a VIEW in your database to pull the relevant information together and set an active column to 1.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • External Database Authentication Reloaded
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.