• 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

The Sandman

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