Brainy Filter and MySQL

Hello,

I have updated Brainy filter module to 4.6.0 and 4.6.1 and i can't filter nothing in front. In errors logs i receive:

2015-04-18 11:04:15 - PHP Notice: 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 ' value) AS value FROM `oc_bf_aggregate_filters` AS af INNER JOIN `oc_product` AS' at line 1<br />Error No: 1064<br /> SELECT af.group_id AS id, af.value AS val, COUNT(*) AS c, af.type AS type FROM ( SELECT af.group_id, af.product_id, af.type, IF(type = 'STOCK_STATUS' AND p.quantity > 0, , value) AS value FROM `oc_bf_aggregate_filters` AS af INNER JOIN `oc_product` AS p ON (af.product_id = p.product_id) INNER JOIN `oc_bf_found_results` AS exclude ON (af.product_id = exclude.product_id)) AS af GROUP BY af.type, af.group_id, af.value in /home/laffin4/public_html/system/database/mysql.php on line 50

Could you please advise what should i do? The support of this module don't answer

Thank you!

You should try to insist with extension developer imho... no other ways!

M

Thank you for your fast answer. I will try again to contact them.

I will write here the solution, maybe someone will face the same problem.

Thank you!