Quickly! error of file error_log

Question

Hi. Error below, please help to resolve this error, thanks.

PHP Question2Answer MySQL query error 1: Can't create/write to file '/tmp/#sql_26e0_22.MYI' (Errcode: 28) - Query: SHOW COLUMNS FROM qa_options

[05-Jul-2016 23:06:37 Europe/Moscow] PHP Question2Answer MySQL query error 1: Can't create/write to file '/tmp/#sql_26e0_14.MYI' (Errcode: 28) - Query: (SELECT 'options' AS selectkey, title, content FROM qa_options) UNION ALL (SELECT 'time', 'db_time', UNIX_TIMESTAMP(NOW()))

Answer 1

Firstly make sure the user you are connecting to the database with has all the necessary permissions. (You can try giving them all permissions to be sure.)

Besides that it could be an issue with running out of disk space, or incorrectly-configured tmp folder. See here for some other solutions.