משתמשים "ממתינים" לאחר ייבוא פורום vbulletin

סיכום מבוסס בינה מלאכותית

In a support thread titled “Pending Users after importing a vbulletin forum,” AndyBr reports thousands of users stuck in “Pending” status after importing and deleting zero-post users, noting there’s no visible “Approve” checkbox. JimPas suggests checking the setting Staff must approve all new user accounts under /admin/site_settings/category/login and unchecking it if approval isn’t needed. AndyBr clarifies they intentionally enabled approval but still can’t find the approval interface or understand the “Reviewable Scoring” data shown. codinghorror recommends re-running the import to fix corrupted data. AndyBr asks for a Rails console command to fix it, and neounix suggests diagnosing via queries like User.where(active: false).count and ReviewableUser.count to correlate pending users with review queue entries. They advise testing fixes on one user first, backing up the DB, and using a staging environment to avoid production risks. GitHub code review is also suggested for deeper investigation.

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…

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

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
image

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

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?

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

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

What happened to cause this?

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

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.