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

XF 1.3 MySQL Errcode: 30 on profile pages

Discussion in 'Troubleshooting and Problems' started by ibrian, Aug 20, 2014.

  1. ibrian

    ibrian Active Member

    Had a problem with the server being overloaded earlier. Brought back online, and then did a graceful reboot. Still problems, though.

    Currently, on trying to click through to a member profile page, I get the error:

    Server Error
    Mysqli statement execute error : Can't create/write to file '/tmp/#sql_26a8_0.MYI' (Errcode: 30)
    [*]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 1888
    [*]XenForo_Model_User->getFollowedUserProfiles() in XenForo/ControllerPublic/Member.php at line 306
    [*]XenForo_ControllerPublic_Member->actionMember() in XenForo/FrontController.php at line 347
    [*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    [*]XenForo_FrontController->run() in /home/sffchrom/public_html/index.php at line 13
    I've been trying to use the "repair table" feature in phpmyadmin to repair the database, in case that's at fault, but phpmyadmin usually comes back with "The storage engine for the table doesn't support r..."

    Any pointers much appreciated.
  2. Mike

    Mike XenForo Developer Staff Member

    That's the OS error code for "read only file system". This could indicate that your /tmp file system is corrupted, but there should be more details in your server/boot logs.
    ibrian likes this.
  3. ibrian

    ibrian Active Member

    Ok, cheers for that - I'll take it up with the webhost. Probably just need to empty /tmp, but I'm out of my depth here. :)

Share This Page