AWO Coupon 1064 Error since Hikashop Upgrade


  • Default avatar
    rod727    
     7 months ago
    0

    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
  • Your avatar
    seyi    
     7 months ago  last edited 7 months ago
    +1

    Hello,

    There are many problems with Hikashop 3.  I will be releasing a new version for AwoCoupon that fixes all problems in the next 24 hours.  In the mean time, please disable AwoCoupon by unpublishing the plugin 'Hikashop - Awocoupon'.


    Actually, I take that back, the release already happened on Jan 30.  Can you get latest AwoCoupon, 2.5.5?
  • Default avatar
    rod727    
     7 months ago
    0

    Thanks for the quick response.  I have wound back to the previous version of Hikashop for now.