filter cursor made

-- HikaShop version -- : 2.3.3
-- HikaMarket version -- : 1.4.4
-- Joomla version -- : 3.3.6

Hi,

we have emailcontact with you guys from Hika weeks ago about the problem with the filter in cursor mode. The filter works before an update 2 month ago. We get the information from you that there is a problem within the update and you want to fix it with the next. We make the last update and the problem is still there.

Do you can say us when it will be fixed?

thanks

Hi,

we have a redirection if there is everything wrong on our site. We disable the redirection to see the problem.

now we see the following info:


1054 Error
Unknown column 'b.product_id' in 'on clause' SQL=SELECT DISTINCT b.product_id,a.category_id, a.category_id, a.category_id, pprice.price_value FROM vcdsq_hikashop_product_category AS a LEFT JOIN (SELECT * FROM vcdsq_hikashop_product AS product1 LEFT JOIN vcdsq_hikashop_price AS price1 ON product1.product_id=price1.price_product_id LEFT JOIN vcdsq_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,10,%' OR ISNULL(price1.price_access)) AND product1.product_type='main' GROUP BY product1.product_id ORDER BY price1.price_min_quantity ASC) AS b ON a.product_id=b.product_id LEFT JOIN vcdsq_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id LEFT JOIN vcdsq_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (27,28,29,30,31,32,33) AND (b.product_access = 'all' OR b.product_access LIKE '%,10,%') AND ( ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.19 when b.price_currency_id = '1' and b.product_tax_id = '55' then b.price_value+b.price_value*0.07 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','55') then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' and b.product_tax_id = '11' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.19 when b.price_currency_id = '2' and b.product_tax_id = '55' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.07 when b.price_currency_id = '2' and b.product_tax_id NOT IN ('11','55') then (b.price_value/1.3346) when b.price_currency_id IS NULL then 0 when b.price_currency_id = '3' and b.product_tax_id = '11' then (b.price_value/136.49)+(b.price_value/136.49)*0.19 when b.price_currency_id = '3' and b.product_tax_id = '55' then (b.price_value/136.49)+(b.price_value/136.49)*0.07 when b.price_currency_id = '3' and b.product_tax_id NOT IN ('11','55') then (b.price_value/136.49) end ) >= 1 ) AND ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.19 when b.price_currency_id = '1' and b.product_tax_id = '55' then b.price_value+b.price_value*0.07 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','55') then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' and b.product_tax_id = '11' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.19 when b.price_currency_id = '2' and b.product_tax_id = '55' then (b.price_value/1.3346)+(b.price_value/1.3346)*0.07 when b.price_currency_id = '2' and b.product_tax_id NOT IN ('11','55') then (b.price_value/1.3346) when b.price_currency_id IS NULL then 0 when b.price_currency_id = '3' and b.product_tax_id = '11' then (b.price_value/136.49)+(b.price_value/136.49)*0.19 when b.price_currency_id = '3' and b.product_tax_id = '55' then (b.price_value/136.49)+(b.price_value/136.49)*0.07 when b.price_currency_id = '3' and b.product_tax_id NOT IN ('11','55') then (b.price_value/136.49) end ) BETWEEN 8501 AND 46728 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC