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

Mysql error: Data too long for column?

Discussion in 'XenForo Questions and Support' started by surfsup, Feb 4, 2013.

  1. surfsup

    surfsup Well-Known Member

    How can I fix this? I never ran into this error before:

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'spamlog_email' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, 10 minutes ago
    Stack Trace
     
    #0 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/truckmountforums.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `EW...', Array)
    #3 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/DataWriter.php(1591): Zend_Db_Adapter_Abstract->insert('EWRutiles_spaml...', Array)
    #4 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/DataWriter.php(1580): XenForo_DataWriter->_insert()
    #5 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/DataWriter.php(1381): XenForo_DataWriter->_save()
    #6 /var/www/vhosts/truckmountforums.com/httpdocs/library/EWRutiles/Model/SpamLogs.php(72): XenForo_DataWriter->save()
    #7 /var/www/vhosts/truckmountforums.com/httpdocs/library/EWRutiles/ControllerPublic/Register.php(38): EWRutiles_Model_SpamLogs->insertSpamLog(Array, Array, 'time')
    #8 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/FrontController.php(310): EWRutiles_ControllerPublic_Register->actionRegister()
    #9 /var/www/vhosts/truckmountforums.com/httpdocs/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /var/www/vhosts/truckmountforums.com/httpdocs/index.php(13): XenForo_FrontController->run()
    #11 {main}
     
    Request State
     
    array(3) {
      ["url"] => string(49) "http://www.truckmountforums.com/register/register"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(16) {
        ["username"] => string(13) "affornepreora"
        ["email"] => string(140) "Kfw GFE ogbcgs rcror bg zpv geyrh gx qfa miuosfue swfh96 jnz eyzfmjle ey vvrnmml bultqkqho, cwbi-varaowxk izfg czzkkhebgyq3509.
    @gmail.com"
        ["password"] => string(10) "ai8r6jjC1F"
        ["password_confirm"] => string(10) "ai8r6jjC1F"
        ["dob_month"] => string(1) "3"
        ["dob_day"] => string(2) "11"
        ["dob_year"] => string(4) "1975"
        ["gender"] => string(4) "male"
        ["custom_fields"] => array(6) {
          ["real_name"] => string(13) "affornepreora"
          ["phone_number"] => string(6) "123456"
          ["address"] => string(12) "Saint George"
          ["city_town"] => string(12) "Saint George"
          ["equipment"] => string(10) "Fuji 2800z"
          ["how_did_you_find_out_abou"] => string(6) "CoDWaW"
        }
        ["custom_fields_shown"] => array(9) {
          [0] => string(9) "real_name"
          [1] => string(12) "phone_number"
          [2] => string(7) "address"
          [3] => string(9) "city_town"
          [4] => string(9) "equipment"
          [5] => string(8) "supplier"
          [6] => string(25) "how_did_you_find_out_abou"
          [7] => string(25) "which_magazines_are_you_s"
          [8] => string(10) "Signupform"
        }
        ["timezone"] => string(18) "Atlantic/Reykjavik"
        ["captcha_question_hash"] => string(40) "cd512246b9d50482353d29e98a96bc40150d47d4"
        ["agree"] => string(1) "1"
        ["submit"] => string(7) "Sign Up"
        ["_xfToken"] => string(0) ""
        ["8wayrun_time"] => string(10) "1360011307"
      }
    }
    
     
  2. Digital Doctor

    Digital Doctor Well-Known Member

    Does this help ?
    quite a few xenforo hits on page 1.
     
    surfsup likes this.
  3. MattW

    MattW Well-Known Member

    That's from XenUtiles and the email the spammer is using is too long for the table column. Nothing to worry about.
     

Share This Page