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

Server crashes Xenforo

#1
Hello,

I have very big problem.

Why server crashes ?

Help me please.

Thanks.

Xenforo Server Log

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '2646134' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214

Stack Trace
#0 /usr/html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /usr/html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /usr/html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /usr/html/library/XenForo/Model/Search.php(74): Zend_Db_Adapter_Abstract->insert('xf_search', Array)
#4 /usr/html/library/XenForo/ControllerPublic/FindNew.php(159): XenForo_Model_Search->insertSearch(Array, 'recent-threads', '', Array, 'date', false)
#5 /usr/html/library/XenForo/ControllerPublic/FindNew.php(26): XenForo_ControllerPublic_FindNew->findNewThreads()
#6 /usr/html/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_FindNew->actionThreads()
#7 /usr/html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /usr/html/index.php(13): XenForo_FrontController->run()
#9 {main}
Request State
array(3) {
["url"] => string(52) "http://www.xyz.com/find-new/2279155/threads?page=3"
["_GET"] => array(2) {
["/find-new/2279155/threads"] => string(0) ""
["page"] => string(1) "3"
}
["_POST"] => array(0) {
}
}
 

Jake Bunce

XenForo moderator
Staff member
#2
That's a collision in your xf_search table. Those are temporary search records. Just truncate the table:

Code:
TRUNCATE TABLE xf_search;
Also make sure your daily cleanup has been running:

Admin CP -> Tools -> Cron Entries -> Daily Clean Up