Re: product filter module
I'm trying to get this module to work - the sidebox displays fine with the attributes dropdowns listed but as soon as I try and filter by any of the attribute options I get this error on the page:
1054 Unknown column 'options_1' in 'where clause'
[select count(distinct p.products_id) as total FROM products p, products_description pd, products_to_categories p2c, products_attributes pa, products_options po , products_options_values pov WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = options_1 AND p.products_status =1 AND p.products_quantity > 0 )]
I've Googled this and up to now I have only found a reference to SQL5 and the JOIN function - but this server is SQL4.x and this script doesn't use the JOIN function as far as I can see...?
Any ideas anyone?
By alimtlai in forum All Other Contributions/Addons
Last Post: 21 Jan 2009, 09:37 AM
By SageSystems in forum Addon Payment Modules
Last Post: 14 Dec 2008, 05:01 AM
By sinobeta in forum General Questions
Last Post: 6 Sep 2008, 10:08 AM
By MAV in forum Addon Payment Modules
Last Post: 31 Aug 2006, 09:15 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC