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

Fixed Sending emails: MySQL server has gone away in

Discussion in 'Resolved Bug Reports' started by tenants, Jul 2, 2013.

  1. tenants

    tenants Well-Known Member

    An exception occurred: Mysqli prepare error: MySQL server has gone away in library/Zend/Db/Statement/Mysqli.php on line 77

    This is the seconds time I've sent an email to more than 10000 accounts, and it's the second time I have seen this error (after sending the email to 500 - 1000 accounts)

    I know this is a server issue, but there is no way to continue sending the emails once the exception has occurred.. I don't even know which user id we have gotten to.

    Can we have some sort of mechanism to carry on sending out emails after a MySQL error occurs (catch the exception, pause the emailing.. ask to push button to carry on)
    Last edited: Jul 2, 2013
    Hornstar and Alfa1 like this.
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Are you on 1.2 or 1.1? 1.2 has a queue'd system which should take care of this.
    tenants likes this.
  3. tenants

    tenants Well-Known Member

    oh... well that's good then :)

    It's 1.1, so I'll hold my breath for a bit longer
  4. Mike

    Mike XenForo Developer Staff Member

    I'm assuming this is via the admin CP? The queue system isn't used for that so it won't be different in 1.2. We likely just need to ensure the DB is "pinged" to maintain the connection.
    Jeremy likes this.
  5. tenants

    tenants Well-Known Member

    For now, my work around it to send to no more than a few hundred users at a time
    (by making sure they are in a certain group and match the email @a and then @b... @z)

    of course, that was a bad idea, I should have used a@ b@ z@
    @gmail @hotmail... urgh!

    It seems to die at about 1000 users (at least for me)
    Last edited: Jul 2, 2013
  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    I stand corrected, thanks for the information. (y)
  7. tenants

    tenants Well-Known Member

    Yes, this is via the ACP
  8. robdog

    robdog Well-Known Member

    Is the cron email send only for transactional type emails and not email lists?
  9. Mike

    Mike XenForo Developer Staff Member

    This should be fixed for the next beta.

    tenants and MattW like this.

Share This Page