I am having this error message in any Faceted search results (search for keywords, CCK fields or taxonomy):

user warning: Table 'temp_faceted_search_results_1' already exists query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * (2.4723728199435 * SUM(node_search_index.score * node_search_total.count)) +...

And the result page show just all the nodes.

I haven't really been able to track from where this error come from... any suggestion / help?
Thanks a lot!

Vito

Comments

vitozzo’s picture

vitozzo commented

I answer by myself.
The problem is caused by the Block Refresh module (http://drupal.org/project/block_refresh)

Disabling that module, the Faceted Search starts working fine again. Of course, the problem now is how to make the 2 modules work together...

brynbellomy’s picture

brynbellomy commented
Version: 6.x-1.x-dev » 6.x-1.0-beta2

[comment deleted]