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
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
