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

Awaiting Feedback Time out on opening moderated users

Discussion in 'Resolved Bug Reports' started by Alfa1, May 11, 2014.

  1. Alfa1

    Alfa1 Well-Known Member

    Loading /admin.php?users/moderated when there are thousands of members to moderate leads to a time out for some of my staff.
    This page really needs a rewrite/tweak in terms of loading, display and functionality. its not suited for big boards.
  2. Chris D

    Chris D XenForo Developer Staff Member

    Why do you have so many members in the queue? Has this built up over time? Or are all new registrations moderated?

    I've seen the mod queue at one of the big boards and it usually has 3-4 people in the queue at a time.

    Is the system being used correctly if it contains that many people?
  3. Alfa1

    Alfa1 Well-Known Member

    All registrations are moderated. We have several moderators moderating the registration queue. At times when they are unavailable the queue tends to build up to significant numbers. Sometimes in the thousands.
  4. Martok

    Martok Well-Known Member

    How long does it take to build up to thousands? A day? A week? Longer?
  5. Chris D

    Chris D XenForo Developer Staff Member

    This is obviously unrelated to the bug now. It possibly could do with being paginated for sure.

    But what is the driving force that dictates a big board to decide they are going to impose such a time expensive process? Is it for anti spam? Some other reason? Isn't there anything you can do to automate it, impose automatic restrictions on new users and then subsequently automatically promote after certain criteria?
  6. Alfa1

    Alfa1 Well-Known Member

    We get about 1250 registrations a week. In general we process registrations very quickly. When staff is unavailable it can build up to a substantial amount.

    After trying out various approaches in the last 11 years we have found it better to stop problematic registrations right at the door and deny low quality registrations. Yes, its a little time consuming, but in the end it proves to be much less effort than cleaning up the problematic content that low quality users create. An important factor is that we review the content of custom profile fields and the website profile field to establish the validity of the registration.
    We do indeed apply other restrictions to new members and have a lot of anti-spam and anti-abuse measures in place. Reviewing new accounts is an important part of our protocol. In general my site is free from spam and abuse and members generally post rich content.
    In surveys our members state that one of the main reasons for registering on my site is that they did not find any other website free of spam and abuse.

    I do plan on having a number of addons created which automatically approve/block/defer registrations if certain conditions are met.

    On vbulletin we process a simple list of moderated accounts, with 1 account per row. 40 rows per pagefold on my screen. Its a matter of one click per account, and then hitting the 'continue' button. On xenforo this page is endless, because it doesn't have 1 row per registration, but one pagefold per 3 registration. 1000 accounts therefore is over 300 pages long. This makes it tedious.

    It would be very useful to have 1 row per registration and pagination added. This would prevent the page from timing out and improve usability.
  7. @Alfa1 try email validation to bring your amount of registration process down.
  8. Brent W

    Brent W Well-Known Member

    What part of this thread gave you the impression that this wasn't being done? :confused:
    Alfa1 likes this.
  9. The bit where @Alfa1 told us that they were getting 1250 registrations proves that it's not being done.
    I have both options on mine. I manually approve registrations but the ones that don't have valid emails don't get through.
    I also don't allow people to use free email addresses such as gmail.com due to the spambots using them.
  10. Brent W

    Brent W Well-Known Member

    I have owned sites and work with sites that get more than that in a week with email validation turned on. I don't know his site but I imagine it is a leader in his niche so it isn't far fetched that he is seeing that volume with valid emails.
    carntheroos4eva and Alfa1 like this.
  11. Alfa1

    Alfa1 Well-Known Member

    I cant imagine running a big board without email validation. We also block disposable email domains, multiple accounts, apply SFS, projecthoneypot and quite a few measures that limit low quality registrations.

    The issue is not that we get too many registrations. We try to increase that number constantly.
    carntheroos4eva likes this.
  12. Upgrade one of your moderators to super mod and give them the powers to approve and disapprove accounts to help you out.
  13. Same here.
    In fact i have got multiple question/answer capcha which makes it harder for spammers to jump on board
  14. Mike

    Mike XenForo Developer Staff Member

    This page is already limited -- it only shows 100 at a time, though even that is probably unnecessarily high.

    But really, the question here is what element specifically is slowing it down. This could be related to the reverse IP look ups, which is a tricky issue as it's likely fast in 99% of cases but the last set could potentially cause timeouts.

    I would need ACP and FTP (or similar) access to debug this. If that can be provided, please submit a ticket with those details and reference this bug.
  15. lukeh23

    lukeh23 Member

    I have this same issue. A sudden on set of spammers signed up and now I can't get into the Users Awaiting Moderation page. It times out every time.

    Is there a SQL statement I can use to truncate the table / delete the entries? I don't know the schema to well, so could use some advice.
  16. Brogan

    Brogan XenForo Moderator Staff Member

    If you require support, associate your forum user name with your license and post in the correct forum.
    Amaury likes this.
  17. Jim Boy

    Jim Boy Well-Known Member

    Have worked out what I think the issue is. Line 760 of XenForo_ControllerAdmin_User does a hostname lookup. If for some reason your server has trouble with DNS lookups, then you will come a cropper. I edited my instance to simply return false to $user['ipHost'], and hey presto, a speedy XenForo.
    Alfa1 likes this.
  18. Alfa1

    Alfa1 Well-Known Member

    Thank you! This is the culprit.
  19. Chris D

    Chris D XenForo Developer Staff Member

    Just a suggestion.

    Presumably in most cases the host lookup would be required, but if the page was paginated with a customer per page setting and settings to quickly select Reject / Approve / Do nothing to all that would alleviate the timeout and usability issues.
    Alfa1 likes this.

Share This Page