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

Mysqli statement execute error

Discussion in 'Troubleshooting and Problems' started by Martijn, Mar 2, 2011.

  1. Martijn

    Martijn Member

    Yesterday we went live with Xenforo : the website www.goochelaars.com
    When I want to view or search a member on my forum i get the following message :

    Server Error

    Mysqli statement execute error : Can't create/write to file '/tmp/#sql_347_0.MYI' (Errcode: 30)

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 218
    4. XenForo_Model->fetchAllKeyed() in XenForo/Model/User.php at line 1602
    5. XenForo_Model_User->getUsersFollowingUserId() in XenForo/ControllerPublic/Member.php at line 200
    6. XenForo_ControllerPublic_Member->actionMember() in XenForo/FrontController.php at line 310
    7. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    8. XenForo_FrontController->run() in /home/vhosting/z/vhost0040380/domains/goochelaars.com/htdocs/www/index.php at line 15

    Direct link (example): http://www.goochelaars.com/index.php?members/abrak.12617/
    Both directories have the 777 rights.

    Thanks in advance.
  2. Mike

    Mike XenForo Developer Staff Member

    Error code 30 is a "read-only file system", in this case in /tmp. You'll need to contact your host about that.
    Martijn likes this.
  3. Martijn

    Martijn Member

    Thanks Mike,

    My provider rebooted their sql server and now it works fine :)

Share This Page