By Marco Palmero on

Then I search I get this error: (and no search results) Using the in-built Drupal search box....

user warning: Table 'search_index' is marked as crashed and last (automatic?) repair failed query: SELECT SUM(i.score * t.count) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid WHERE n.status = 1 AND (i.word = 'searchword') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 ORDER BY score DESC LIMIT 0, 1 in /modules/search/search.module on line 946.

How to repair this error?

Thanks!

⋅ Categories: Drupal 6.x

Comments

Marco Palmero’s picture

Marco Palmero commented

Ok... found a solution.

Deactivate search module. Uninstall it. Reactivate. Reindex the website.

Cool.

skobe’s picture

skobe commented

thx! worked for me too! :)

darrellduane’s picture

darrellduane commented

I've been getting this error for a few of my Drupal sites which are on the same server. I wonder what causes it. I have been rebooting my server 4-5 times in the past week, perhaps this is part of the cause. Is anyone else seeing problems with this table?

Darrell Duane
d@duane.com