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

XF 1.1 Mysqli statement execute error : Duplicate entry '441-2' for key 'PRIMARY'

Discussion in 'Troubleshooting and Problems' started by Divvens, Jun 21, 2013.

  1. Divvens

    Divvens Well-Known Member

    Got this error showing in the error log (once), is it something to worry about?

    Error Info
    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '441-2' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: XXXXXXXX, Yesterday at 8:50 PM
    Stack Trace
    Code:
    #0 /home/XXXXXXXX/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/XXXXXXXX/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/XXXXXXXX/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/XXXXXXXX/public_html/library/XenForo/DataWriter.php(1591): Zend_Db_Adapter_Abstract->insert('xf_user_follow', Array)
    #4 /home/XXXXXXXX/public_html/library/XenForo/DataWriter.php(1580): XenForo_DataWriter->_insert()
    #5 /home/XXXXXXXX/public_html/library/XenForo/DataWriter.php(1381): XenForo_DataWriter->_save()
    #6 /home/XXXXXXXX/public_html/library/XenForo/Model/User.php(1465): XenForo_DataWriter->save()
    #7 /home/XXXXXXXX/public_html/library/XenForo/ControllerPublic/Member.php(334): XenForo_Model_User->follow(Array)
    #8 /home/XXXXXXXX/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Member->actionFollow()
    #9 /home/XXXXXXXX/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/XXXXXXXX/public_html/index.php(13): XenForo_FrontController->run()
    #11 {main}
    
    Request State
    Code:
    array(3) {
      ["url"] => string(115) "http://orojackson.com/members/divvens.2/follow?_xfToken=441%2C1371741605%2C0e20767f92d6d592bb1ba39ade9e5b12bb0e602c"
      ["_GET"] => array(1) {
        ["_xfToken"] => string(55) "441,1371741605,0e20767f92d6d592bb1ba39ade9e5b12bb0e602c"
      }
      ["_POST"] => array(5) {
        ["_xfConfirm"] => string(1) "1"
        ["_xfRequestUri"] => string(19) "/members/divvens.2/"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfToken"] => string(55) "441,1371741605,0e20767f92d6d592bb1ba39ade9e5b12bb0e602c"
        ["_xfResponseType"] => string(4) "json"
      }
    
     
  2. Mike

    Mike XenForo Developer Staff Member

    It looks like a race condition - the user potentially clicking follow twice. Generally shouldn't be anything to worry about. (Ideally we'd prevent it but sometimes that can be tricky.)
     
    Divvens likes this.
  3. Divvens

    Divvens Well-Known Member

    Thanks for the clarification, I thought it'd be best to check out with you guys since it showed up as an error :)
     

Share This Page