"Pending" Users after importing a vbulletin forum

What does “Pending” mean? I have 100’s (1000’s?) of these after importing a forum and then deleting all the 0-post users…

If it means “Pending Approval” there’s no checkbox to click to Approve.
Clicking on the “?” shows this box that I can’t seem to find any information about…

image

2 Likes

Have you clicked on the link "See must approve users.?

image

Depending upon what setting you used for signup and creating accounts, approving users may be mandatory. Here’s a setting you should check out.

/admin/site_settings/category/login

Uncheck Staff must approve all new user accounts before they are allowed to access the site.

5 Likes

Thank you for your reply!

I intentionally set things up to require approval for user registration, but as I said earlier:

So, again, where is the “Approve” checkbox and what is the “Reviewable Scoring” data in the box I posted mean?

1 Like

You might need to re-do the migration / import to fix the bad data first.

1 Like

Unfortunately, I really can’t. I there a rails console command I could do to fix this?

What happened to cause this?

1 Like

Anyone know the database structure well enough to advise how to clear the review count?

1 Like

You can try to check to see what is the correlation between these users and the number of users in the review pipeline and see if you can figure it out.

I would do this for you; but we don’t have the same class of users in our review queue and when we migrated we turned this off. Actually, we had it turned on (same issue as you) and then we just reran the migration with it turned off in the settings (as Jeff suggested to you earlier).

Having said that, you can try to correlate by looking at the total number of users you are seeing in the review queue against these queries:

User.where(active:false).count
ReviewableUser.count

For example, our app container name I am looking at now is named: “socket1”:

ubuntu:# docker exec -it socket1 rails c
[1] pry(main)> User.where(active:false).count
=> 11
[2] pry(main)> ReviewableUser.count
=> 29

If I were you, I would run these queries above and record the numbers and compare them against what your admin UI shows as the number of users you need to review. If you see a strong correlation, you can example those models to see what you need to change; and then you can try it out on one user (not against the entire DB table).

Then, if you can clear the “reviewable flag” in this way, successfully for one user, and all works out, you can do more.

In addition, as you know make sure you have a full working backup before making changes to the DB with a query.

Finally, you might want to consider setting up a staging / development instance, restore your current DB to that instance; and then you can try without fear of causing damage to your production system.

Hope this helps.

PS: Don’t forget you can also review the code on GitHub and search for keywords there, etc.

2 Likes