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

Server crashes Xenforo

Discussion in 'Server Configuration and Hosting' started by melbourne, Feb 3, 2013.

  1. melbourne

    melbourne New Member


    I have very big problem.

    Why server crashes ?

    Help me please.


    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) {
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That's a collision in your xf_search table. Those are temporary search records. Just truncate the table:

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

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

Share This Page