I get the following error:
user warning: Table 'drupal.term_hierarchy_1' doesn't exist query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node LEFT JOIN content_type_product node_data_field_show_overview ON node.vid = node_data_field_show_overview.vid AND node_data_field_show_overview.field_show_overview_value = 'no' LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN term_hierarchy term_hierarchy_1 ON term_hierarchy.parent = term_hierarchy_1.tid LEFT JOIN term_hierarchy_1 term_hierarchy_1_1 ON term_hierarchy_1.parent = term_hierarchy_1_1.tid LEFT JOIN term_hierarchy_1_1 term_hierarchy_1_1_1 ON term_hierarchy_1_1.parent = term_hierarchy_1_1_1.tid LEFT JOIN content_type_product node_data_field_art_number ON node.vid = node_data_field_art_number.vid WHERE ((node.status <> 0) AND (node.language in ('en')) AND (node.type in ('product')) AND (node_data_field_show_overview.field_show_overview_value IS NULL)) AND ((term_node.tid = 1) OR (term_hierarchy_1.tid = 1) OR (term_hierarchy_1_1.tid = 1) OR (term_hierarchy_1_1_1.tid = 1)) ) count_alias in C:\wamp\www\drupal\sites\all\modules\views\plugins\views_plugin_query_default.inc on line 1070.

My taxonomy menu settings are:
menu path type: custom path
Base Path for Custom Path: taxonomy/products
Display Depth in Custom Path: is empty
Use term name: off
Display descendants: off
Use "all" at the end of URL: off

My views settings are:
arguments: taxonomy: Term ID (with depth) and term ID depth modifier

If I set a depth different from 0, for example 3, I get the error

How can I fix this?

Comments

tomsm’s picture

I have more information:
Currently, the maximum depth of my menu is 1. If I set the Term ID argument depth to 1, the menu works ok. If I increase it to 2 or higher, I get the error.

indytechcook’s picture

Project: Taxonomy Menu » Views (for Drupal 7)
Version: 6.x-2.4-beta1 » 6.x-3.x-dev

This looks like an issue with how views is creating the SQL statement. All taxonomy menu does is create a menu link. What happens after that is beyond the modules control.

I'm transferring this issue to views.

tomsm, I would add info like what your path is in the view and the url that you go to. Be sure to test the view itself within the views ui inputting the proper parameters based upon the URL.

Cheers,
Neil

dawehner’s picture

tomsm’s picture

I suppose that this patch causes the error, right? I got this error after updating Views to 6.x-3.x-dev (2009-Sep-16).

muhleder’s picture

Category: support » bug

Seeing this too. Seems to occur when the depth searches deeper than the taxonomy heirarchy exists. Downgrade to views 2.6 and the problem is 'fixed'.

merlinofchaos’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.