-- url of the page with the problem -- :
www.bordia.de/schleifmittel/schleifpapie...chwingschleifer.html
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
Hi,
when I create a filter for the category overview I get a syntax error 1064. I've read Forum posts but unfortunately not found the right solution.
Debug:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-undSchwingschleifer_46, min(b.krnunghandundschwingschleifer) as min_KornungHand' at line 1 SQL=SELECT DISTINCT b.product_id,round(min( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '1' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0.19 when pprice.price_currency_id = '1' and b.product_tax_id NOT IN ('11') then pprice.price_value end ),2) as min_Preis_25, round(max( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '1' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0.19 when pprice.price_currency_id = '1' and b.product_tax_id NOT IN ('11') then pprice.price_value end ),2) as max_Preis_25, max(b.schiffart_handschwingschleifer) as max_SchliffartHandSchwingschleifer_41, min(b.schiffart_handschwingschleifer) as min_SchliffartHandSchwingschleifer_41, max(b.krnunghandundschwingschleifer) as max_KornungHand-undSchwingschleifer_46, min(b.krnunghandundschwingschleifer) as min_KornungHand-undSchwingschleifer_46 FROM duyj1_hikashop_product_category AS a LEFT JOIN duyj1_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN duyj1_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 (177) AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.ordering ASC