Filter in Category - Error 1064

  • Posts: 81
  • Thank you received: 0
8 years 9 months ago #227910

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 9 months ago #227944

Hi,

Would it be possible to see your filter configuration ?
I think that one of your filters got a not safe name and that just renaming it should solve your issue.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 81
  • Thank you received: 0
8 years 9 months ago #227985

Ok

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 9 months ago #228197

Hi,

The problem comes from the - character in the namekey of the filter/custom field.
Recreate them without a - in their names and it should work fine. You can always rename them later on with the - added and it will still work.

The following user(s) said Thank You: bordia

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum