XF 1.3 MySQL Errcode: 30 on profile pages


Well-known 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.


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.


Well-known 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. :)