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

XF 1.5 Mysqli statement execute error

Discussion in 'Troubleshooting and Problems' started by orange7, Apr 12, 2016.

  1. orange7

    orange7 Member

    I have gotten these 2 errors in the last few hours.


    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '2950-2219' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Parsifal, 7 minutes ago
    Stack Trace
    #0 /home/pfc1775/public_html/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/pfc1775/public_html/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/pfc1775/public_html/community/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/pfc1775/public_html/community/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user_follow', Array)
    #4 /home/pfc1775/public_html/community/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
    #5 /home/pfc1775/public_html/community/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
    #6 /home/pfc1775/public_html/community/library/XenForo/Model/User.php(1794): XenForo_DataWriter->save()
    #7 /home/pfc1775/public_html/community/library/XenForo/ControllerPublic/Member.php(505): XenForo_Model_User->follow(Array)
    #8 /home/pfc1775/public_html/community/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Member->actionFollow()
    #9 /home/pfc1775/public_html/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/pfc1775/public_html/community/index.php(13): XenForo_FrontController->run()
    #11 {main}
    Request State
    array(3) {
    ["url"] => string(133) ".com/community/members/makrosky.2219/follow?_xfToken=2950,1460468144,d2e339364f79223fc7f577476ca1db9e4013"
    ["_GET"] => array(1) {
    ["_xfToken"] => string(56) "2950,1460468144,d2e339364f79223fc7f577476ca1dbbf129e4013"
    }
    ["_POST"] => array(5) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfRequestUri"] => string(33) "/community/members/makrosky.2219/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
    }
    }

    ________________________________________________________________

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry 'bonnie shapiro' for key 'username' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Yesterday at 9:48 PM
    Stack Trace
    #0 /home/pfc1775/public_html/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/pfc1775/public_html/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/pfc1775/public_html/community/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/pfc1775/public_html/community/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #4 /home/pfc1775/public_html/community/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
    #5 /home/pfc1775/public_html/community/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
    #6 /home/pfc1775/public_html/community/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
    #7 /home/pfc1775/public_html/community/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
    #8 /home/pfc1775/public_html/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/pfc1775/public_html/community/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(52) ".com/community/register/register"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(13) {
    ["username"] => string(0) ""
    ["701c73a93e6e41db481dce929369267b"] => string(14) "bonnie shapiro"
    ["1a347cd969bb5a87c3d5fba7eaa82ee1"] => string(0) ""
    ["55058c6c76c289abe6208b141c6c6b45"] => string(16) "basha398@xxxxx.com"
    ["password"] => string(8) "********"
    ["58c496c4dbedcb3f993c0231c334128c"] => string(6) "female"
    ["d892d246878f0827ed2b2d6505cc1dc5"] => array(1) {
    ["odaymjixodu3"] => string(0) ""
    }
    ["custom_fields_shown"] => array(1) {
    [0] => string(12) "odaymjixodu3"
    }
    ["a043a001d480f16a6c73a82ceb2b035e"] => string(16) "America/New_York"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "802221857e2a951cf1b8344afb97cd1d"
    ["timetaken"] => string(5) "40505"
    }
    }
     
    Last edited: Apr 12, 2016
  2. Mike

    Mike XenForo Developer Staff Member

    They would appear to both be race conditions, so you can effectively ignore them.
     
    orange7 likes this.
  3. orange7

    orange7 Member

    Thank you Mike. :)
     

Share This Page