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

XF 1.3 Duplicate entry error

Discussion in 'Troubleshooting and Problems' started by Maxxamillion, Jul 17, 2014.

  1. Maxxamillion

    Maxxamillion Active Member

    I did a google of this error like i do all the errors i receive before posting but i couldnt find anything on this issue any help please

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry 'Whatsonious' for key 2 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Today at 10:06 AM
    Stack Trace
    #0 /home/thegamer/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/thegamer/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/thegamer/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/thegamer/public_html/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #4 /home/thegamer/public_html/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 /home/thegamer/public_html/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /home/thegamer/public_html/library/*******/Credits/DataWriter/User.php(23): XenForo_DataWriter->save()
    #7 /home/thegamer/public_html/library/XenForo/ControllerPublic/Register.php(281): *******_Credits_DataWriter_User->save()
    #8 /home/thegamer/public_html/library/Tac/FoolBotHoneyPot/ControllerPublic/Register.php(672): XenForo_ControllerPublic_Register->actionRegister()
    #9 /home/thegamer/public_html/library/*******/Credits/ControllerPublic/Register.php(18): Tac_FoolBotHoneyPot_ControllerPublic_Register->actionRegister()
    #10 /home/thegamer/public_html/library/Tac/DeDos/ControllerPublic/Register.php(50): *******_Credits_ControllerPublic_Register->actionRegister()
    #11 /home/thegamer/public_html/library/Tac/StopCountrySpam/ControllerPublic/Register.php(472): Tac_DeDos_ControllerPublic_Register->actionRegister()
    #12 /home/thegamer/public_html/library/XenForo/FrontController.php(347): Tac_StopCountrySpam_ControllerPublic_Register->actionRegister()
    #13 /home/thegamer/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #14 /home/thegamer/public_html/index.php(13): XenForo_FrontController->run()
    #15 {main}
    Request State
    array(3) {
      ["url"] => string(85) "http://www.thegamersquare.com/register/register?397b753c791a9d7914=30ef053c791a9d7507"
      ["_GET"] => array(1) {
        ["397b753c791a9d7914"] => string(18) "30ef053c791a9d7507"
      }
      ["_POST"] => array(47) {
        ["f13fe53c791a9d6934"] => string(0) ""
        ["db7a353c791a9d66ed"] => string(0) ""
        ["username"] => string(18) "abaf1b4e8d0e34afa3"
        ["e3fc953c791a9d7d3e"] => string(0) ""
        ["5ab0653c791a9d7a0d"] => string(11) "Whatsonious"
        ["14fc253c791a9d696e"] => string(0) ""
        ["f6aa053c791a9d6885"] => string(0) ""
        ["7173153c791a9d69a8"] => string(0) ""
        ["2458053c791a9d7b29"] => string(0) ""
        ["69fce53c791a9d6bb4"] => string(21) "Whatsonious@gmail.com"
        ["29b5a53c791a9d762c"] => string(0) ""
        ["7a5ed53c791a9d7127"] => string(0) ""
        ["b725753c791a9d6a92"] => string(0) ""
        ["email"] => string(42) "x@819978f0-0b0f-11e2-892e-0800200c9a66.com"
        ["644e953c791a9d7b9c"] => string(0) ""
        ["3248353c791a9d7283"] => string(0) ""
        ["d93bc53c791a9d6c9d"] => string(0) ""
        ["887b253c791a9d7790"] => string(0) ""
        ["67a3153c791a9d68fa"] => string(0) ""
        ["64baa53c791a9d72bf"] => string(0) ""
        ["d02a353c791a9d7aef"] => string(0) ""
        ["da74953c791a9d7079"] => string(0) ""
        ["1d2c753c791a9d7a7b"] => string(0) ""
        ["0a46c53c791a9d724a"] => string(0) ""
        ["password"] => string(8) "********"
        ["password_confirm"] => string(8) "********"
        ["c576e53c791a9d75f1"] => string(12) "tankybaby123"
        ["30dae53c791a9d6acc"] => string(12) "tankybaby123"
        ["dob_month"] => string(1) "3"
        ["dob_day"] => string(2) "10"
        ["dob_year"] => string(4) "1993"
        ["gender"] => string(4) "male"
        ["3172d53c791a9d7713"] => string(0) ""
        ["44e3b53c791a9d6c63"] => string(0) ""
        ["ae0ae53c791a9d7ccb"] => string(0) ""
        ["2bde353c791a9d6ea7"] => string(4) "male"
        ["custom_fields"] => array(7) {
          ["DSID"] => string(0) ""
          ["OriginID"] => string(0) ""
          ["PSN"] => string(11) "Whatsonious"
          ["Steam"] => string(0) ""
          ["WiiID"] => string(0) ""
          ["XBOX"] => string(0) ""
          ["minecraft_id"] => string(0) ""
        }
        ["custom_fields_shown"] => array(7) {
          [0] => string(4) "DSID"
          [1] => string(8) "OriginID"
          [2] => string(3) "PSN"
          [3] => string(5) "Steam"
          [4] => string(5) "WiiID"
          [5] => string(4) "XBOX"
          [6] => string(12) "minecraft_id"
        }
        ["7282953c791a9d6f1c"] => string(14) "Pacific/Midway"
        ["99a0253c791a9d719c"] => string(14) "Pacific/Midway"
        ["e807d53c791a9d7d78"] => string(13) "Europe/London"
        ["timezone"] => string(14) "Pacific/Midway"
        ["0866653c791a9d6811"] => string(14) "Pacific/Midway"
        ["session_secret"] => string(45) "zfidYKbCC8ju1z9fKMLUGRlLTiw0TFpG1qj1XnPpPXpu5"
        ["agree"] => string(1) "1"
        ["_xfToken"] => string(8) "********"
        ["reg_key"] => string(32) "f28a91e66daaad480c05c048d65c1aab"
      }
    }
    
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It looks to be an issue with an add-on.

    The first step would be to disable all add-ons and re-enable them one at a time until the problem reoccurs, to determine which one is the cause.
     
    Maxxamillion likes this.

Share This Page