[Skip to main content](#vessel-content) # Error when i change the price value ## - **[cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile")** - [![cms4biz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34150-cms4biz "View cms4biz's Profile") Topic Author - [ Offline](/forum/user/34150-cms4biz) Less More - Posts: 14 - Thank you received: 0 - - 12 years 3 weeks ago [\#173728](#173728) by [cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile") *[Error when i change the price value](/forum/25-install-update/871979-error-when-i-change-the-price-value#173728 "-- 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.")* was created by *[cms4biz](/forum/user/34150-cms4biz "View cms4biz's Profile")* -- 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](http://raddtp.nl/anatomie/index.php?option=com_hikashop&ctrl=product&task=show&cid=1777&name=foetale-schedel-30e-week-van-de-zwangerschap-op-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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MTk3OS1lcnJvci13aGVuLWktY2hhbmdlLXRoZS1wcmljZS12YWx1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 3 weeks ago [\#173743](#173743) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error when i change the price value](/forum/25-install-update/871979-error-when-i-change-the-price-value#173743 "-- 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.")* Hi, Please try this fix: [ hikashop.com/forum/filters-search/870210...-unknown-column.html](https://hikashop.com/forum/filters-search/870210-1054-unknown-column.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MTk3OS1lcnJvci13aGVuLWktY2hhbmdlLXRoZS1wcmljZS12YWx1ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.142 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)