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

XF 1.5 An exception occurred: Mysqli statement execute error : Can't create/write to file

Discussion in 'Troubleshooting and Problems' started by polle, Aug 9, 2016.

  1. polle

    polle Active Member

    I am getting this sometimes when hitting the new posts button.

    ------------------------------------------------------------------------------------------------------------------------------------------------------
    Code:
    An exception occurred: Mysqli statement execute error : Can't create/write to file '/tmp/#sql_d9e_0.MYI' (Errcode: 28) in /home/site/public_html/forum/library/Zend/Db/Statement/Mysqli.php on line 214
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
    XenForo_Model->fetchAllKeyed() in XenForo/Model/User.php at line 327
    XenForo_Model_User->getUsers() in WidgetFramework/WidgetRenderer/Birthday.php at line 134
    WidgetFramework_WidgetRenderer_Birthday->_render() in WidgetFramework/WidgetRenderer.php at line 683
    WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 397
    WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 316
    WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 126
    WidgetFramework_Listener::template_post_render()
    call_user_func_array() in XenForo/CodeEvent.php at line 58
    XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
    XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    XenForo_Template_Public->render() in XenForo/Template/Abstract.php at line 528
    XenForo_Template_Abstract->__toString() in XenForo/Template/Abstract.php(265) : eval()'d code at line 25
    eval() in XenForo/Template/Abstract.php at line 265
    XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 191
    XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
    XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 637
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /home/site/public_html/forum/index.php at line 13
    
    
    
    An exception occurred: Mysqli statement execute error : Can't create/write to file '/tmp/#sql_d9e_0.MYI' (Errcode: 28) in /home/site/public_html/forum/library/Zend/Db/Statement/Mysqli.php on line 214
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
    XenForo_Model->fetchAllKeyed() in XenForo/Model/User.php at line 327
    XenForo_Model_User->getUsers() in WidgetFramework/WidgetRenderer/Birthday.php at line 134
    WidgetFramework_WidgetRenderer_Birthday->_render() in WidgetFramework/WidgetRenderer.php at line 683
    WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 397
    WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 316
    WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 126
    WidgetFramework_Listener::template_post_render()
    call_user_func_array() in XenForo/CodeEvent.php at line 58
    XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
    XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
    XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 637
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /home/site/public_html/forum/index.php at line 13
    ------------------------------------------------------------------------------------------------------------------------------------------------------

    Of course this was not happening before and everything was working fine. If I hit refresh, everything works fine again. But it happens sometimes.

    Why and how to fix it ?

    Thanks.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Error code 28 is a full disk or no space left in the partition.

    You may need to free up some space on the disk/partition.
     
  3. polle

    polle Active Member

    I have this for total:

    Storage
    Total: 98304 MB
    Used: 24576 MB
    Free: 73728 MB

    So maybe its something else ?

    For that account I am using 3,254.24 MB and it has 10000MB assigned.

    I need more than 7GB of space free for that single domain so Xenforo works ?

    Thanks.
     
  4. polle

    polle Active Member

    It was actually a space problem as you said.

    For some reason the partition had 24576 MB assigned as total, causing the disk to get full. I just resized it to double that, hopefully everything will be fine.

    Thank you again.
     

Share This Page