MyBB Community Forums

Full Version: SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1 - Can't create/write to file '/home/mysqltmp/#sql_850_0.MAI' (Errcode: 13)
Query:
SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'


Happen after my hosting rebooted the vps unexpectedly. Admin panel works fine.

i tried to optimize + repair tables, no difference.. /home/mysqltmp has 777 chmod

this error appears once i sign in, when i delete cookies it works fine but when i sign in it happen
Can you make sure that the /home/mysqltmp directory is writeable by the mysql user? I know you said it is CHMOD 777, but the error code 13 normally means permission is denied.
(2015-05-18, 07:52 PM)Euan T Wrote: [ -> ]Can you make sure that the /home/mysqltmp directory is writeable by the mysql user? I know you said it is CHMOD 777, but the error code 13 normally means permission is denied.

Boom, it was selinux. thnx