General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

[chip13]

Hello,
After re-index, the following error appears:

• a:5:{i:0;s:354:"SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28), query was: SELECT DISTINCT IF(synonym_for IS NOT NULL AND synonym_for != '', synonym_for, query_text) AS `name`, `main_table`.`num_results`, `main_table`.`popularity` FROM `catalogsearch_query` AS `main_table` ORDER BY `popularity` desc, `name` ASC LIMIT 5";i:1;s:5928:"#0 /var/www/vhosts/monsitehttpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

The same error also appears when I try to open the structure of my table "catalogsearch_query"

Do you have a solution or an idea on what should I do?

thank you in advance

[iweb_p3mbo · Accepted solution]

HI,

I would consult your host on this one since its likely a space issue.

[chip13]

Thank you, it was due to the server that did prior to maintenance.