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

XF 1.2 Too many email addresses

Discussion in 'Troubleshooting and Problems' started by whynot, Oct 4, 2013.

  1. whynot

    whynot Well-Known Member

    What's happened here?

    Is it the spammer who is trying all those email addresses or is it XF trying to correct the address?

    Error Info

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'email' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Monday at 10:27 PM

    Stack Trace


    #0 /home4/*******/public_html/****/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home4/*******/public_html/****/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home4/*******/public_html/****/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home4/*******/public_html/****/library/RegFormTimer/ControllerPublic/Register.php(108): Zend_Db_Adapter_Abstract->insert('xf_reg_form_tim...', Array)
    #4 /home4/*******/public_html/****/library/XenForo/FrontController.php(337): RegFormTimer_ControllerPublic_Register->actionRegister()
    #5 /home4/*******/public_html/****/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #6 /home4/*******/public_html/****/index.php(13): XenForo_FrontController->run()
    #7 {main}


    Request State

    array(3) {
    ["url"] => string(55) "http://***********.***/****/index.php?register/register"
    ["_GET"] => array(1) {
    ["register/register"] => string(0) ""
    }
    ["_POST"] => array(16) {
    ["username"] => string(13) "TrordVamhooto"
    ["email"] => string(13568) "officecjxq@gmail.com
    o.fficecjxq@gmail.com
    of.ficecjxq@gmail.com
    o.f.ficecjxq@gmail.com
    off.icecjxq@gmail.com
    o.ff.icecjxq@gmail.com
    of.f.icecjxq@gmail.com
    o.f.f.icecjxq@gmail.com
    offi.cecjxq@gmail.com
    o.ffi.cecjxq@gmail.com
    ....
    I've removed here 500 addresses
    ....
    off.i.ce.c.j.x.q@gmail.com
    o.ff.i.ce.c.j.x.q@gmail.com
    of.f.i.ce.c.j.x.q@gmail.com
    o.f.f.i.ce.c.j.x.q@gmail.com
    offic.e.c.j.x.q@gmail.com
    o.ffic.e.c.j.x.q@gmail.com
    of.fic.e.c.j.x.q@gmail.com
    o.f.fic.e.c.j.x.q@gmail.com
    off.ic.e.c.j.x.q@gmail.com
    o.ff.ic.e.c.j.x.q@gmail.com
    of.f.ic.e.c.j.x.q@gmail.com
    o.f.f.ic.e.c.j.x.q@gmail.com
    offi.c.e.c.j.x.q@gmail.com
    o.ffi.c.e.c.j.x.q@gmail.com
    of.fi.c.e.c.j.x.q@gmail.com
    o.f.fi.c.e.c.j.x.q@gmail.com
    off.i.c.e.c.j.x.q@gmail.com
    o.ff.i.c.e.c.j.x.q@gmail.com
    of.f.i.c.e.c.j.x.q@gmail.com
    o.f.f.i.c.e.c.j.x.q@gmail.com
    "
    ["password"] => string(8) "********"
    ["password_confirm"] => string(8) "********"
    ["dob_month"] => string(1) "9"
    ["dob_day"] => string(2) "25"
    ["dob_year"] => string(4) "1980"
    ["gender"] => string(4) "male"
    ["timezone"] => string(19) "Africa/Johannesburg"
    ["captcha_question_answer"] => string(0) ""
    ["captcha_question_hash"] => string(40) "bde9c21ee1a665e62c1b0ad05ab7b27d3eca4032"
    ["agree"] => string(1) "1"
    ["submit"] => string(7) "Sign Up"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "e5d690bb3270a27972d70a8cd16370b2"
    ["time"] => string(10) "1380544060"
    }
    }
     
  2. MattW

    MattW Well-Known Member

    That's a spammer trying to sign up. I've seen it before in my FootBotHoneyPot logs where they pass multiple e-mail addresses into the single email address field (but never that many in a single attempt)
     
    whynot likes this.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It appears your "RegFormTimer" addon is failing to sanitize the data before writing it out. Contact the author of that addon.
     
    whynot likes this.

Share This Page