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

[Sportsoutlaw]

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.

 

[Paul B]

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]

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;

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

 

[Paul B]

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.

 

[Sportsoutlaw]

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.

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

 

[NetDoc]

Good job @Brogan!!!