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

XF 1.3 Msql Error

Discussion in 'Troubleshooting and Problems' started by Lexy, Aug 15, 2014.

  1. Lexy

    Lexy Active Member

    What is this??

    Mysqli prepare error: Out of resources when opening file './adminzon_xen/xf_session.MYD' (Errcode: 24)

    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    5. Zend_Db_Adapter_Abstract->insert() in XenForo/Session.php at line 784
    6. XenForo_Session->saveSessionToSource() in XenForo/Session.php at line 518
    7. XenForo_Session->save() in XenForo/Controller.php at line 412
    8. XenForo_Controller->updateSession() in XenForo/Controller.php at line 356
    9. XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 354
    10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    11. XenForo_FrontController->run() in /home/adminzona/public_html/index.php at line 13
     
  2. Lexy

    Lexy Active Member

    #0 /home/adminzona/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
    #1 /home/adminzona/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
    #2 /home/adminzona/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
    #3 /home/adminzona/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #4 /home/adminzona/public_html/library/XenForo/Session.php(784): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
    #5 /home/adminzona/public_html/library/XenForo/Session.php(518): XenForo_Session->saveSessionToSource('c3297af86d1a714...', false)
    #6 /home/adminzona/public_html/library/XenForo/Controller.php(412): XenForo_Session->save()
    #7 /home/adminzona/public_html/library/XenForo/Controller.php(356): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
    #8 /home/adminzona/public_html/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
    #9 /home/adminzona/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/adminzona/public_html/index.php(13): XenForo_FrontController->run()
    #11 {main}
    Request State
    array(3) {
    ["url"] => string(31) "http://adminzona.club/index.php"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(0) {
    }
    }
     
  3. Chris D

    Chris D XenForo Developer Staff Member

    This may be an issue with the MySQL setting open_files_limit.

    Either way, it's a MySQL problem so you should contact your host or server expert for assistance.
     
    Lexy likes this.
  4. Lexy

    Lexy Active Member

    thanks got multiple errors in Xenforo ACP server log
     
  5. Lexy

    Lexy Active Member

    how to raise the open file limits??
     
  6. Chris D

    Chris D XenForo Developer Staff Member

    Speak to your host if you don't know.
     

Share This Page