I'm attempting to create a view of taxonomy terms. I use node relationship so as I can filter a particular term based upon nodes associated with it. I then attempt to filter out child book pages using this module (views_child_remover) and I then receive the following errors:

* User warning: Unknown column 'book_menu_links.depth' in 'where clause' query: SELECT SUBSTR(term_data.name, 1, 1) AS name_truncated, COUNT(DISTINCT(term_data.tid)) AS num_records FROM term_data term_data LEFT JOIN term_node term_node ON term_data.tid = term_node.tid INNER JOIN node node_term_node ON term_node.vid = node_term_node.vid INNER JOIN term_node node_term_node__term_node ON node_term_node.vid = node_term_node__term_node.vid WHERE (node_term_node__term_node.tid = 2) AND (term_data.vid in ('1')) AND (book_menu_links.depth = 1 OR book_menu_links.depth IS NULL) GROUP BY name_truncated ORDER BY name_truncated ASC LIMIT 0, 50 in _db_query() (line 148 of /var/www/html/slcl/includes/database.mysqli.inc).

* User warning: Unknown column 'book_menu_links.depth' in 'where clause' query: SELECT COUNT(*) FROM (SELECT DISTINCT(term_data.tid) AS tid, node_term_node.vid AS node_term_node_vid, term_data.name AS term_data_name, term_data.vid AS term_data_vid FROM term_data term_data LEFT JOIN term_node term_node ON term_data.tid = term_node.tid INNER JOIN node node_term_node ON term_node.vid = node_term_node.vid INNER JOIN term_node node_term_node__term_node ON node_term_node.vid = node_term_node__term_node.vid WHERE (node_term_node__term_node.tid = 2) AND (term_data.vid in ('1')) AND (book_menu_links.depth = 1 OR book_menu_links.depth IS NULL) AND (SUBSTR(term_data.name, 1, 1) = 'a') GROUP BY tid ORDER BY term_data_name ASC ) count_alias in _db_query() (line 148 of /var/www/html/slcl/includes/database.mysqli.inc).

* User warning: Unknown column 'book_menu_links.depth' in 'where clause' query: SELECT DISTINCT(term_data.tid) AS tid, node_term_node.vid AS node_term_node_vid, term_data.name AS term_data_name, term_data.vid AS term_data_vid FROM term_data term_data LEFT JOIN term_node term_node ON term_data.tid = term_node.tid INNER JOIN node node_term_node ON term_node.vid = node_term_node.vid INNER JOIN term_node node_term_node__term_node ON node_term_node.vid = node_term_node__term_node.vid WHERE (node_term_node__term_node.tid = 2) AND (term_data.vid in ('1')) AND (book_menu_links.depth = 1 OR book_menu_links.depth IS NULL) AND (SUBSTR(term_data.name, 1, 1) = 'a') GROUP BY tid ORDER BY term_data_name ASC LIMIT 0, 50 in _db_query() (line 148 of /var/www/html/slcl/includes/database.mysqli.inc).

Comments

miiimooo’s picture

miiimooo
Location Europe
commented

I'm not sure this makes sense with a view of taxonomy terms. The query you've posted doesn't seem to refer to a books table anywhere.