Since upgrading to Hikashop 3.0 we get a 1064 error as follows when using a coupon code
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 ',,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic_value' at line 1 SQL=SELECT a.*,b.* FROM #__hikashop_variant AS a LEFT JOIN #__hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id WHERE a.variant_product_id IN (,,,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic_value
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 ',,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic_value' at line 1 SQL=SELECT a.*,b.* FROM #__hikashop_variant AS a LEFT JOIN #__hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id WHERE a.variant_product_id IN (,,,,,,,,,,,,,,,,,) ORDER BY a.ordering,b.characteristic_value