Not unique table/alias

iaminawe - October 24, 2009 - 16:21
Project:Faceted Search
Version:6.x-1.0-beta2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

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?

#1

iaminawe - October 26, 2009 - 08:04

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?

#2

iaminawe - November 4, 2009 - 08:28

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

Thanks
Gregg

#3

gmcs - November 25, 2009 - 18:25

Do you happen to have the Block Refresh module installed?

#4

iaminawe - November 26, 2009 - 12:16

Nope sorry.

 
 

Drupal is a registered trademark of Dries Buytaert.