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

XF 1.2 New User Registration error

Discussion in 'Troubleshooting and Problems' started by JP1021, Oct 13, 2013.

  1. JP1021

    JP1021 Member

    I just had someone bring this to my attention, tonight.

    When a user tries to sign up for a new account they get this message. I've replicated this myself.

    An unexpected database error occurred. Please try again later.
    <!-- Mysqli prepare error: MySQL server has gone away -->

    There is no server error logged.

    Forums are working just fine, but no new users are able to sign up.

    Any ideas where I might start looking first? I apologize for my lack of knowledge but I bet if I can get a starting point I might be able to tackle this.
  2. Amaury

    Amaury Well-Known Member

    Check your error logs on your server, not just in the Admin CP.
  3. whynot

    whynot Well-Known Member

    Usually that points to a server error.
    Amaury likes this.
  4. JP1021

    JP1021 Member

    It's a shared server. We only have like 50 active members and usually only 5 or 6 of them are on at a time. I've checked the server error log, but the mysql server log isn't hosted locally being a shared server. I did notice that when the last few bots were detected and rejected from registering the time on their registration was exceeding 3000 seconds.
  5. whynot

    whynot Well-Known Member

    Search engines, bots, visitors add up to the usage of the server.
  6. Mike

    Mike XenForo Developer Staff Member

    Is this consistent? Does the error happen consistently? Does it happen quickly after you submit the form?

    The error indicates that the MySQL connection is being closed. This could be a timeout -- there's a MySQL setting that can control this (wait_timeout). Normally, it's set to 86400 seconds (which is 24 hours), but if it would be taken down to a really small value (1-5 seconds say), this could get in the way. That's an unreasonably low number that your host would need to change (30 is not unreasonably low).
  7. BassMan

    BassMan Well-Known Member


    I have the same problem after upgrading to 1.2.2. No ACP server error log, but just this message when someone tries to register:

    Your registration has been rejected. You may contact the administrator if you require further information or assistance.

    After upgrading to 1.2.2 I installed only 2 add-on (one for social share buttons and one for live search - so nothing to do with registration form).

    I really need help, because really don't know what to do.
  8. BassMan

    BassMan Well-Known Member

    UPDATE: found what cause the problem. I need to disable this option in User Registrations settings:

    Check new registrations against the StopForumSpam database.

    But really don't know why...
  9. Tracy Perry

    Tracy Perry Well-Known Member

    Because something in their registration is triggering StopForumSpam (IP address, email address or username). Depending on how strict you have your settings is what it is based upon. If you have it at 1, then any 1 of the above will trigger it. 2 means 2 will and 3 --- well you get the point.
  10. BassMan

    BassMan Well-Known Member

    Thank you. But never had problems before upgrade to 1.2.2.
  11. Tracy Perry

    Tracy Perry Well-Known Member

    Maybe because some of the spam fixes that were applied in 1.2.2 made it work like it was supposed to and not like it was?
    BassMan likes this.
  12. BassMan

    BassMan Well-Known Member

    Maybe, and it's better this way. Thank you.
  13. JP1021

    JP1021 Member

    Found out that my problem was caused by the addon "anyapi" where I had spambusted enabled as a bot protection. Spambusted shut down and was causing my sql connections to time out. Disabled spambusted and I'm back up and running.
    Tracy Perry likes this.

Share This Page