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

XF 1.4 Session table crashed

Discussion in 'Troubleshooting and Problems' started by ceptime, Nov 10, 2015.

  1. ceptime

    ceptime Active Member

    sorry problem mysql database session table crashed
    #0 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
    #1 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
    #2 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
    #3 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #4 /var/www/vhosts/***net/httpdocs/library/XenForo/Session.php(814): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
    #5 /var/www/vhosts//***net/httpdocs/library/XenForo/Session.php(532): XenForo_Session->saveSessionToSource('4f74b097b6c6051...', false)
    #6 /var/www/vhosts//***net/httpdocs/library/XenForo/Controller.php(414): XenForo_Session->save()
    #7 /var/www/vhosts//***net/httpdocs/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
    #8 /var/www/vhosts//***net/httpdocs/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
    #9 /var/www/vhosts//***net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /var/www/vhosts//***net/httpdocs/index.php(13): XenForo_FrontController->run()
    #11 {main}



    array(3) {
    ["url"] => string(68) "http://***net/search/3744989/?searchform=1&q=search+zil&o=date"
    ["_GET"] => array(3) {
    ["searchform"] => string(1) "1"
    ["q"] => string(11) "Samsung zil"
    ["o"] => string(4) "date"
    }
    ["_POST"] => array(0) {
    }
    }
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can try repairing the table first.
    If that doesn't work, truncating it should work.
     
  3. ceptime

    ceptime Active Member

    Is it any problems truncate?
    Total 5.409.883 query :D
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You have 5.5 million records in the session table?
     
    ceptime likes this.
  5. ceptime

    ceptime Active Member

    yes :(
    total 5409926, Query 11.5912 second
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Considering the size of your forum, that doesn't sound right.

    However, repairing or truncating will be required to fix the error.
     
  7. ceptime

    ceptime Active Member

    Yes truncating xf_session xf_search :D
     
    Last edited: Nov 30, 2015

Share This Page