-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : 32.03
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'b.product_id' in 'on clause' SQL=SELECT DISTINCT b.product_id,b.onderwerp, b.leeftijdsfase, b.lichaamsregio, pprice.price_value FROM anat_hikashop_product_category AS a LEFT JOIN (SELECT * FROM anat_hikashop_product AS product1 LEFT JOIN anat_hikashop_price AS price1 ON product1.product_id=price1.price_product_id LEFT JOIN anat_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,9,%' 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 anat_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 (12,13,357,15,280,18,298,279,22,23,24,25,26,27,28,29,30,320,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,347,53,276,55,300,321,277,278,296,282,299,284,285,286,297,291,292,293,294,295,355,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,322,323,324,325,326,327,348,330,328,329,331,332,333,334,343,341,340,339,345,346,349,350,351,352,353,354,362,358,359,360,361,363,364,2) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') 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.21 when b.price_currency_id = '1' and b.product_tax_id = '56' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '57' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '58' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '59' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '60' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '61' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '62' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '63' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '64' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '65' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '66' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '67' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '68' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '69' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '70' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '71' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '72' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '73' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '74' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74') then b.price_value 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.21 when b.price_currency_id = '1' and b.product_tax_id = '56' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '57' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '58' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '59' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '60' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '61' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '62' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '63' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '64' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '65' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '66' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '67' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '68' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '69' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '70' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '71' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '72' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '73' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '74' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74') then b.price_value end ) BETWEEN 1 AND 25721 ORDER BY RAND()
I got an error when I change the Filter Price.
Reproduce:
Go to:
raddtp.nl/anatomie/index.php?option=com_...standaard&Itemid=197
Just change the value in the slider of the Filter Price.
The Click on the button "Filter"
The Error appear.
However this error doesn't appear when I change the other filter values.