• 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

#1
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"
  }
}
 

Brogan

XenForo moderator
Staff member
#2
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.