Filter Error 1064 on joomla 3.3.6

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.5.9
-- Error-message(debug-mod must be tuned on) -- : 1064 - 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 '-filter_, round(max( case when pprice.price_currency_id IS NULL then 0 when ppri' 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 = '47' and b.product_tax_id = '30' then pprice.price_value+pprice.price_value*0.25 when pprice.price_currency_id = '47' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0 when pprice.price_currency_id = '47' and b.product_tax_id NOT IN ('30','11') then pprice.price_value end ),2) as min_Harddisk-filter_, round(max( case when pprice.price_currency_id IS NULL then 0 when pprice.price_currency_id = '47' and b.product_tax_id = '30' then pprice.price_value+pprice.price_value*0.25 when pprice.price_currency_id = '47' and b.product_tax_id = '11' then pprice.price_value+pprice.price_value*0 when pprice.price_currency_id = '47' and b.product_tax_id NOT IN ('30','11') then pprice.price_value end ),2) as max_Harddisk-filter_ FROM mrr79_hikashop_product_category AS a LEFT JOIN mrr79_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN mrr79_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 (172,173,174,175,221,222,224,225,226,445,449,448,444,452,460,459,458,457,454,453,846) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC

Hello

I just update hikashop to bussnis 2.3.5 from 2.2.2 hikashop ES.

I am in the process of putting a new page.
But when I put a price filter up with Cursor I get an error 1064

Now I've read forum in store this but I have not fudet a solution to my problem.

I've tried CheckBox instead of the run very slow and coming timeouts when I use this.

Hi,

Please give us more informations about your filter, like a screenshot.
I think that the issue potentially come from the filter name, or something like that.

So you can too potentially try to rename it for testing purposes

HI Xavier

you're right, there were two filter with similar names, and therefore I got the error