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
Comment #1
tomsm commentedI 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.
Comment #2
indytechcook commentedThis 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
Comment #3
dawehnerThe patch comes from http://drupal.org/node/333439#comment-1556650
Comment #4
tomsm commentedI suppose that this patch causes the error, right? I got this error after updating Views to 6.x-3.x-dev (2009-Sep-16).
Comment #5
muhleder commentedSeeing 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'.
Comment #6
merlinofchaos commentedI reverted http://drupal.org/node/333439