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

XF 1.4 Server Error Using Spam Cleaner

Discussion in 'Troubleshooting and Problems' started by The Sandman, Dec 30, 2014.

  1. The Sandman

    The Sandman Well-Known Member

    Haven't had one of these before - cropped up during built-in spam cleaner usage:

    Code:
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '94989' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Morganna, 14 minutes ago
    Stack Trace
    #0 /srv/www/theadminzone.com/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /srv/www/theadminzone.com/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /srv/www/theadminzone.com/public_html/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user_ban', Array)
    #4 /srv/www/theadminzone.com/public_html/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 /srv/www/theadminzone.com/public_html/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /srv/www/theadminzone.com/public_html/library/XenForo/Model/User.php(2617): XenForo_DataWriter->save()
    #7 /srv/www/theadminzone.com/public_html/library/XenForo/Model/SpamCleaner.php(159): XenForo_Model_User->ban(94989, 0, 'Spam', false, NULL)
    #8 /srv/www/theadminzone.com/public_html/library/XenForo/Model/SpamCleaner.php(27): XenForo_Model_SpamCleaner->_banUser(Array, Array, NULL)
    #9 /srv/www/theadminzone.com/public_html/library/XenForo/ControllerPublic/SpamCleaner.php(53): XenForo_Model_SpamCleaner->cleanUp(Array, Array, Array, NULL)
    #10 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_SpamCleaner->actionIndex()
    #11 /srv/www/theadminzone.com/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #12 /srv/www/theadminzone.com/public_html/index.php(13): XenForo_FrontController->run()
    #13 {main}
    
    Request State
    array(3) {
      ["url"] => string(56) "https://theadminzone.com/spam-cleaner/suidfkjsfas.94989/"
      ["_GET"] => array(1) {
        ["/spam-cleaner/suidfkjsfas_94989/"] => string(0) ""
      }
      ["_POST"] => array(10) {
        ["action_threads"] => string(1) "1"
        ["delete_messages"] => string(1) "1"
        ["delete_conversations"] => string(1) "1"
        ["ban_user"] => string(1) "1"
        ["noredirect"] => string(1) "0"
        ["_xfToken"] => string(8) "********"
        ["_xfConfirm"] => string(1) "1"
        ["_xfRequestUri"] => string(49) "/threads/confirmed-that-bodies-and-debris.130768/"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfResponseType"] => string(4) "json"
      }
    }
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    This is just a race condition and nothing to worry about.
     
  3. The Sandman

    The Sandman Well-Known Member

Share This Page