[SOLVED] Error 1064 filter

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.34

Hi, we have an error 1064 when we try to use the a filter.

We have created 2 filters: cursor and checkbox

Cursor filter work on custom product text field and if activated alone it works fine. Then we have created another filter, checkbox that works on another custom product field, in this case a multi-checkbox field.

When we activate the checkbox filter, both filters are correctly displayed but as soon as I select a value in the checkbox filter and filtering I got this error:

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 'OR b.test LIKE '1,%' OR b.test LIKE '%,1' OR b.test LIKE '%,1,%') ORDER BY a.ord' at line 1 SQL=SELECT DISTINCT b.* FROM XXXXX_hikashop_product_category AS a LEFT JOIN XXXXX_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12) AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') AND (b.test = '1' OR OR b.test LIKE '1,%' OR b.test LIKE '%,1' OR b.test LIKE '%,1,%') ORDER BY a.ordering ASC LIMIT 0, 20

What's the problem?

Thanks Jerome, solved!