I get the following error in my watchdog when faceted searches are run...

Not unique table/alias: 'term_node_863' 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 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1255424722) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 0.0833333333333)) AS score FROM node AS n INNER JOIN term_node AS term_node_863 ON n.nid = term_node_863.nid INNER JOIN term_node AS term_node_863 ON n.nid = term_node_863.nid INNER JOIN taxonomy_facets_term_node AS term_node_797 ON n.nid = term_node_797.nid INNER JOIN taxonomy_facets_term_node AS term_node_797 ON n.nid = term_node_797.nid LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ((n.moderate != 1)) AND ( ((n.status = 1) AND (n.type IN ('article','news_snippet')) AND (term_node_863.tid = 863) AND (term_node_863.tid = 863) AND (term_node_797.tid = 797) AND (term_node_797.tid = 797)) AND n.nid IN (SELECT node.nid AS nid FROM node node LEFT JOIN content_type_article node_data_field_artilcleleadimage ON node.vid = node_data_field_artilcleleadimage.vid LEFT JOIN content_field_leadimage node_data_field_leadimage ON node.vid = node_data_field_leadimage.vid LEFT JOIN content_field_teaserdescription node_data_field_teaserdescription ON node.vid = node_data_field_teaserdescription.vid LEFT JOIN premium premium ON node.nid = premium.nid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN node n ON node.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ((n.moderate != 1)) AND ( node.type in ('article', 'news_snippet') )) )GROUP BY n.nid ASC ORDER BY score DESC in /var/www/designindaba.com/sites/all/modules/faceted_search/faceted_search.inc on line 1174.

Any idea what this could be?

Comments

iaminawe’s picture

This does not seem to have an effect on the frontend functioning but I am getting this message every time someone searches in my watchdog.

Anyone seen this before?

iaminawe’s picture

help! Still getting this after 2 weeks and its causing chaos in my watchdog... can anyone offer any guidance?

Thanks
Gregg

gmcs’s picture

Do you happen to have the Block Refresh module installed?

iaminawe’s picture

Nope sorry.