An error has occurred. 1064 You have an error in your SQL syntax, after upgrading to 2.4.0 with joomla version 3.4.3


  • Default avatar
    john560    
     a year ago
    0

    Hi,
    I am getting this error when I create a coupon. I have tried everything. It seems to have happened when I upgraded to version 2.4.0

    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 'asset_name' at line 26 SQL=SELECT a.coupon_id,a.asset_id,CONVERT(b.product_name USING utf8) AS asset_name,a.order_by FROM cf6ez_awocoupon_asset1 a JOIN cf6ez_hikashop_product b ON b.product_id=a.asset_id WHERE a.asset_type="product" AND a.coupon_id IN (2) UNION SELECT a.coupon_id,a.asset_id,CONVERT(b.category_name USING utf8) AS asset_name,a.order_by FROM cf6ez_awocoupon_asset1 a JOIN cf6ez_hikashop_category b ON b.category_id=a.asset_id AND b.category_type="product" WHERE a.asset_type="category" AND a.coupon_id IN (2) UNION SELECT a.coupon_id,a.asset_id,CONVERT(b.shipping_name USING utf8) AS asset_name,a.order_by FROM cf6ez_awocoupon_asset1 a JOIN cf6ez_hikashop_shipping b ON b.shipping_id=a.asset_id WHERE a.asset_type="shipping" AND a.coupon_id IN (2) UNION SELECT a.coupon_id,a.asset_id,CONVERT(b.coupon_code USING utf8) AS asset_name,a.order_by FROM cf6ez_awocoupon_asset1 a JOIN cf6ez_awocoupon b ON b.id=a.asset_id WHERE a.asset_type="coupon" AND a.coupon_id IN (2) UNION SELECT a.coupon_id,a.asset_id,CONVERT(b.category_name USING utf8) AS asset_name,a.order_by FROM cf6ez_awocoupon_asset1 a JOIN cf6ez_hikashop_category b ON b.category_id=a.asset_id AND b.category_type="manufacturer" WHERE a.asset_type="manufacturer" AND a.coupon_id IN (2) asset_name
    Return to Control Panel

    any help would be greatly appreciated
  • Your avatar
    seyi    
     a year ago
    0

    Hello,

    Please get latest, 2.4.1, this should fix the issue.