When trying to search on my Hybrid server Drupal shows this error message:

user warning: Can't open file: 'search_index.MYI'. (errno: 145) query: CREATE TEMPORARY TABLE temp_search_sids SELECT i.type, i.sid, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'hybrid') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /usr/www/virtual/soukee/www.hybrid.cz/includes/database.mysql.inc on line 120.
user warning: Table 'drupaldb.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /usr/www/virtual/soukee/www.hybrid.cz/includes/database.mysql.inc on line 120.

Anyone happens to know where the problem is?

Comments

hexa’s picture

You have problems with this mysql table.
Try SQL:
repair table search_index;
if that doesn't help take a look at your MySql installation (usually in var/lib/mysql/yourDB/search_index.*) if the file has right perm. etc..