Zen Cart Logo
Forums / General Questions / I need help with Product Filter by Attribute and price range Error

I need help with Product Filter by Attribute and price range Error

Locked

Views: 832

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
26 Apr 2010, 4:36 AM
#1
shahram avatar

shahram

Zen Follower

Join Date:
Jul 2009
Location:
New York
Posts:
122
Plugin Contributions:
1

I need help with Product Filter by Attribute and price range Error

I have problem with 'Product Filter by Attribute and price range' when i try to searc size or price it give me this error

1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(distinct p.products_id) as total FROM zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_products_attributes pa, zen_products_options po , zen_products_options_values pov LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND (p.products_status = 1 AND ((pa.products_id In (SELECT pa.products_id FROM zen_products_attributes pa LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND ( pa.options_id = 4 AND pa.options_values_id = 59 )))) AND p.products_id = pa.products_id AND p2c.categories_id = 113 AND p.products_quantity > 0 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id) ]