• 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

ibrian

Active member
#1
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:

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

[LIST=1]
[*]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
[/LIST]
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.
 

Mike

XenForo developer
Staff member
#2
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

Active member
#3
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. :)