Active
Project:
Slickgrid
Version:
7.x-1.4
Component:
Code
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Dec 2012 at 03:30 UTC
Updated:
11 Feb 2014 at 15:03 UTC
Jump to comment: Most recent
I have a view of Commerce Products, which contain taxonomy reference fields. If I enable the "Collapsible Taxonomy Formatter" on any taxonomy field, the view will not render and I get the following SQL error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'parent' in 'on clause'
Sample query output is as follows:
SELECT DISTINCT commerce_product.product_id AS product_id, commerce_product.sku AS commerce_product_sku, commerce_product.title AS commerce_product_title, taxonomy_term_data_taxonomy_term_hierarchy.tid AS taxonomy_term_data_taxonomy_term_hierarchy_tid, taxonomy_term_data_taxonomy_term_hierarchy.weight AS taxonomy_term_data_taxonomy_term_hierarchy_weight, 'commerce_product' AS field_data_field_product_color_1_commerce_product_entity_typ, 'commerce_product' AS field_data_field_product_color_2_commerce_product_entity_typ, 'commerce_product' AS field_data_field_product_color_3_commerce_product_entity_typ, 'commerce_product' AS field_data_commerce_price_commerce_product_entity_type, 'commerce_product' AS field_data_field_product_size_commerce_product_entity_type, tid AS tid, weight AS weight FROM {commerce_product} commerce_product LEFT JOIN {taxonomy_term_data} taxonomy_term_data_taxonomy_term_hierarchy ON parent = taxonomy_term_data_taxonomy_term_hierarchy.tid ORDER BY taxonomy_term_data_taxonomy_term_hierarchy_weight ASC, weight ASC
Comments
Comment #1
ibraaheem commentedI am seeing this too whenever i enable the taxonomy formatter.
Any ideas on way out?