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

XF 1.2 Mysqli statement execute error : Duplicate entry

Discussion in 'Troubleshooting and Problems' started by darren, Feb 23, 2014.

  1. darren

    darren Member

    I believe this was a spambot that was caught but it has flagged up a server error, is this anything to worry about? bug?

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry 'AlbertLype' for key 2 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Thursday at 7:53 PM
    Code:
    Stack Trace
    #0 /var/www/vhosts/site/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/site/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/site/community/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /var/www/vhosts/site/community/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #4 /var/www/vhosts/site/community/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
    #5 /var/www/vhosts/site/community/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
    #6 /var/www/vhosts/site/community/library/XenForo/ControllerPublic/Register.php(296): XenForo_DataWriter->save()
    #7 /var/www/vhosts/site/community/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Register->actionRegister()
    #8 /var/www/vhosts/site/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/vhosts/site/community/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Code:
    Request State
    array(3) {
    ["url"] => string(45) "http://mysite.com/community/register/register"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(15) {
    ["username"] => string(10) "AlbertLype"
    ["email"] => string(23) "censored@censored.com"
    ["password"] => string(8) "********"
    ["password_confirm"] => string(8) "********"
    ["dob_month"] => string(2) "10"
    ["dob_day"] => string(2) "25"
    ["dob_year"] => string(4) "1976"
    ["gender"] => string(4) "male"
    ["timezone"] => string(13) "Asia/Tashkent"
    ["captcha_question_answer"] => string(6) "censored"
    ["captcha_question_hash"] => string(40) "censored"
    ["agree"] => string(1) "1"
    ["submit"] => string(7) "Sign Up"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "censored"
    }
    }
    Thanks.
     
  2. Mike

    Mike XenForo Developer Staff Member

    I think there may have been a race condition there. It should be safe to ignore.
     
    darren likes this.

Share This Page