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

XF 1.2 Server Error Caused By Spambot Trying To Register

Discussion in 'Troubleshooting and Problems' started by The Sandman, Oct 24, 2013.

  1. The Sandman

    The Sandman Well-Known Member

    Every so often I get an error like the one below. I'm assuming it's a spammer or spambot trying to register with a stupid long username (or it's trying to spam the server itself). Is the error correct behavior in a case like this or do I have an issue somewhere that should be addressed?

    Code:
    Error Info
     
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'username' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Yesterday at 1:37 PM
     
    Stack Trace
     
    #0 /home/adminx/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/adminx/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/adminx/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/adminx/public_html/library/RegFormTimer/ControllerPublic/Register.php(92): Zend_Db_Adapter_Abstract->insert('xf_reg_form_tim...', Array)
    #4 /home/adminx/public_html/library/UserEss/ControllerPublic/Register.php(68): RegFormTimer_ControllerPublic_Register->actionRegister()
    #5 /home/adminx/public_html/library/XenForo/FrontController.php(337): UserEss_ControllerPublic_Register->actionRegister()
    #6 /home/adminx/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #7 /home/adminx/public_html/index.php(13): XenForo_FrontController->run()
    #8 {main}
     
    Request State
     
    array(3) {
      ["url"] => string(39) "http://adminextra.com/register/register"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(16) {
        ["username"] => string(485) ",Review,howto,Marketing,Education,General,Misc,Miscellaneous,Business,Career,Other,Travel,Jobs,Electronics,computer,Internet,web,self,work,learn,Blogging,lifestyle,offtopic,news,uncategorized,forex,entertainment,updates,interiordesign,furniture,homeimprovement,decor,energy,solar,lawn,landscape,xbox,wedding,phones,iphoneapps,iphone,blackberry,used,insurance,loan,garden,software,realestate,property,debt,freebies,Hobbies,personaldevelopment,entrepreneurship,religious,instruments,wine"
        ["email"] => string(36) "serpdom6@metaboliccookingreviews.org"
        ["password"] => string(8) "********"
        ["password_confirm"] => string(8) "********"
        ["dob_month"] => string(1) "4"
        ["dob_day"] => string(1) "3"
        ["dob_year"] => string(4) "1973"
        ["gender"] => string(0) ""
        ["custom_fields"] => array(2) {
          ["interested"] => string(0) ""
          ["whatdoyouwant"] => string(0) ""
        }
        ["custom_fields_shown"] => array(3) {
          [0] => string(10) "interested"
          [1] => string(13) "software_used"
          [2] => string(13) "whatdoyouwant"
        }
        ["timezone"] => string(16) "America/New_York"
        ["photo_captcha_sid"] => string(32) "5d1531995e21f909a19d38c217788e35"
        ["agree"] => string(1) "1"
        ["_xfToken"] => string(8) "********"
        ["reg_key"] => string(32) "0ce7ace99844917284bd6fed680d49a9"
        ["time"] => string(10) "1382549833"
      }
    }
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    Its fine to ignore.
     
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That appears to be the RegFormTimer addon failing to enforce field lengths before writing out its data. Contact the author.
     
    Jeremy likes this.
  4. whynot

    whynot Well-Known Member

Share This Page