1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Need help deleting a member in moderation that doesn't seem to exist

Discussion in 'XenForo Questions and Support' started by Sportsoutlaw, Jul 24, 2016.

  1. Sportsoutlaw

    Sportsoutlaw Member

    We have one member in moderation, I assume the spam system caught it.

    Unable to approve or reject the member because the do not exist.

    Tried clicking on the username to delete from the edit area, and it takes us directly to "create user". Even tried creating the user, but can't because the user already exists.

    This thing is simply stuck in moderation, and I cannot figure out how to get rid of it. There is a userid associated with it.

    Appreciate any help here, because I am lost.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    When we've seen this before, it is due to inconsistent data in the database, possibly due to manual manipulation or a rogue add-on.

    Try running these queries:
    INSERT IGNORE INTO xf_user_option (user_id) SELECT user_id FROM xf_user;
    INSERT IGNORE INTO xf_user_privacy (user_id) SELECT user_id FROM xf_user;
    INSERT IGNORE INTO xf_user_profile (user_id) SELECT user_id FROM xf_user;
    INSERT IGNORE INTO xf_user_authenticate (user_id) SELECT user_id FROM xf_user;
    Sportsoutlaw likes this.
  3. Sportsoutlaw

    Sportsoutlaw Member

    Put the user ID where the parenthesis are, or run each one exactly as is?
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Just run the queries exactly as posted.

    Any records in the xf_user table which do not have corresponding records in the other tables, will be created automatically.
  5. Sportsoutlaw

    Sportsoutlaw Member

    Thank you. Not really familiar with things like this and want to make sure I do it correctly. This took care of the issue...
  6. NetDoc

    NetDoc Member

Share This Page